To change Excel 2007 default file location, follow these steps:

1. Click the  Microsoft Office Button.

2. Click Excel Options.

3. In Excel Options window (left side) click Save.

4. In the text box labeled Default File Location , specify the path for the required location.

If you have a worksheet with a heading row at the top, then you may want to freeze the heading row while scrolling throw the data rows below it. To achieve that follow these simple steps.

1. In the View tab, Window group click Freeze Panes.

2. From the drop down list select Freeze Top Row.

3. A dark line will show below the header row indicating where the freeze is established. The row above the line is frozen, and the rows below the line are scrollable.

If you have a large worksheet, then you may want to freeze the worksheet at one point while scrolling throw the rest of the rows below it. To achieve that follow these steps.

1. Select the top row of the area which you want to be scrollable (or just a cell in that row). I.e. all rows including and below the selected row will be scrollable, all rows above the selected row will be frozen.

2. In the View tab, Window group click Freeze Panes.

3. From the drop down list select Freeze panes.

4. A dark line will show above the selected row indicating where the freeze is established. The rows above the line are frozen, and the rows below the line are scrollable.