panes

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Panes

Panes

resolvedResolved · Low Priority · Version 2003

Humphrey has attended:
Excel Introduction course
PowerPoint Intermediate Advanced course

Panes

Pls could you tell me how to freeze panes?

Thanks

RE: Panes

Hello Humphrey

Thank you for your question and welcome to the forum.

Firstly you need to select a cell which represents the position in the spreadsheet that you want to have the freeze panes set at.

For example:
- If you want to see row 1 when you scroll down, select cell A2.

-If you want to see column A when you scroll across, select cell B1.

- If you want to see both row 1 and column A when you scroll, select cell B2 (the cell that is both below the row/s you wish to see when scrolling; and to the right of the column/s you wish to see when scrolling).

Then go to Window - Freeze Panes.

I hope this helps.

Kind regards
Amanda

Mon 26 Oct 2009: Automatically marked as resolved.


 

Excel tip:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

View all Excel hints and tips


Server loaded in 0.08 secs.