How to insert a row into numbers, in just one column

numbers

How do I insert a row in one column only. By moving the current data down and inserting a row above it. I don't want to insert a row across the entire spreadsheet – just that column.

Best Answer

From Numbers help:

Move rows and columns within a table Select one or more rows or columns.

Do any of the following:

Move rows: After selecting the rows, click 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, click 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.

Tip: If you drag rows or columns outside of an existing table, you create a new table with them.

This has plagued me for ages and I took to forums to unsuccessfully find the answer, till I finally used the help function found in Numbers.

Related Question