![]() |
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 |
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 |
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? |
All times are GMT +1. The time now is 07:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com