G Guest Oct 23, 2007 #1 I have a spreadsheet where somehow the column headers got changed from alpha to numeric. How can I change them back?
I have a spreadsheet where somehow the column headers got changed from alpha to numeric. How can I change them back?
N Niek Otten Oct 23, 2007 #2 Tools>Options>General tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel |I have a spreadsheet where somehow the column headers got changed from alpha | to numeric. How can I change them back?
Tools>Options>General tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel |I have a spreadsheet where somehow the column headers got changed from alpha | to numeric. How can I change them back?
R Ron Coderre Oct 23, 2007 #3 From the Excel Main Menu: <tools><options><general tab>...UNcheck: R1C1 reference style. Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel)
From the Excel Main Menu: <tools><options><general tab>...UNcheck: R1C1 reference style. Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel)
