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.

Automatically insert row after record entry

Hi

i have a numbers spreadsheet for record keeping. I would like to have a blank row always open that has the same formulas as the previous rows automatically added after I add in a record.

alternatively something which may be better will be a group of cells that I can enter each record in and it has something like an enter button which enters it into the main table and clears the cells

MacBook Air 13″, macOS 11.6

Posted on Sep 30, 2021 2:22 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 30, 2021 5:11 AM

Have you noticed that if you have a table where you do NOT have extra blank rows at the bottom then you can can simply click anywhere in the last row, hit <return> and a new row appears with formulas automatically filled in?


For example, starting with:





Hit <return> and you get this automatically:




You need to already have at least two rows with the same formula for this to work.


This works even if you have Footer Rows. Just click in the last body row and hit <return>.


Very handy!


SG

1 reply
Question marked as Top-ranking reply

Sep 30, 2021 5:11 AM in response to Hudhaifah

Have you noticed that if you have a table where you do NOT have extra blank rows at the bottom then you can can simply click anywhere in the last row, hit <return> and a new row appears with formulas automatically filled in?


For example, starting with:





Hit <return> and you get this automatically:




You need to already have at least two rows with the same formula for this to work.


This works even if you have Footer Rows. Just click in the last body row and hit <return>.


Very handy!


SG

Automatically insert row after record entry

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