· Learn how to change the default file locations
· Learn how to change the frequency of automatic backups
· Learn how to change the default file format
· Learn how to change the size of the most recently-used file list
· Learn how to change the direction the cursor moves after pressing the "Enter" key
File | Options | Save | Default File Location.
You should always save your files to your network drive so you can retrieve your files from any computer on campus. Enter:
In the "Default File Location" box. The "yourUsername" needs to be replaced by your user name.
Excel will make a backup of your work every 10 minutes by default. Change this to one minute so you never have to worry about losing more than a minute's worth of work. Choose:
File | Options | Save | Save Autorecover Information Every
Make sure the check box is on, and change the number of minutes to 1.
If you will be exchanging files with people who use an older version of Excel, you can make Excel always save your files in an older format. Choose:
File | Options | Save | Save Files in this format:
From the drop-down list, choose:
Excel 97-2003 Workbook (.xls)
NOTE: A better solution is to have the person using the old version of Excel go to Microsoft's web site and download an Excel add-in that allows older versions of Excel to read Excel 2007 files.
Excel keeps track of your most recently-used files on the File menu. You can set this number to anything in the range 0-50 by doing the following:
File | Options | Advanced | Display | Show this number of recent documents
And enter the number that you want.
By default, Excel moves the cursor down to the next cell when you press the "Enter" key. However, there are times when you may be entering rows of data rather than columns of data and you want the cursor to move to the right instead of down (Excel also gives you the option of moving the cursor up or left, but those options are probably not used very often). To change the direction the cursor moves after pressing "Enter", select the following from the menu:
File | Options | Advanced | Editing Options | After pressing Enter, move selection
Enter the direction that you want.