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)

"cloudsofclaire" <(E-Mail Removed)> wrote in message
news:8DECD8C0-5394-4628-AF1E-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
> news:8DECD8C0-5394-4628-AF1E-(E-Mail Removed)...
> > 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 for the kind words....I'm glad I could help.

Regards,

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

"cloudsofclaire" <(E-Mail Removed)> wrote in message
news:E020D53D-7BD3-4E2D-9AC0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
>> message
>> news:8DECD8C0-5394-4628-AF1E-(E-Mail Removed)...
>> > 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 it works

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

<(E-Mail Removed)> wrote in message
news:ad22fd5c-2b4a-4af1-b6fb-(E-Mail Removed)...
> Thanks it works

I think you posted this to the wrong thread.

Pete

On Apr 29, 11:34*am, "Aaron Hodson \(Coversure\)"
<aa...@coversure.co.uk> 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
>
> <damnjan.milutino...@gmail.com> wrote in message
>
> news:ad22fd5c-2b4a-4af1-b6fb-(E-Mail Removed)...
>
>
>
> > Thanks it works - Hide quoted text -
>
> - Show quoted text -

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

Originally Posted by 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" <(E-Mail Removed)> wrote in message
news:8DECD8C0-5394-4628-AF1E-(E-Mail Removed)...
> 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!