Can you change the names of the columns in a spreadsheet to something other than A, B, C, D, etc.?
A Alyce Newell Apr 18, 2005 #1 Can you change the names of the columns in a spreadsheet to something other than A, B, C, D, etc.?
G Gord Dibben Apr 18, 2005 #3 No. But you can add titles in row 1 then select A2 and Window>Freeze Panes to keep those titles in view. Select B2 to keep row 1 and Column A in view. Also go to Tools>Options>View and uncheck "row and column headers" Gord Dibben Excel MVP On Mon, 18 Apr 2005 14:37:36 -0700, Alyce Newell <Alyce
No. But you can add titles in row 1 then select A2 and Window>Freeze Panes to keep those titles in view. Select B2 to keep row 1 and Column A in view. Also go to Tools>Options>View and uncheck "row and column headers" Gord Dibben Excel MVP On Mon, 18 Apr 2005 14:37:36 -0700, Alyce Newell <Alyce