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!

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!

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!

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!

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!