How do I add rows in between rows without having go inserting one row at a time?
—–
James
MacMost Q&A Forum • View All Forum Questions • Ask a Question
Insert Multiple Rows Between Existing Rows in Mac Numbers?
Comments: 6 Responses to “Insert Multiple Rows Between Existing Rows in Mac Numbers?”
Comments Closed.
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.
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.
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?
Sorry, I miss read your initial response which solves my problem. Have a nice day.
Hi, Gary,
Would rather you not post this, but my "why," which brought me to this page, is that I'm updating my personal financial spreadsheet which I had let get out of date. I put in my December 1 expenses but then wanted to insert November expenses between 11-15 and 12-01. Yes, I'm very much aware that I can input November expenses after December and simply sort. But it's just a matter of preference and how one wants to work. ;-)
--Martha (happy Patreon supporter)
Martha: Another option is to create blank rows at the bottom by dragging the = button at the bottom left. Then select those blank rows and drag them up to where you want to move them. So create 10 blank rows, select all 10, drag the 10 rows up in between two rows earlier in the table.