ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I reconvert column names from 1, 2, 3... to A, B, C? (https://www.excelbanter.com/excel-discussion-misc-queries/224537-how-do-i-reconvert-column-names-1-2-3-b-c.html)

Travelgirl

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?

Stefi

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