Forum Discussion

AJH32206's avatar
AJH32206
Copper Contributor
May 19, 2021

How do I add Column Headings?

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?

 

excel

2 Replies

Sort By
  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    May 21, 2021

    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.

  • mathetes's avatar
    mathetes
    Silver Contributor
    May 19, 2021
    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)

Resources