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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I switch so that rows are referenced with letters, and co. (https://www.excelbanter.com/excel-discussion-misc-queries/18146-how-can-i-switch-so-rows-referenced-letters-co.html)

willyv1

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

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.

Dave Peterson

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?

willyv1 wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 11:38 PM.