Excel Spreadsheet
I have been given a spreadsheet to work on that has the column headings
across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
Tool=Options=General-- Uncheck R1C1 reference style (in Settings)
"Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
Tools | Options | General tab | deselect R1C1 reference style
Regards Trevor "Helpme Please" <Helpme wrote in message ... I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
Trevor
Thank you very much for your fast response, it worked and I really do appreciate your help. Thanks again "Trevor Shuttleworth" wrote: Tools | Options | General tab | deselect R1C1 reference style Regards Trevor "Helpme Please" <Helpme wrote in message ... I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet Why do this ?
Trevor
Why would you want to refernce the headings like that anyway? Would you know? "Trevor Shuttleworth" wrote: Tools | Options | General tab | deselect R1C1 reference style Regards Trevor "Helpme Please" <Helpme wrote in message ... I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
Thanks Toppers but why would you want to ref this way anyway?
"Toppers" wrote: Tool=Options=General-- Uncheck R1C1 reference style (in Settings) "Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet Why do this ?
I guess it's just personal choice and probably something to do with backward
compatibility with Lotus 123. Personally, I wouldn't choose it but I'm sure are there are lots of people who do. Regards Trevor "Helpme Please" wrote in message ... Trevor Why would you want to refernce the headings like that anyway? Would you know? "Trevor Shuttleworth" wrote: Tools | Options | General tab | deselect R1C1 reference style Regards Trevor "Helpme Please" <Helpme wrote in message ... I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
Hi,
Do the following: 1. On the Tools menu, click Options. 2. In the Options dialog box, click the General Tab 3. Click to slect the R1C1 Refernce Style check box 4. Click Ok to return to active worksheet. Now the column heading have changed to ABCDEFG and so on. Challa Prabhu "Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
How does this work in Office 2007 which has no tools menu?
"challa prabhu" wrote: Hi, Do the following: 1. On the Tools menu, click Options. 2. In the Options dialog box, click the General Tab 3. Click to slect the R1C1 Refernce Style check box 4. Click Ok to return to active worksheet. Now the column heading have changed to ABCDEFG and so on. Challa Prabhu "Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
Excel Spreadsheet
In Excel 2007:
Click the Office button Excel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "SwatMan" wrote in message ... How does this work in Office 2007 which has no tools menu? "challa prabhu" wrote: Hi, Do the following: 1. On the Tools menu, click Options. 2. In the Options dialog box, click the General Tab 3. Click to slect the R1C1 Refernce Style check box 4. Click Ok to return to active worksheet. Now the column heading have changed to ABCDEFG and so on. Challa Prabhu "Helpme Please" wrote: I have been given a spreadsheet to work on that has the column headings across the top shown as numbers instead of the usual letters (ABCDEFG etc) How do I get it to show the letters again please? |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com