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

pane freeze

ResolvedVersion 2010

Sid has attended:
Excel Introduction course
Excel Intermediate course

Pane freeze

i would like to know how to freeze/unfreeze a pane

RE: pane freeze

Hi Sid

Thank you for your question

First select the cell that is immediately below the last row you want frozen and immediately 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

To unfreeze go to the View ribbon and click on unfreeze panes in the window group

Regards

Stephen

Tue 19 Jul 2011: Automatically marked as resolved.

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.