How do you change the column names in Excel?

G

Gord Dibben

You cannot change the A, B, C headers.

A workaround is to use Row 1 for a titles row then select A2 and Window>Freeze
Panes so that Row 1 with the titles remains in view when you scroll.

Select B2 instead if you also want Column A to remain in view.

You can turn off the A, B, C, etc. by going to Tools>Options>View and uncheck
"row and column headers".


Gord Dibben Excel MVP
 

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

How do I freeze the swimlane headers? 0
Dealing with the error: unable to filter on excel hc home school 0
How to rename the head A,B,C,D,E etc. on every column 0
Can I title columns with out them having a row number? 0
How do I insert column headings above the numbered rows? 0
Display index of column headers in column A 9
How to keep Column headers with Autofilter & Freeze Panes 8
Search cell value in same column 3

Top