freeze frames

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


 

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.