freeze panes

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freeze panes

Freeze panes

resolvedResolved · Low Priority · Version 2007

Heather has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Word Advanced course

Freeze panes

How do I freeze panes for numberous tabs on an excel spreadsheet?

RE: 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,


RE: Freeze panes

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



Tue 19 Jul 2011: Automatically marked as resolved.


Training courses


Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Server loaded in 0.06 secs.