ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change row names from A to something else in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/3267-how-do-i-change-row-names-something-else-excel.html)

laidbackmate

How do I change row names from A to something else in Excel?
 
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.

Niek Otten

You can hide the column headers (toolsOptionsView); that will also hide
the row numbers.
Use Row 1 for labels, use WindowsFreeze Panes to keep Row 1 visible

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"laidbackmate" wrote in message
...
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.





All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com