| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrong cell addresses
Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell
addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrong cell addresses
On Mon, 24 Mar 2008 14:50:01 -0700, Kim wrote:
Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched? Select Tools/Options and under one of the tabs, there will be an option for R1C1 style -- DEselect that. --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrong cell addresses
Click the Office button
Excel OptionsFormulasWorking with formulas Uncheck R1C1 reference style OK -- Biff Microsoft Excel MVP "Kim" wrote in message ... Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrong cell addresses
Was there a recent microsoft update that may have modified this? I noticed
all of my computers in our training room suddenly showed this too. I know this was something we didn't change manually. Kim "T. Valko" wrote: Click the Office button Excel OptionsFormulasWorking with formulas Uncheck R1C1 reference style OK -- Biff Microsoft Excel MVP "Kim" wrote in message ... Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrong cell addresses
No updates.
The A1 reference style is the default *unless* the very first file you open in an Excel session is set for R1C1 style. Then, every file you open in that session will use those settings. A session is from the time you start Excel until the time you close Excel. -- Biff Microsoft Excel MVP "Kim" wrote in message ... Was there a recent microsoft update that may have modified this? I noticed all of my computers in our training room suddenly showed this too. I know this was something we didn't change manually. Kim "T. Valko" wrote: Click the Office button Excel OptionsFormulasWorking with formulas Uncheck R1C1 reference style OK -- Biff Microsoft Excel MVP "Kim" wrote in message ... Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing cell addresses | Excel Worksheet Functions | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| my cells with email addresses ling me to the wrong ones | Excel Worksheet Functions | |||
| Cell addresses | Excel Discussion (Misc queries) | |||
| cell addresses | Excel Worksheet Functions | |||
Linear Mode
