How can I switch so that rows are referenced with letters, and co.

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

Guest

How do I switch the worksheet axis labels? Rather than having a row-column
reference of 1A, I would like to switch the row-column reference to A1.
 
You can't.

You could use column A and Row 1 and put anything you want in there.

But what letter would you use for row 65536?
 
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

How can I change column designation from number to letters? 3
Cell References Format 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns now numbers rather than letters how do i get letters back 2
Excel Help to copy information from one row at a time to another sheet 1
Referencing rows to columns 3
Column & row heading directions 2
Formula from consecutive rows to alternate rows? 2

Back
Top