Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Nmaes and Row Names
This maybe a dumb question, I know how to use the freeze function for cloumn
and rows, however is ther anyway to lock the Column Names, and Row Names in such a way that woulld allow me to view the data in the body of the spread sheet and still be able to have the column and row names visible? -- Thank you for you help MarkM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Nmaes and Row Names
Sounds like you answered your own question -- using Freeze Panes. What's the
difference between "columns & rows" and "column names and row names"? "MSM" wrote in message ... This maybe a dumb question, I know how to use the freeze function for cloumn and rows, however is ther anyway to lock the Column Names, and Row Names in such a way that woulld allow me to view the data in the body of the spread sheet and still be able to have the column and row names visible? -- Thank you for you help MarkM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Nmaes and Row Names
Assumimg you have titles in row 1 and titles in column A.
Select B2 and WindowFreeze Panes Gord Dibben MS Excel MVP On Thu, 24 May 2007 11:20:00 -0700, MSM wrote: This maybe a dumb question, I know how to use the freeze function for cloumn and rows, however is ther anyway to lock the Column Names, and Row Names in such a way that woulld allow me to view the data in the body of the spread sheet and still be able to have the column and row names visible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel |