MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Insert Multiple Rows Between Existing Rows in Mac Numbers?

How do I add rows in between rows without having go inserting one row at a time?
—–
James

Comments: 4 Responses to “Insert Multiple Rows Between Existing Rows in Mac Numbers?”

    4 months ago

    One way to do it is to select the number of rows you want to insert first. So say you have 10 rows and you want to insert 5 new rows after row 5. Select rows 6 through 10. Then choose Table, Add Rows Above. This will insert 5 new rows between the old rows 5 and 6 because you had selected 5 rows.

    You can also just avoid the whole issue by only adding rows to the bottom of a table. In most cases, tables are used as small databases and you would only add new rows to the bottom. Later, you may sort the data so the original row location doesn’t matter. Or, you can select the 5 new rows at the bottom when you are done, and move them up into position as a group.

    I could probably suggest some more ideas, but you skipped the “why” question. It is important to know WHY you are trying to do something to come up with a proper solution. Without knowing that, I can only guess that these suggestions will be the best to help you.

    James McCormick
    4 months ago

    The “Why” is because I have spread sheets that from time to time I have to insert multiple new rows when adding new data or cut and pasting.

    4 months ago

    James: That’s just restating the question. Why do you need to insert multiple new rows into these tables? What is the situation? Why can’t you just add new rows to the end of the tables?

    James McCormick
    4 months ago

    Sorry, I miss read your initial response which solves my problem. Have a nice day.

Leave a New Comment Related to "Insert Multiple Rows Between Existing Rows in Mac Numbers?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)