How do I add Column Headings?

[AJH32206]

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]

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)

[#3]

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?

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