Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas referencing other sheets
Normally when referencing cells on another worksheet, the formula bar will
display something like so, =Sheet2!B15 Under what circumstance would the formula be displayed like the following? =Sheet2!R[-226]C And how do I change this back to the "normal" formula format? Many thanks! |
#2
|
|||
|
|||
Excel has 2 modes for referencing A1 and R1C1. In A1-mode, row are numbered
and columns are A, B, C,... . In R1C1, R corresponds to Rows and C correspond to Columns and both rows and columns are numbered. To switch to one mode to another, go to menu Tools Options, tab General, setting: "R1C1 reference style". -- Regards, Sébastien "eel77" wrote: Normally when referencing cells on another worksheet, the formula bar will display something like so, =Sheet2!B15 Under what circumstance would the formula be displayed like the following? =Sheet2!R[-226]C And how do I change this back to the "normal" formula format? Many thanks! |
#3
|
|||
|
|||
Goto ToolsOptionsGeneral
Uncheck R1C1 reference style Biff "eel77" wrote in message ... Normally when referencing cells on another worksheet, the formula bar will display something like so, =Sheet2!B15 Under what circumstance would the formula be displayed like the following? =Sheet2!R[-226]C And how do I change this back to the "normal" formula format? Many thanks! |
#4
|
|||
|
|||
Hi eel77,
Go to menu ToolsOptions, General tab and uncheck the 'R1C1 reference style' option. Regards, KL "eel77" wrote in message ... Normally when referencing cells on another worksheet, the formula bar will display something like so, =Sheet2!B15 Under what circumstance would the formula be displayed like the following? =Sheet2!R[-226]C And how do I change this back to the "normal" formula format? Many thanks! |
#5
|
|||
|
|||
Many thanks Sébastien!
"sebastienm" wrote: Excel has 2 modes for referencing A1 and R1C1. In A1-mode, row are numbered and columns are A, B, C,... . In R1C1, R corresponds to Rows and C correspond to Columns and both rows and columns are numbered. To switch to one mode to another, go to menu Tools Options, tab General, setting: "R1C1 reference style". -- Regards, Sébastien "eel77" wrote: Normally when referencing cells on another worksheet, the formula bar will display something like so, =Sheet2!B15 Under what circumstance would the formula be displayed like the following? =Sheet2!R[-226]C And how do I change this back to the "normal" formula format? Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheets back to formulas | Excel Discussion (Misc queries) | |||
formulas referencing pivot table cells | Excel Worksheet Functions | |||
Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
formulas for employee time sheets | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |