Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Freezing Panes

To keep the column and row headings in place while you scroll, click your cursor in the cell below the row of column headings you want to freeze and to the right of the column of row headings you want to freeze. Click on the Window drop-down menu and choose Freeze Panes, your row and column headings will now stay in place while you scroll down and across your data.

A more powerful way of keeping part of your worksheet stationary involves splitting the window.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk