| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel -My paste menu is not the norm. The menu is different. | Setting up and Configuration of Excel | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| my menu disappear. How can I refind my menu?? | Excel Discussion (Misc queries) | |||
| Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Linear Mode
