Change the Default File Location

Many users find that they tend to open workbooks from the same folder on their computer. If that Windows Vista folder isn't Documents (My Documents in Windows XP), you can change the folder that Microsoft Office Excel 2007 displays when you want to open or save a workbook. Here’s how:
1. Click the Office button.
2. Click Excel Options.
3. In the left column, click Save.
4. Type the desired location in the Default file location box.

Fill In the Blanks in Spreadsheets the Easy Way

1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.