Newsroom Update

New features come to Apple services this fall. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers

Can i insert only several cells above or below instead of an entire row? Same question for columns. I would like to add insert cells into a row or column, not add an entirely new row or column. Very easy in Excel, surely Numbers can do this?

MacBook Pro 13″, macOS 10.12

Posted on Aug 15, 2020 3:39 PM

Reply
Question marked as Best reply

Posted on Aug 15, 2020 10:20 PM

  1. Select all the cells in the column below the spot you want to add cells, at least down to the lowest row that has data. Make sure you select all of them, the ones you miss might be overwritten. A quick way if you need to select all the way to the bottom of the table is to click on the first one then Cmd-Shift-Down Arrow to select from there to the end of the table. Or use Cmd-Option-Shift-Down Arrow to select to the lowest filled row in the column.
  2. Click and hold inside that selection box and it will "lift" out of the table.
  3. Drag downward and let go when you have the number of new cells you want.


You can use this method to move those cells anywhere, even create a new table out of them.


Adding cells in a row is the same idea. The key combination for selection uses the right arrow instead of down arrow. Otherwise it is the same

3 replies
Question marked as Best reply

Aug 15, 2020 10:20 PM in response to Bittsy

  1. Select all the cells in the column below the spot you want to add cells, at least down to the lowest row that has data. Make sure you select all of them, the ones you miss might be overwritten. A quick way if you need to select all the way to the bottom of the table is to click on the first one then Cmd-Shift-Down Arrow to select from there to the end of the table. Or use Cmd-Option-Shift-Down Arrow to select to the lowest filled row in the column.
  2. Click and hold inside that selection box and it will "lift" out of the table.
  3. Drag downward and let go when you have the number of new cells you want.


You can use this method to move those cells anywhere, even create a new table out of them.


Adding cells in a row is the same idea. The key combination for selection uses the right arrow instead of down arrow. Otherwise it is the same

Aug 15, 2020 10:29 PM in response to Badunit

While we are on this subject, one thing really neat in Numbers is how easy it is to move cells, groups of cells, or entire rows and columns around. For instance, if you want to swap columns B and C, click on the column header for one of them to select the column, click and hold and the column will "lift" from the table then drag and drop it to its new location. Moving just one cell is pretty much the same procedure (select cell, click and hold, drag and drop) and you can drop it wherever you want it.

Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.