![]() |
Columns headings changed to numbers in all of my worksheets
Recently, and I do not know how, all of the column headings in all of my
worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are supposed to be). Any ideas on how I can change the default settings of Excel 2003 to give me letters for the column headings again (preferably for all worksheets)? I much prefer A1 as a reference to a specific cell than R1C1. |
Columns headings changed to numbers in all of my worksheets
Goto the menu ToolsOptionsGeneral tabuncheck R1C1 reference styleOK
-- Biff Microsoft Excel MVP "thunderhead" wrote in message ... Recently, and I do not know how, all of the column headings in all of my worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are supposed to be). Any ideas on how I can change the default settings of Excel 2003 to give me letters for the column headings again (preferably for all worksheets)? I much prefer A1 as a reference to a specific cell than R1C1. |
All times are GMT +1. The time now is 01:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com