Excel Relative Reference

  • Thread starter Thread starter Trisha
  • Start date Start date
T

Trisha

On Excel XP, how do you switch back to the normal
column/row headings where it would equal A1 rather than
the relative which is 1:1? Please let me know how I can
fix this.

Thanks,
Trisha
 
Hi Trisha,

You probably refer to the Reference style:
Tools>Options>General, uncheck R1C1 Reference Style

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top