Forum Discussion
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 ...
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)
If that's not clear, please post a copy of your spreadsheet (or a mockup that contains no confidential info)