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

[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.

 

[Ron Coderre]

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]

Fantastic, you're a genius.

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)

 

[Ron Coderre]

Thanks for the kind words....I'm glad I could help.

Regards,

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

 

[damnjan.milutinovic]

Thanks it works

 

[Aaron Hodson \(Coversure\)]

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

 

[Pete_UK]

I think you posted this to the wrong thread.

Pete

 

[thiyagarajan]

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

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

 

[thiyagarajan]

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.

Thanks, your great!