column names - chane from numbrts back to A- z

G

Guest

Another user of an excel sheet I created has changed the column names from
the alphabetic ones to numbers making the transfer of cells by thier ref.
difficultt . Instead of reading ref A1 for example it shows R1C1. Any ideas
how i can change it back - have searched help with no success
 
C

Chris Lavender

Go into Tools/Options/General and uncheck the R1C1 reference style box

Best rgds
Chris Lav
 

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

Can I change the column heading from alphabetic to numeric? 2
How can I change column titles back to numbers? 4
Column Names 4
Column Header - Convert a Number to a letter 1
How do I reconvert column names from 1, 2, 3... to A, B, C? 1
Excel 2007... fix column headings from numbers back to letters 4
reference format and column name 1
How do I change Excel column cell identifiers back to letters? 4

Top