excel training course - Freeze panes.3-D formulas

Hi Brian

Thanks for your question.

3D formulas refer to the same cell on more than one sheet. For example, if you wanted to add together what's in cell B4 on three different sheets and display the result in a fourth sheet.

On the fourth sheet, type =sum(

Click on the sheet tab for the first sheet, hold down Ctrl and select the tabs for second and third sheet, then click cell B4 and press Enter.

To use Freeze Panes, select the cell that is to the right of the column/s you wish to freeze and below the row/s you wish to freeze and then go to Window - Freeze Panes. Go to Window - Unfreeze Panes to remove.

Amanda