Adding a row in numbers

I also have had difficulty adding rows (greyed out). I couldn't work out the filter business and as for quitting and restarting, good grief, what has happened to Macs. Everything has become so obscure and convoluted. I eventually clicked out of the table onto the little circle thingy chose table>add row and a row was added in the middle of occupied rows.

MacBook Air, macOS 13.0

Posted on Dec 30, 2022 12:36 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 30, 2022 10:58 PM

Hi Percy,


Your simplest method might be this one:


Click on any cell in the row below which you want to insert a new row.

Press option-down arrow.


If you want to add more than one row:



Click on any cell in the row below which you want to insert the new rows.

To insert 'n' rows, command-click in the cell that is n-1 rows above the row you first clicked. This expands the selection to the number of rows you want to add.

Press option-down arrow to add the new rows below the first selected row.


Inserting a row or multiple rows above a selected row (or group of rows) follows much the same proceedure, As does adding one or more inserted columns to the left of right of a selected column or columns.


In all cases, the number of rows will match the number of selected rows or columns, the position of the inserted column(s) will be controlled by the direction of the arrow key used, and the first row or column will be adjacent to the selected row or column that is located furthest in the direction of the arrow key used.


Regards,

Barry

3 replies
Sort By: 
Question marked as Top-ranking reply

Dec 30, 2022 10:58 PM in response to PercyLaurie

Hi Percy,


Your simplest method might be this one:


Click on any cell in the row below which you want to insert a new row.

Press option-down arrow.


If you want to add more than one row:



Click on any cell in the row below which you want to insert the new rows.

To insert 'n' rows, command-click in the cell that is n-1 rows above the row you first clicked. This expands the selection to the number of rows you want to add.

Press option-down arrow to add the new rows below the first selected row.


Inserting a row or multiple rows above a selected row (or group of rows) follows much the same proceedure, As does adding one or more inserted columns to the left of right of a selected column or columns.


In all cases, the number of rows will match the number of selected rows or columns, the position of the inserted column(s) will be controlled by the direction of the arrow key used, and the first row or column will be adjacent to the selected row or column that is located furthest in the direction of the arrow key used.


Regards,

Barry

Reply

Dec 30, 2022 11:41 PM in response to PercyLaurie

I used the method suggested by Barry (click in cell then option down for single row, click in cell then command click above for multiple rows then option down to insert) and the method worked for all but one troublesome table where I could get neither a single row nor multiple row. Im still experimenting on a copy of that table and it seems to work.

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Adding a row in numbers

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