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

freeze frames

ResolvedVersion 2003

Anne has attended:
Excel Intermediate course

Freeze frames

How do i begin?

RE: Freeze frames

Hello Anne
Thank you for your question

To lock rows, select the row below where you want the split to appear.
To lock columns, select the column to the right of where you want the split to appear.

To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

On the Window menu, click Freeze Panes.
To unlock rows, click Unfreeze Panes on the Window menu.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

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.