how do i change the column headings from A, B, C etc to what i want them to be eg, Name, Address etc
T thickasawhaleomlette Jan 18, 2005 #1 how do i change the column headings from A, B, C etc to what i want them to be eg, Name, Address etc
P Peo Sjoblom Jan 18, 2005 #2 You can't, you can remove them and use the first row and column to create your own, to remove the built in do tools>options>view and uncheck row & column headers Regards, Peo Sjoblom
You can't, you can remove them and use the first row and column to create your own, to remove the built in do tools>options>view and uncheck row & column headers Regards, Peo Sjoblom
G Gord Dibben Jan 18, 2005 #3 thick You can't change these. You can however, enter your titles in Row 1 then freeze row 1 so's it remains in view. Select A2 and Window>Freeze Panes. If you also want Column A frozen, select B2 instead of A2. Column and Row headers can be hidden by Tools>Options>View. Uncheck "row and column headers" Gord Dibben Excel MVP
thick You can't change these. You can however, enter your titles in Row 1 then freeze row 1 so's it remains in view. Select A2 and Window>Freeze Panes. If you also want Column A frozen, select B2 instead of A2. Column and Row headers can be hidden by Tools>Options>View. Uncheck "row and column headers" Gord Dibben Excel MVP
