Part I: Getting Started with Excel
FIGURE 2.4
You can use the Advanced tab in Excel Options to select a number of helpful input option
settings.
Changing modes
You can press F2 to change between Enter mode and Edit mode. For example, if you’re typ-
ing a long sentence in Enter mode and you realize that you spelled a word wrong, you can
press F2 to change to Edit mode. In Edit mode, you can move through the sentence with
your arrow keys to fix the misspelled word. You can also use the Ctrl+arrow keys to move
one word at a time instead of one character at a time. You can continue to enter text in
Edit mode or return to Enter mode by pressing F2 again, after which the navigation keys
can be used to move to a different cell.
Entering decimal points automatically
If you need to enter lots of numbers with a fixed number of decimal places, Excel has a
useful tool that works like some old adding machines. Access the Excel Options dialog box
and click the Advanced tab. Select the Automatically Insert a Decimal Point check box and
