Freeze panes

The UK's most regular instructor-led training courses.
Training information: excel+and+powerpoint+courses+uk · Excel-courses-london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Freeze panes

Susan has attended:
Excel Introduction course

by - delegate Susan [1 post] (2008 Mar 17 Mon, 17:03) Reply

How do you freeze panes vertically and horizontally?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Freeze panes

by - trainer Pete platinum contributer [864 posts] (2008 Mar 18 Tue, 09:14) Reply

Hi Susan, Thank you for your post, welcome to the forum, in answer to your question, to freeze panes in a worksheet consider the location of the active cell, when you freeze a pane; you lock the cells to the left of and above this cell. To freeze the area required, select the cell as per above, then go to the menu command Window> Freeze Panes, you can now scroll left and right and up and down in your worksheet with the selected area always in view. To remove the Freeze go to the command Window> Un Freeze panes.
Take a moment to try the other option which is Split this allows you to view different areas of the worksheet at the same time. I hope that helps, best regards Pete.

· Advanced Excel Training - takes you to the next level
· Excel Macros for the Non-Programmer
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees
· Customized Financial Excel Courses in London

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

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Rate this page: