how do I increase the total number of rows?

Question

Level 1

0 points

how do I increase the total number of rows?

This seems like a dumb question, but I can only seem to be able to add one new row at the bottom of my spreadsheet at a time using the '=' in a circle button that appears below the last row of the spreadsheet.

I want to add hundreds of rows, and I can only seem to add one at a time which seems ridiculous and a huge waste of time. There has to be a way to add a huge block of empty rows to the spreadsheet right? Can you really only add one new blank row at a time?

OS X Yosemite (10.10.2)

Posted on Apr 27, 2015 4:50 PM

Reply

Answer 1

t quinn

Level 5

7,043 points

Apr 28, 2015 6:03 AM in response to lsrod

Hi Isrod,

You can drag that "=" down to add rows quickly.

quinn

Reply

Answer 2

Apr 28, 2015 6:29 AM in response to lsrod

you can select rows, then use the key combination <option> + <down arrow> to add the same number of rows you selected for each key press.

If you select five rows then each time you type the key combination Numbers will add five rows.

If I want to add many rows I select all rows, then type the key combination, then I select all rows, and type the key combination again, repeat as needed

Reply