Columns in excel are headed by letters How can this be changed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I opened an Excel worksheet both columns and rows are headed by numbers.
Instead of the columns being letters and rows numbers. I need to know how to
fix this.
 
Nardia

Tools>Options...>General uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
You must log in or register to reply here.

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

Column Heading Error 3
My column headings somehow changed from letters to numbers...help 1
Row and columns labeled both as numbers, not letters 1
column header labels are numbered but need to be lettered 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
How: reset the column headings from numeric to alphabetic? 1
Columns are numbers instead of letters 4

Back
Top