freeze frames

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

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

Freeze frames

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips


Server loaded in 0.08 secs.