Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Well if you don't know whether you can't find the Window menu, or whether
you do have a Window menu on which you can't see the menu item "Freeze Panes", there's not much likelihood that we can help you. -- David Biddulph "John Savy" wrote in message ... That's exactly correct. What I'm trying to tell you is that in Excel 97 I can't find the Window menu, or that on the Window menu I can't see the menu item "Freeze Panes". -- John "David Biddulph" wrote: Perhaps you missed the part where I said: " If you wish to freeze the top 2 rows and the left hand two columns, select cell C3, then go to the Window menu and select "Freeze Panes". In general, select the cell below the rows you wish to freeze, and to the right of the columns you wish to freeze, then go to the Window menu and select "Freeze Panes"." ? Are you trying to tell us that in your Excel 97 you can't find the Window menu, or that on the Window menu you can't see the menu item "Freeze Panes"? You can find a screen grab of the Excel 97 menus at http://www.ngfl.ac.uk/resources/excel/excelpage3.pdf and at http://www.smartcomputing.com/editor...0.jpg&caption= -- David Biddulph "John Savy" wrote in message ... Where or how do I found this command "freeze pan", or any other command in Excel 97? -- John "David Biddulph" wrote: If you wish to freeze the top 2 rows and the left hand two columns, select cell C3, then go to the Window menu and select "Freeze Panes". In general, select the cell below the rows you wish to freeze, and to the right of the columns you wish to freeze, then go to the Window menu and select "Freeze Panes". -- David Biddulph "John Savy" wrote in message ... Could you elaborate more on the process, Thanks -- John "Gord Dibben" wrote: Toast's suggestion is incorrect. Select B1 to freeze column A Select B2 to freeze column A and row 1 This is for Excel 97 through 2003 Gord Dibben MS Excel MVP On Sun, 25 Jan 2009 11:47:01 -0800, John Savy wrote: No, I don't have the 03 version. I know 97 has this option as well, and I used it in the past, but I have forgotten how it was. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions |