Excel: Characters Are Repeated in a Cell

Last reviewed: November 29, 1994
Article ID: Q64356

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

When Fill is selected for the Alignment command (on the Format menu), Microsoft Excel repeats the values or characters within a cell until the cell is full.

This can cause unexpected behavior if a cell has had this formatting inadvertently applied. After characters are entered, the cell is filled with repeats of those characters until it is full.

If this is not the desired formatting, set the alignment attribute to anything other than Fill, as follows:

From the Format menu, choose Alignment.
Select any alignment attribute other than Fill.
Choose the OK button.

For more information on the Alignment command, see page 228 of the "Microsoft Excel User's Guide 1" version 4.0 manual. If you are using version 3.00, see page 186 in the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see page 292 in the "Microsoft Excel Reference" version 2.2 manual.

KBCategory: kbusage
KBSubcategory:
Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20
3.0 3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.