Apple Intelligence is now available on iPhone, iPad, and Mac!
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
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
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
