Tip of the Month: Changing Excel Default Settings

Posted on 03. Sep, 2008 by in Windows Resources/Tips

Number of Worksheets:  Excel’s default is three worksheets and 99% of the time you probably only need one worksheet. If you send the file to someone, they are most likely to click on the other two worksheets to see if there is content on them. To change the default to one worksheet:

  • Choose Tools, Options. Select the General tab, set Sheets in new workbookOK. to 1 – then
  • For Excel 2007:  Choose Office Button, then Excel Options. Select the Popular tab, then set Include this many sheets to 1. Then choose OK.

Controlling the Enter Key:  Excel’s default setting moves your selection down one cell each time you press Enter. This is useful when you are entering numbers in a column, but rarely useful at any other time. To prevent Excel from moving your selection down a row each time you press Enter:

  • Choose Tools, Options. In the Edit tab, remove the checkmark from Move selection after enter. Then choose OK.
  • For Excel 2007: Choose Office Button, then Excel Options. Select the Advanced tab. Remove the checkmark from After pressing enter, move selection. Then choose OK.

Change the default file folder when you open a new file: Excel’s default file path is c:/documents and settings/owner/my documents. Most likely you store your files in another file folder. To change this default so that Excel looks closer to where you typically save files, follow these steps:

  • Choose Tools, Options. Choose the General tab. In the box labeled Default file location, enter the full path to your desired default folder. Then choose OK.
  • For Excel 2007: Choose Office Button, Excel Options. Select the Save tab. In a box labeled Default file location, enter the full path to your desired default folder. Then choose OK.

Comments are closed.