Create Header Columns

I can't seem to find this at all... I have a sheet of data with columns that have not been titled. I want to make the titles I am going to add like Date, Size etc be respected as Header Columns so that when I create a Pivot table I am not faced with nondescript titles like Col A, Col B?


Cheers!

MacBook Pro 15″, macOS 12.3

Posted on Aug 14, 2023 10:21 AM

Reply
Question marked as Best answer

Magic, thanks SGIII, the file sent to me didn't have them.

Posted on Aug 16, 2023 4:36 AM

1 reply
Question marked as Apple recommended

Aug 14, 2023 1:15 PM in response to Bardonicloud

A table typically has a shaded Header Row and Header Column by default. Did you remove them, or choose another table style?


To add Header Row just click in the table and in the menu choose Table > Header Rows and select a number up to 5. Similar for Header Columns.


You can also do this in the inspector sidebar on the right under the Table tab.


SG

2 replies
Question marked as Apple recommended

Aug 14, 2023 1:15 PM in response to Bardonicloud

A table typically has a shaded Header Row and Header Column by default. Did you remove them, or choose another table style?


To add Header Row just click in the table and in the menu choose Table > Header Rows and select a number up to 5. Similar for Header Columns.


You can also do this in the inspector sidebar on the right under the Table tab.


SG

Create Header Columns

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.