Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
If each column has a name (and these are in Row 1) is there any way to keep these so that they view at the top of the page even if you scroll down (in the same way that the A, B, C..... do now)? For example, if you have Jan, Feb, March etc. in row 1 column A, B, C etc. it is difficult to tell which month the contents of a cell in say Row 50 belongs to once you scroll out of sight of the names of the months. Thanks. -- pdgood ------------------------------------------------------------------------ pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
Hi,
select A2 then go Window|Freeze Panes. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
What you want is to "Freeze" the row at the top of the sheet. To do this, place the cell pointer in cell A2 (or the row below the last row you want 'frozen') and from the main menu click on Window and select "Freeze Panes". Now, scrolling down will leave the top row visible. Note that this can also be used to 'freeze' columns from scrolling to the left (which is why you need to be in column A when selecting 'Freeze Panes' if you don't want any columns frozen). HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
"pdgood" wrote in
message ... If each column has a name (and these are in Row 1) is there any way to keep these so that they view at the top of the page even if you scroll down (in the same way that the A, B, C..... do now)? For example, if you have Jan, Feb, March etc. in row 1 column A, B, C etc. it is difficult to tell which month the contents of a cell in say Row 50 belongs to once you scroll out of sight of the names of the months. Select row 2, then Windows menu/ Freeze Panes. You can do the same for columns, so if you click in cell C4, for example, & then Freeze Panes, rows 1 to 3 and columns A & B will be fixed. -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
If you go to Cell A2, then go to the Window menu and choose Freeze Panes,
this will 'lock' Row 1 into place. HTH Sheila www.c-i-m-s.com MS Office training - London "pdgood" wrote: If each column has a name (and these are in Row 1) is there any way to keep these so that they view at the top of the page even if you scroll down (in the same way that the A, B, C..... do now)? For example, if you have Jan, Feb, March etc. in row 1 column A, B, C etc. it is difficult to tell which month the contents of a cell in say Row 50 belongs to once you scroll out of sight of the names of the months. Thanks. -- pdgood ------------------------------------------------------------------------ pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
Thanks very much for all replies but....that option is grayed out. I tried selecting a single cell, a row, a column, a group of cells but it always remains grayed out. I am using Excel 2004 for Mac. -- pdgood ------------------------------------------------------------------------ pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
By the way, the sheet I am trying on is NOT password protected. I know that that would cause it to be grayed out, but I can't think of anything else. -- pdgood ------------------------------------------------------------------------ pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
Actually, having the worksheet protected does not disable WindowFreeze Panes.
Having the Workbook structure and windows protected will disable the Freeze Panes feature. Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 14:26:19 -0400, pdgood wrote: By the way, the sheet I am trying on is NOT password protected. I know that that would cause it to be grayed out, but I can't think of anything else. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column names
Thanks, Gord. But I've tried it on new pages where nothing whatsoever is protected. I'm not an expert, but I don't think that that is the issue. I'm at a loss to explain what else would prevent this from working. -- pdgood ------------------------------------------------------------------------ pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623 View this thread: http://www.excelforum.com/showthread...hreadid=559906 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel |