You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Numbers commands

Working with text in Numbers, How do I get numbers to insert a new row?



Posted on Jun 25, 2023 1:19 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 25, 2023 1:34 PM

Hello megamom,


Along the rows (and columns) there is an icon with two lines. If you click that once a new row, or column, is added. You can also click and drag this to add more at once. You can also right click and click on Add Row Before, Add Row After, Add Column Before, Add Column After.


Add or remove rows and columns in Numbers on Mac - Apple Support


I hope this helps!


6 replies
Question marked as Top-ranking reply

Jun 25, 2023 1:34 PM in response to megamom

Hello megamom,


Along the rows (and columns) there is an icon with two lines. If you click that once a new row, or column, is added. You can also click and drag this to add more at once. You can also right click and click on Add Row Before, Add Row After, Add Column Before, Add Column After.


Add or remove rows and columns in Numbers on Mac - Apple Support


I hope this helps!


Jan 19, 2024 6:39 PM in response to SGIII

Sorry guys, but I have to nit-pick here. Numbers can't add a row within a cell. I can't try it here, but l seem to recall that excel can do that, called splitting a cell, but Numbers can't. Having two lines of text in a single cell would be called adding a "Line" of text. That would be done by turning on Wrap Text in a case where the string exceeds the space available, or by using the New Line Keyboard Shortcut Option-Return and then continuing to type.


Numbers can separate a cell that has been merged, back into its original form, sort of like adding a row or splitting a cell, but it's really just an undoing.


Jerry

Jun 25, 2023 2:00 PM in response to megamom

Select a cell in the row above the place you want to add a row.

Move the pointer to the space between the table and the row reference tab for that row.

Click the 'wide V' that appears to open the pop up menu shown in the image above, then

click on the menu item selected (highlighted) in the image.


Result:


Alternate method:


Select any cell in the row above or below what will become the new row.

For this example, the new row is to be inserted above the current row 3.


Press and hold the option key and tap the arrow key (lower right of keyboard) pointed toward the location for the new row in this case, option-up arrow:


Note that the option-arrow key combination can be used to insert rows (using the up or down arrow key) or to insert columns using the left or right arrows.

You can insert multiple rows or columns by selecting more than one cell:


Press Option-down arrow:


Regards,

Barry

Numbers commands

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