Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Look at the
TOOLS / OPTIONS / SETTINGS is the 'R1C1 References Style' box checked? If not, check it then save the workbook. Not sure if this is your issue but it's worth a try. Good Luck, -- Gary Brown "Tony S" wrote: Excel keeps changing to the R1C1 reference style, but only in one of my workbooks (I believe in just one of the worksheets). I keep changing it back (Tools - Options - General - R1C1 Reference Style), but when I move or copy cells in the workbook, it changes back to R1C1. Anyone have an idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
How do I reference multiple rows | Excel Worksheet Functions |