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

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.

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

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" wrote in message
...
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.

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

Fantastic, you're a genius.

"Ron Coderre" wrote:

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" wrote in message
...
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.

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

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

Regards,

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

"cloudsofclaire" wrote in message
...
Fantastic, you're a genius.

"Ron Coderre" wrote:

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" wrote in
message
...
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.

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

Thanks it works :)

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

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

wrote in message
...
Thanks it works :)

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

I think you posted this to the wrong thread.

Pete

On Apr 29, 11:34*am, "Aaron Hodson \(Coversure\)"
wrote:
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

wrote in message

...



Thanks it works :)- Hide quoted text -

- Show quoted text -