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

TheMSsForum.com: The Microsoft Software Forum

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

Re: How do I stop the headings moving when I scroll down? by Ron

Ron
Fri Mar 14 09:29:38 CDT 2008

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" <cloudsofclaire@discussions.microsoft.com> wrote in message
news:8DECD8C0-5394-4628-AF1E-7321B8B61FDA@microsoft.com...
> 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.


Top

Re: How do I stop the headings moving when I scroll down? by cloudsofclaire

cloudsofclaire
Fri Mar 14 09:52:00 CDT 2008

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" <cloudsofclaire@discussions.microsoft.com> wrote in message
> news:8DECD8C0-5394-4628-AF1E-7321B8B61FDA@microsoft.com...
> > 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.
>
>
>
Top

Re: How do I stop the headings moving when I scroll down? by Ron

Ron
Fri Mar 14 09:58:10 CDT 2008

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

Regards,

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

"cloudsofclaire" <cloudsofclaire@discussions.microsoft.com> wrote in message
news:E020D53D-7BD3-4E2D-9AC0-AE3C9380C0FF@microsoft.com...
> 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" <cloudsofclaire@discussions.microsoft.com> wrote in
>> message
>> news:8DECD8C0-5394-4628-AF1E-7321B8B61FDA@microsoft.com...
>> > 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.
>>
>>
>>


Top

Re: How do I stop the headings moving when I scroll down? by damnjan

damnjan
Tue Apr 29 02:24:58 CDT 2008

Thanks it works :)
Top

Re: How do I stop the headings moving when I scroll down? by Aaron

Aaron
Tue Apr 29 05:34:50 CDT 2008

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.milutinovic@gmail.com> wrote in message
news:ad22fd5c-2b4a-4af1-b6fb-f9a42b04585e@a23g2000hsc.googlegroups.com...
> Thanks it works :)

Top

Re: How do I stop the headings moving when I scroll down? by Pete_UK

Pete_UK
Tue Apr 29 05:47:17 CDT 2008

I think you posted this to the wrong thread.

Pete

On Apr 29, 11:34=A0am, "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-f9a42b04585e@a23g2000hsc.googlegroups.com...
>
>
>
> > Thanks it works :)- Hide quoted text -
>
> - Show quoted text -

Top