Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Freeze panes

Resolved · Low Priority · Version 2007

Reply Tue 12 Jul 2011, 16:43Delegate Heather said...

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?

For upcoming training course dates see: Pricing & availability

Reply Wed 13 Jul 2011, 16:21Trainer Ruth said...

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,

Ruth

Reply Wed 13 Jul 2011, 16:21Trainer Stephen said...

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

Regards

Stephen

Tue 19 Jul 2011: Automatically marked as resolved.

Excel articles

· Become A Budding Picasso Using Excel
· VBA Excel 2007
· What Is A Sparkline And How Do They Work?
· Learn The Secrets Of COUNT Functions In Excel
· How To Use Excel To Create Large SQL Insert Statements

Please browse our web site to find out more about
excel+course+london and other Microsoft training courses.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips