Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column tags no longer letters?!
Ok, strange one. I produced a document recently which I periodically check on
for accuracy etc. I've opened it up today and for some odd reason the column labels are no longer 'A' B' 'C' etc but are numbered in the same manner as the row labels. Also, cell references are changed - for example what would be cell A1 is now R1C1!? I'm not sure if this has been changed by someone else or not, but it's making my monthly upkeep almost impossible! Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column tags no longer letters?!
Hi,
Tools|Options - general tab and un-check R1C1 This happens if the first workbook you open in a session uses r1C1 Mike "GD" wrote: Ok, strange one. I produced a document recently which I periodically check on for accuracy etc. I've opened it up today and for some odd reason the column labels are no longer 'A' B' 'C' etc but are numbered in the same manner as the row labels. Also, cell references are changed - for example what would be cell A1 is now R1C1!? I'm not sure if this has been changed by someone else or not, but it's making my monthly upkeep almost impossible! Any thoughts? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column tags no longer letters?!
Tools/ Options/ General
Unset R1C1 reference style. -- David Biddulph "GD" wrote in message ... Ok, strange one. I produced a document recently which I periodically check on for accuracy etc. I've opened it up today and for some odd reason the column labels are no longer 'A' B' 'C' etc but are numbered in the same manner as the row labels. Also, cell references are changed - for example what would be cell A1 is now R1C1!? I'm not sure if this has been changed by someone else or not, but it's making my monthly upkeep almost impossible! Any thoughts? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column tags no longer letters?!
Many thanks Mike, that sorted it.
"Mike H" wrote: Hi, Tools|Options - general tab and un-check R1C1 This happens if the first workbook you open in a session uses r1C1 Mike "GD" wrote: Ok, strange one. I produced a document recently which I periodically check on for accuracy etc. I've opened it up today and for some odd reason the column labels are no longer 'A' B' 'C' etc but are numbered in the same manner as the row labels. Also, cell references are changed - for example what would be cell A1 is now R1C1!? I'm not sure if this has been changed by someone else or not, but it's making my monthly upkeep almost impossible! Any thoughts? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column tags no longer letters?!
Ttry
Tools|Options - general tab and uncheck R1C1 Mike On Mon, 10 Nov 2008 04:13:03 -0800, GD wrote: Ok, strange one. I produced a document recently which I periodically check on for accuracy etc. I've opened it up today and for some odd reason the column labels are no longer 'A' B' 'C' etc but are numbered in the same manner as the row labels. Also, cell references are changed - for example what would be cell A1 is now R1C1!? I'm not sure if this has been changed by someone else or not, but it's making my monthly upkeep almost impossible! Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change column numbering to column letters in my spreadsheet view | Excel Discussion (Misc queries) | |||
Row/Column Delete taking longer time | Excel Discussion (Misc queries) | |||
Ctrl-Space Column Selection No Longer Working | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
How do I extract 3 numbers inside a longer number to another column ? | Excel Discussion (Misc queries) |