Using Transition Keys to Align Text

ID: Q82009

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

SUMMARY

When the Transition Navigation Keys (Microsoft Excel 5.0) or the Alternate Navigation Keys (Microsoft Excel version 4.0) option is enabled, you can use the " (quotation mark), ^ (accent circumflex), and \ (backslash) characters to convert a number to a text string or to change the text alignment in the cell.


   To align the text this way                 Use this character
   ------------------------------------------------------------

   Right                                      "
   Center                                     ^
   Align it and fill the cell                 \

MORE INFORMATION

With Transition Navigation Keys or Alternate Navigation Keys, Microsoft Excel provides an alternative set of keyboard methods for moving around the worksheet and for entering formulas and data. To activate this option, follow the appropriate procedure below.

When you enable this option, some the functionality of some keys, such as HOME and END, will change. Microsoft Excel supports all 1-2-3 text and alignment characters (', ^, ", and \). The apostrophe ('), in this mode, will align the text in a cell to the left.

Microsoft Excel 5.0

From the Tools menu, choose Options, and select the Transition tab.

Under Settings, select the Transition Navigation Keys check box.

Microsoft Excel 4.0, 4.0a

From the Options menu, choose Workspace, and select the Alternate Navigation Keys check box.

REFERENCES

In Microsoft Excel 5.0, for more information about Transition Navigation Keys, choose the Search button in Help, and type:

Lotus 1-2-3, transition navigation keys

"User's Guide 1," version 4.0, pages 568-570

Additional query words: 4.00a


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 24, 1999