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

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?
 
S

Stefi

Tools>Options>General tab, uncheck R1C1 reference style!

Regards,
Stefi

„Travelgirl†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i return to normal text from =PROPER(cell) 3
column names 5
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data!$A$1:$C$1,IF($V 3
How to total a column of cells without using Autosum 3
My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns 2
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Array with many cells from a row but not in order or together 11
change column name from 1 2 3 to A B C in Excel 2007 2

Top