MENU AT TOP
 

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

Select A3 and freeze


--


Regards,


Peo Sjoblom


"eman" wrote in message
...
Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

The freezing rules are..............

Everything left of and above the selected cell will remain in view when freezing
panes.

B2 to freeze row 1 and column A

C3 to freeze columns A & B and rows 1 & 2


Gord


On Wed, 5 Dec 2007 23:49:19 +0100, "eman" wrote:

Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

Thnaks for your help....

I can only freeze the top row.
I tried C3 as Gord suggested but still only one row at the top is freezing.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
The freezing rules are..............

Everything left of and above the selected cell will remain in view when
freezing
panes.

B2 to freeze row 1 and column A

C3 to freeze columns A & B and rows 1 & 2


Gord


On Wed, 5 Dec 2007 23:49:19 +0100, "eman" wrote:

Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

Previous to selecting C3 did you freeze panes at A2?

You have go to WindowUnfreeze Panes then select C3 and WindowFreeze Panes


Gord

On Thu, 6 Dec 2007 01:51:02 +0100, "eman" wrote:

Thnaks for your help....

I can only freeze the top row.
I tried C3 as Gord suggested but still only one row at the top is freezing.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
The freezing rules are..............

Everything left of and above the selected cell will remain in view when
freezing
panes.

B2 to freeze row 1 and column A

C3 to freeze columns A & B and rows 1 & 2


Gord


On Wed, 5 Dec 2007 23:49:19 +0100, "eman" wrote:

Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the whole
width) with item names. Is it possible to make this menu visible all the
time at the top.... meaning when I scroll down or up the page, the menu
doesn't move so I can see the item names all the time.

Thanks

MENU AT TOP
 

Hi,

Ok got it now... because I was still clicking on Freeze Top Row instead of
Freeze Panes.

Thanks very, very much!


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Previous to selecting C3 did you freeze panes at A2?

You have go to WindowUnfreeze Panes then select C3 and WindowFreeze
Panes


Gord

On Thu, 6 Dec 2007 01:51:02 +0100, "eman" wrote:

Thnaks for your help....

I can only freeze the top row.
I tried C3 as Gord suggested but still only one row at the top is
freezing.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
The freezing rules are..............

Everything left of and above the selected cell will remain in view when
freezing
panes.

B2 to freeze row 1 and column A

C3 to freeze columns A & B and rows 1 & 2


Gord


On Wed, 5 Dec 2007 23:49:19 +0100, "eman" wrote:

Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the top?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
m...
What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and WindowFreeze Panes.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 20:34:22 +0100, "eman" wrote:

Hi,

I'm not sure if this is possible!

I would like to add a horizzontal menu at the top of the page (the
whole
width) with item names. Is it possible to make this menu visible all
the
time at the top.... meaning when I scroll down or up the page, the
menu
doesn't move so I can see the item names all the time.

Thanks