How do I change row names from A to something else in Excel?

L

laidbackmate

I will like to change row and column labels from standard to my own is there
a way?

e.g. instead of A, B, C and so on can I not name them looks more professional.
 
N

Niek Otten

You can hide the column headers (tools>Options>View); that will also hide
the row numbers.
Use Row 1 for labels, use Windows>Freeze Panes to keep Row 1 visible

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top