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

excel

ResolvedVersion 2000

Alicia has attended:
Excel Intermediate course

Excel

how do i freeze panes

RE: excel

Hello Alicia, welcome to the forum, to answer to your question;
Freezing panes, When you work with large worksheets, it can be annoying as you scroll right or down to no longer be able to see the headings (row or column) Freeze Panes allows you to fix the headings so that you can see them no matter how far to the right or down you scroll.
1. First you must decide which area of the worksheet you wish to Freeze, the cell to select must be directly under or to the right of the frozen area/s (you can freeze both above and to the right of a chosen cell at the same time)
2. Once you have decided on which cell, select it, and then go to the Menu command Window>Freeze Panes.
You will notice a thin black border either to the right of and/or below your frozen area/s, scrolling to the right or down will now keep your Frozen areas on screen.
I hope that has helped, if so please click the Resolved link, best regards Pete.

 

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:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

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.12 secs.