Add or remove rows and columns in Numbers on Mac
You can add, delete and rearrange rows and columns in a table. There are three types of rows and columns:
Body rows and columns contain the table data.
Header rows and columns (if any) appear at the top and left side of the table. They usually have a different background colour from the body rows and they’re typically used to identify 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 the entire row or column. A table can have up to five header rows and five header columns.
You can freeze (or lock) header rows and columns so that they’re always visible when you scroll the spreadsheet.
Footer rows (if any) appear at the bottom of a table. A table can have up to five footer rows.
Add or remove rows and columns
Click the table.
Do any of the following:
Add or delete a row or column at the edge of the table: Click in the bottom-left corner of the table to add a row, or drag it to add or delete multiple rows. Click in the top-right corner of the table to add a column, or drag it to add or delete multiple columns. You can delete a row or column only if all of its cells are empty.
Add or delete both rows and columns at the edge of the table: Drag in the bottom-right corner of the table to add or delete both rows and columns. You can delete rows and columns only if their cells are empty. To delete rows and columns that have data, Option-drag .
Insert or delete a row or column within the table: Move the pointer over a row number or column letter, click the arrow, then choose an option from the shortcut menu.
Insert multiple rows or columns at once: Anywhere in the table, select a number of rows or columns equal to the number of rows or columns you want to insert. Click the arrow next to one of the selected row numbers or column letters, then choose Add Rows Above or Add Rows Below (or Add Columns Before or Add Columns After).
Delete multiple rows or columns at once: Command-click the rows or columns, click the arrow, then select Delete Selected Rows or Delete Selected Columns.
Add, remove or freeze header rows and columns
Adding header rows, header columns or footer rows converts existing rows or 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.
You can freeze header rows or columns so they’re always visible as you scroll the spreadsheet.
Click the table.
In the Format sidebar, click the Table tab, then do any of the following:
Add or delete headers and footers: Click the Headers & Footer pop-up menus in the sidebar and choose a number. To remove all headers or footers, set the number to 0 (zero).
Freeze header rows and columns: Click the pop-up menus below Headers & Footer, then choose Freeze Header Rows or Freeze Header Columns. To unfreeze, deselect Freeze Header Rows or Freeze Header Columns so that the tick mark disappears.
To learn how to show table headers on every page of a printed spreadsheet, see Print a spreadsheet in Numbers on Mac.
Hide or show rows and columns
Hiding rows or columns is useful if, for example, you need to use their data for formulas, but you don’t want the data to be visible.
Note: You can’t hide rows or columns in a pivot table but you can use filters if you want to show only certain data in the pivot table. See Filter data in Numbers on Mac
Select the rows or columns you want to hide.
Move the pointer over a row number or column letter, then click the down arrow that appears and choose Hide Selected Rows or Hide Selected Columns.
A grey bar appears between the column letters or row numbers to show where columns and rows are hidden.
Note: If the rows or columns you select contain merged cells, you may not be able to hide those rows or columns. For example, if you merge two cells in one row, you can hide the row that contains the merged cells, but you can’t hide columns that include the merged cells.
To show hidden rows or columns, select a row or column adjacent to the hidden ones. Move the pointer over the row number or column letter, click the down arrow, then choose an Unhide option.
To un-hide all rows or columns, click the table, then choose Table > Un-hide all Rows or Un-hide all Columns (from the Table menu at the top of your screen).
Copy a table to another Numbers file or app
You can copy an entire table or a selection of rows, columns or cells, to a different Numbers spreadsheet or to another app.
Select the table, cells, rows or columns you want to copy.
Do any of the following:
Drag the selection to another Numbers file: Click and hold the selection until it appears to lift, then drag the selection to another Numbers window. You can drag it to an existing table or to a blank space on the sheet, which creates a new table.
Drag the selection to another app: Click and hold the selection until it appears to lift, then drag it to an open note, email message, Keynote presentation or Pages document.