How do I insert column headings above the numbered rows?

G

Gord Dibben

If you want to change the column headings A,B,C etc. to titles, you cannot.

One workaround is to use row 1 for titles then turn of Tools>Options>View>Row
and Column Headers.

Then select A2 and Window>Freeze Panes.


Gord Dibben MS 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
how can i see the headings at the bottom of the sheet 0
How do you change the column names in Excel? 0
Can I title columns with out them having a row number? 0
how can i change the letters in the top row to words 0
How to rename the head A,B,C,D,E etc. on every column 0
how do I freeze my column labels so that they print every page? 1
How to keep Column headers with Autofilter & Freeze Panes 8

Top