Add and rearrange rows and columns

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

Header rows and columns are optional and are used for labels identifying what each row and column contains. Data in header cells isn’t used in formulas. 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.

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.

Select rows and columns

Tap the table.
A bar appears above the columns and to the left of the rows.
Do any of the following:
- Select a single row or column: Tap the bar for the row or column you want to select.
- Select multiple rows or columns: Tap the bar for a row or column, then drag a selection handle (a blue dot) to encompass the rows or columns you want.

Move rows and columns within a table

Select one or more rows or columns, then do one of the following:
- Move rows: Touch and hold the row bars until the row appears to lift off the table, then drag the row above or below another row.
- Move columns: Touch and hold the column bars until the column appears to lift off the table, then drag the column to the right or left of another column.

Resize rows and columns

You can change the width of specific columns and the height of specific rows in a table.

Tap the table, then select the row or column you want to resize.
Drag to resize.

To resize all rows or columns in a table, tap the table, then drag a selection handle (a blue dot).

Add or remove header rows and columns

Adding header rows, header columns, and footer rows converts existing rows or columns to 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 using the same data. Data in header cells isn’t included in charts or formulas.

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