How do I add Column Headings?

Occasional Visitor

I have several worksheets that I have made row #1 my column labels. But what i want to do is make the lettered column headings the actual column headings so I can make and use my data for some Pivot Tables. How do i go about doing this?

 

2 Replies
Not sure I understand exactly what you're describing here. But you DON'T really "want to make the lettered column headings the actual column headings"--despite what you say. That's not the way to proceed. Just insert a row, create your actual column headings, and then designate the table as a Table (i.e., name the table)...then you can proceed to create the Pivot Tables.

If that's not clear, please post a copy of your spreadsheet (or a mockup that contains no confidential info)

Hi @AJH32206 

 

When you say:

But what i want to do is make the 
lettered column headings the actual column headings
so I can make and use my data for some Pivot Tables

Did you mean like the image below?

Yea_So_0-1621569229566.png

You can make pivot tables with any headings you want to put that is meaningful to you.