Freeze panes

Hello Heather,

You can only Freeze Panes for 1 sheet at a time I'm afraid as the Freeze position required tends to vary from sheet to sheet.

To Freeze Panes, position your cursor in the appropriate cell and click the View Tab and then the the down arrow on Freeze Panes in the Window Group on the View ribbon. Freeze Panes is the first option on the list and results in the panes freezing above and to the left of your current cell. Alternatively, you can freeze just the Top Row or the First Column without having to select a particular cell first.

I hope this is helpful.

Kind regards,

Ruth

Hi Heather

Thank you for your question

First select the cell that is immediately below the last row you want frozen and to the right of the last column you want frozen.

Then go to the View ribbon and click on freeze panes in the window group

Regards

Stephen