How do I add Column Headings?

%3CLINGO-SUB%20id%3D%22lingo-sub-2368134%22%20slang%3D%22en-US%22%3EHow%20do%20I%20add%20Column%20Headings%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2368134%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20worksheets%20that%20I%20have%20made%20row%20%231%20my%20column%20labels.%20But%20what%20i%20want%20to%20do%20is%20make%20the%20lettered%20column%20headings%20the%20actual%20column%20headings%20so%20I%20can%20make%20and%20use%20my%20data%20for%20some%20Pivot%20Tables.%20How%20do%20i%20go%20about%20doing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2368134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2374388%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20add%20Column%20Headings%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2374388%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057933%22%20target%3D%22_blank%22%3E%40AJH32206%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20say%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%3EBut%20what%20i%20want%20to%20do%20is%20make%20the%20%3CBR%20%2F%3Elettered%20column%20headings%20the%20actual%20column%20headings%20%3CBR%20%2F%3Eso%20I%20can%20make%20and%20use%20my%20data%20for%20some%20Pivot%20Tables%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3EDid%20you%20mean%20like%20the%20image%20below%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1621569229566.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282509i11CEE8ADEABDEE83%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1621569229566.png%22%20alt%3D%22Yea_So_0-1621569229566.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20can%20make%20pivot%20tables%20with%20any%20headings%20you%20want%20to%20put%20that%20is%20meaningful%20to%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2368168%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20add%20Column%20Headings%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2368168%22%20slang%3D%22en-US%22%3ENot%20sure%20I%20understand%20exactly%20what%20you're%20describing%20here.%20But%20you%20DON'T%20really%20%22want%20to%20make%20the%20lettered%20column%20headings%20the%20actual%20column%20headings%22--despite%20what%20you%20say.%20That's%20not%20the%20way%20to%20proceed.%20Just%20insert%20a%20row%2C%20create%20your%20actual%20column%20headings%2C%20and%20then%20designate%20the%20table%20as%20a%20Table%20(i.e.%2C%20name%20the%20table)...then%20you%20can%20proceed%20to%20create%20the%20Pivot%20Tables.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that's%20not%20clear%2C%20please%20post%20a%20copy%20of%20your%20spreadsheet%20(or%20a%20mockup%20that%20contains%20no%20confidential%20info)%3C%2FLINGO-BODY%3E
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.