• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Customizing Excel to Fit You... > Changing the Default Excel Settings

Changing the Default Excel Settings

Excel enables you to customize many of the default settings for the program. Each of these features is controlled by settings in the Options dialog box. To open this dialog box, choose Tools, Options. The following list describes some suggested changes:

  • Move data entry in a different direction— By default, when you press Enter after typing a cell entry, Excel accepts the entry and moves down to the next cell in that column. In many workbooks, however, moving to the next cell to the right, left, up, or even disabling this option completely would be more useful. You can change the direction that the cell pointer moves. Click the Edit tab in the Options dialog box. In the Direction box, select the direction you want the cell pointer to move, as shown in Figure 27.1. To prevent the cell pointer from moving, deselect the Move Selection After Enter option.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint