Add and rearrange rows and columns in tables

There are three types of rows and columns in a table:

Header rows and columns are optional and can contain text identifying what the row or column contains. Data in header cells isn’t used in calculations, but the text in a header cell can be used in formulas to refer to all the cells in the row or column. A table can have up to five header rows and five header columns.
Body rows and columns contain table data. A table must contain at least one body row and column.
Footer rows appear at the bottom of a table. Footers are optional; you can have up to five footer rows.

Note: The tasks below apply to a table you add to your page. They don’t apply to a page divided into columns.

Add or remove rows and columns

Tap the table, then do any of the following:

Change the number of rows: Tap , then tap the arrows.
Change the number of columns: Tap , then tap the arrows.

Move rows and columns within a table

Select one or more rows or columns.
Do one of the following:
- Move rows: After selecting the rows, touch and hold the row numbers until the rows appear to rise off the table, then drag them above or below another row.
- Move columns: After selecting the columns touch and hold the column letters until the columns appear to rise off the table, then drag them to the right or left of another column.

Add or remove header rows and columns in a table

Adding header rows, header columns, and footer rows converts existing rows and columns into headers or footers. For example, if you have data in the first row of a table and you add a header row, the first row is converted to a header row that contains the same data. Data in header cells isn’t used in calculations.

Tap the table, tap , then tap Headers.
Tap the buttons next to a header or footer category to change the number of headers or footers.