How do I reconvert column names from 1, 2, 3... to A, B, C?

  • Thread starter Thread starter Travelgirl
  • Start date Start date
T

Travelgirl

I transposed some data in the business version of excell.
Now my cells are named "R1C1" in stead of A1. When I open a new excell sheet
it is the same formatting. I cant get fixed cells in formulas to work and
have other problems. How do I reconvert the sheets to the normal "A1" format?
 
Tools>Options>General tab, uncheck R1C1 reference style!

Regards,
Stefi

„Travelgirl†ezt írta:
 
Back
Top