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

excel

ResolvedVersion 2003

Sam has attended:
Excel Intermediate course

Excel

How do I freeze Panes?

Edited on Thu 24 Apr 2008, 07:10

RE: Excel

Hello Sam, welcome to the forum, I hope you enjoyed your course, in 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.
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)
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.
Related to Freeze Panes is Split Screen which allows you to view up to 4 related areas of your worksheet, check it out too.
I hope that has helped, if so please click the Resolved link, best regards Pete.

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

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.