MENU AT TOP

  • Thread starter Thread starter eman
  • Start date Start date
E

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
 
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
 
Hi....and thanks very much, that is eaxactly what I want!

Is it possible to freeze two rows or more at the 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
 
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.
 
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
 
Hi,

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

Thanks very, very much!
 
Back
Top