How to autofill rows until manual change in Numbers

I created a form for studying that has a column for “Page Number”.

I want to type in an entry, e.g. “6” for page 6, but I also want every subsequent entry to essentially act as an “ibid” entry, automatically filling-in a “6” until I manually change it, say to “7”, and then it would continue auto-entering “7” until I’m ready to enter some other number and go on from there.


As you can in the image below, there are numbered entries for both “Chapter” and “Page No.” columns. I’d like the blank spaces to essentially repeat the entry number above them until such a time as a new entry number is entered.



[Re-Titled by Moderator]


iPad Air, iPadOS 17

Posted on Feb 22, 2024 1:37 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 22, 2024 4:17 PM

If you are starting from scratch,

  1. In cell B3 put the formula =B2
  2. Copy that cell and paste it to the rest of the column. Or drag-fill down from B2 to the end.
  3. At whatever row you want it to change to another number, type that number into the cell, which will overwrite the formula in that row.


If you are not starting from scratch, at step 2 you will paste the formula into the blank cells and not into the cells that already have numbers in them.


Note that the table cannot be sorted, column B will become a mess if you do.

2 replies
Question marked as Top-ranking reply

Feb 22, 2024 4:17 PM in response to Jsam178

If you are starting from scratch,

  1. In cell B3 put the formula =B2
  2. Copy that cell and paste it to the rest of the column. Or drag-fill down from B2 to the end.
  3. At whatever row you want it to change to another number, type that number into the cell, which will overwrite the formula in that row.


If you are not starting from scratch, at step 2 you will paste the formula into the blank cells and not into the cells that already have numbers in them.


Note that the table cannot be sorted, column B will become a mess if you do.

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.

How to autofill rows until manual change in Numbers

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