rotation of default row & column heading exce

August 17, 2011 at 00:53:41
Specs: Windows XP
can we transpose default row & column heading in excel worksheet ??

See More: rotation of default row & column heading exce

Report •

August 17, 2011 at 04:38:59
There are 2 things you can do with the Row & Column headings in Excel:

1 - Change the Column Letters to Numbers:

Tools...Options...General...Check "R1C1 reference style"

2 - Hide both the Row and Column headings:

Tools...Options...View... Uncheck "Row and column headers"

With Option 2, you could then add your own Row Letters in Column A and Column Numbers in Row 1.

That's the closest you're going to get to "transposing" the labels.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question