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

Freezing panes

ResolvedVersion 2010

Wed 13 Jul 2011, 08:32 Delegate Lara said...

Lara has attended:
Excel Introduction course

Freezing panes

How do I freeze panes an excel spreadsheet?

Wed 13 Jul 2011, 09:53 Trainer Stephen said...

RE: Freezing panes

Hi Lara

Thanks 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

Hope this helps

Regards

Stephen

Tue 19 Jul 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Freezing panes

Freezing panes

RE: Freezing panes

Excel articles

Excel tip:

Using Alt in Save Dialog Box