Row Label

G

Gord Dibben

Hoang

Column labels A, B, C can be changed to 1, 2, 3 as you have already been told.

Tools>Options>General "R1C1 reference style."

Row labels cannot be changed from numbers.

If you are looking to swap data from columns to rows check out TRANSPOSE
Function or just copy the data and Paste Special>Transpose.

Gord Dibben XL2002
 
A

Arvi Laanemets

Hi

You can't! But you can have leftmost column(s) values used as row headers
(key column) - of course you can't use them as references to row, but you
can always use them as lookup values.
To set leftmost column(s) always visible, use Freeze Panes option
(Windows.FreezePanes).
 

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

cannot find which label format i need 1
Blank Page After Envelope-Label Wizard 5
Duplicate Mail Merge Record Every Time 5
Trying to create custom labels from an csv file + Need items numerically counted out 0
ASK Field Formatting 1
Mail merge labels 8 per page, but 84 is not divisible by 8 3
How to print labels from excel 1
Program buttons to create a word document 0

Top