Defining header row in existing excel file while using Numbers on iPad

Question

Level 1

29 points

Defining header row in existing excel file while using Numbers on iPad

First time Apple Numbers user here.

I have an existing excel file that I’m trying to edit and work using Numbers on iPad. The first row in each of my tabs is the header row but the Numbers app is considering the first row as regular data row and defining the fields’ name as column a, column b, etc. This is creating a challenge when I take a pivot as the supposedly header row is being shown as the data elements in the pivot.

How do i make the first row as the header in the Numbers? Attached the screenshot for the reference.

Posted on Jun 7, 2022 3:21 AM

Reply

Answer 1

Jun 8, 2022 8:08 AM in response to Harryu

Hello Harryu,

Thanks for using the Apple Support Communities.

It sounds like you’re looking for help when it comes to Numbers on your iPad.

Is that correct? If so, you’re in the right place to receive support.

When you get a free moment, please check out the resource below for guidance on using Numbers.

Numbers - Official Apple Support

Cheers!

Reply

Answer 2

Yellowbox

Level 7

21,331 points

Jun 19, 2022 5:50 AM in response to Harryu

Hi Harry,

Tap anywhere on the table to select it.

Tap on the paintbrush icon.

Tap on the Table button.

Tap on Headers and Footer.

Now you can add (+) Header Rows.

You can add colour fill to row 1 if you wish to make it stand out as a Header Row.

Tap on the row label 1 to select the whole of Row 1.

Tap on the paintbrush icon.

Tap on the Cell button.

Scroll to Cell Fill and choose Preset (a limited range of colours) or choose Colour fo a greater range of colours.

Regards,

Ian.

Reply

Defining header row in existing excel file while using Numbers on iPad

Similar questions