G Gord Dibben Oct 10, 2007 #2 You don't. Workaround. Enter titles in row1. Select A2 and Window>Freeze Panes Tools>Options>View. Uncheck row and column headers. Gord Dibben MS Excel MVP
You don't. Workaround. Enter titles in row1. Select A2 and Window>Freeze Panes Tools>Options>View. Uncheck row and column headers. Gord Dibben MS Excel MVP
T T. Valko Oct 10, 2007 #3 For all intents and purposes, you can't. You can choose to not display the current row and column headers any use your own *BUT* you'd still have to refer to cells using the standard headers. Tools>Options>View>Row & column headers
For all intents and purposes, you can't. You can choose to not display the current row and column headers any use your own *BUT* you'd still have to refer to cells using the standard headers. Tools>Options>View>Row & column headers
D David Biddulph Oct 10, 2007 #4 And if you want to enter row headers too, do so in column A, and select B2, rather than A2, before freezing panes.
And if you want to enter row headers too, do so in column A, and select B2, rather than A2, before freezing panes.
