Thread: MENU AT TOP
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
eman eman is offline
external usenet poster
 
Posts: 13
Default 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