How to add multiple Rows/Columns

Here are the steps for adding multiple rows above or below a specific row in a Number Table.

Initial table:

To insert 5 rows ABOVE row 7 (Existing row), Select the five cells shown below (or the same rows in a different column)

Then press option-up arrow

To place 5 new rows below Row 7—starting from the initial table (first image), Select the five cells shown below (or any block of five cells in a single column, in the same five rows as shown):

Then press option-down arrow:

Instructions for inserting multiple columns follow the same patterns, using option-left arrow and option-roght arrow.

In each, the number of selected cells in the column (or row) determines the number of rows (or columns) to be inserted, and the insertion is done after the 'last' selected cell in the direction of the insertion.

Regards,

Barry

"Can you tell me how to keep reference cells intact in a formula…"

Different question, not directly associated with the topic in this thread. Please post as a new question, in a new thread, making it easier for others with the same issue to search for it.

Regards,

Barry

You're welcome.

Not just 'multiple columns', I see. ;-)

Regards,

Barry