MENU AT TOP

[eman]

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

 

[Gord Dibben]

What type of menu?

Do you mean just a row of titles?

Add the titles to row 1 then select A2 and Window>Freeze Panes.


Gord Dibben MS Excel MVP

 

[eman]

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

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

 

[Peo Sjoblom]

Select A3 and freeze


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

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

 

[eman]

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]

Previous to selecting C3 did you freeze panes at A2?

You have go to Window>Unfreeze Panes then select C3 and Window>Freeze Panes


Gord

 

[eman]

Hi,

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

Thanks very, very much!