Formulas referencing other sheets

[Guest]

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!

 

[Guest]

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".

 

[Biff]

Goto Tools>Options>General

Uncheck R1C1 reference style

Biff

 

[KL]

Hi eel77,

Go to menu Tools>Options, General tab and uncheck the 'R1C1 reference style'
option.

Regards,
KL

 

[Guest]

Many thanks Sébastien!

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

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!