Microsoft Office Tutorials and References
In Depth Information
Techniques for entering data
Navigation Keys are turned on. To do so, click the File tab, click Options, select the
Advanced category, and then scroll down to the Lotus Compatibility area and select the
Transition Navigation Keys check box.
TABLE 6-5 Text-alignment prefix characters
Left-aligns data in the cell.
" (quotation mark)
Right-aligns data in the cell. (See the following note.)
Centers data in the cell. (See the following note.)
Repeats characters across the cell. (See the following note.)
You’ll find the Humongous.xlsx file with the other examples on the companion website.
When you create a numeric entry that starts with an alignment prefix character, a small
lag appears in the upper-left corner of the cell, indicating that the cell has a problem you
might need to address. When you select the cell, an error button appears to the right.
Clicking this button displays a menu of specific commands. (Refer to Figure 6-10.) Because
the apostrophe was intentional, you can click Ignore Error.
If a range of cells shares the same problem, as in column A in Figure 6-10, you can
select the entire cell range and use the action menu to resolve the problem in all the
cells at the same time. For more information, see “Using custom AutoCorrect actions”
in Chapter 8.
If you ever want to use characters in Excel that are not on your standard computer
keyboard, you’re in luck. Click the Insert tab on the ribbon, and in the Symbols group, click the
Symbol button to gain access to the complete character set for every installed font on your
computer. Figure 6-11 shows the Symbol dialog box.