How do I stop the headings moving when I scroll down?

  • Thread starter Thread starter cloudsofclaire
  • Start date Start date
C

cloudsofclaire

What I want to do is set up a couple of my bohemoth spreadsheets so that when
I scroll down to look at the values below the bottom of the sheet the
headings don't disappear - basically I want to 'anchor' them somehow.
 
Try this:

Set the headings where your want them on the screen
Select the first cell below the headings

Example:
If you always want to see rows 1:3 and column A
Select cell B4

From the Excel Main Menu:
<window><freeze panes>

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Fantastic, you're a genius.

Ron Coderre said:
Try this:

Set the headings where your want them on the screen
Select the first cell below the headings

Example:
If you always want to see rows 1:3 and column A
Select cell B4

From the Excel Main Menu:
<window><freeze panes>

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
Thanks for the kind words....I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Cannot get this to work...

To explain in a little more detail, my table ranged from A1 to O50.

Data from F3:H3 to F50:H50 is required for formatting.

I need the lowest figure being highlighted out of F3,G3,H3
Then again out of F4,G4,H4
etc down to row 50.

Thanks

Aaron
 
If you always want to see rows 1:1 and column A
Select cell B4

From the Excel Main Menu:
<window><freeze panes>
 
Ron Coderre said:
Try this:

Set the headings where your want them on the screen
Select the first cell below the headings

Example:
If you always want to see rows 1:3 and column A
Select cell B4

From the Excel Main Menu:
<window><freeze panes>

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"cloudsofclaire" <[email protected]> wrote in message
news:[email protected]...
> What I want to do is set up a couple of my bohemoth spreadsheets so that
> when
> I scroll down to look at the values below the bottom of the sheet the
> headings don't disappear - basically I want to 'anchor' them somehow.
Click to expand...
Thanks, your great!
 
Back
Top