EXPERT TIPS ON EXCEL

1. Lock specific rows and columns in Excel 2007

In a large worksheet, you may like to hold the rows and columns containing labels or headings constant, while you scroll through the data associated with them. To lock a row, select the row below it; to lock a column, select the column to its right. To lock both row and column, select the cell below and to the right of the row and column. Go to the View tab and the Window group and click the arrow below Freeze Panes. To lock a single row, click Freeze Top Row. To lock a single column, click Freeze First Column. To lock more than one row or column, or a row and column together, click Freeze Panes. You can follow the same process to unfreeze the locked rows and columns.

2.  View two worksheets together in Excel 2007

If both worksheets are in the same workbook, go the View tab > Window group, and click New Window. Then, in the View tab > Window group, click View Side by Side. If you’d like to scroll both worksheets simultaneously, click Synchronous Scrolling.

If the two worksheets are in different workbooks, open both workbooks. Go the View tab Window group and click View Side by Side. In each workbook window, click the worksheet that you want to view. Click Synchronous Scrolling to scroll through both worksheets simultaneously.

3. View multiple worksheets in Excel 2007

Open the workbook or workbooks that contain the worksheets that you want to view.

If all the worksheets are in the same workbook, click one of them. Then go to the View tab > Window group and click New Window. Repeat this for all the worksheets that you want to view together.

If the worksheets are in different workbooks, go to the View tab > Window group and click Arrange All. Under Arrange, click the option of your choice. To view sheets only in the active workbook, select the checkbox against Windows of active workbook.