Excel: @ Entered When Promoting and Demoting Rows

ID: Q85079


The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0


SUMMARY

When you create an outline in Microsoft Excel for Windows, you can use the numeric keypad to promote and demote rows. Select the entire row by clicking on the row header, then press either ALT+SHIFT+6 (on the numeric keypad) to demote the row or ALT+SHIFT+4 to promote the row. When pressing these keystrokes successively without releasing the ALT key, the "@" symbol may be entered into the first cell of the row.

NOTE: In order for the above procedure to work, NUM LOCK must be turned off.


MORE INFORMATION

Microsoft Excel interprets the keystrokes as an ANSI code (ALT+064, which represents the "@" character) and enters the symbol into the cell. To delete the symbol, press the ESC key or click on the Cancel box to cancel the cell edit.

Microsoft is researching this problem and will post new information here as it becomes available.


REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, page 566

"Microsoft Excel User's Guide," version 3.0, pages 237-238

Additional query words: 3.0 4.0

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 24, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.