![]() |
How do I reconvert column names from 1, 2, 3... to A, B, C?
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? |
How do I reconvert column names from 1, 2, 3... to A, B, C?
ToolsOptionsGeneral tab, uncheck R1C1 reference style!
Regards, Stefi €˛Travelgirl€¯ ezt Ć*rta: 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? |
All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com