autofill in numbers macOS

1. “Help” tells me the same thing as you do. And I am fairly certain that I have been doing that correctly.
2. I’ll come back to this.
3. Thanks for the description of another way to get the dates added incrementally.

Something I noticed now:

• If I’m in the ‘table’ and I select a row, then I select Row Actions, I can’t add any rows above or below the selected row.
• If I select the row immediately below the ‘table’, then I select Row Actions, I can add a row below the selected row, but not above it.
• if I go further down the sheet and select a row, then select Row Actions, I have the option of adding rows both above AND below the selected row.

My question now is, is that how it should be?

While I send you this, I’ll attempt the suggestion that you made which I said that I’d come back to.

Again, thank you! And I’m sorry that I’m so frustrating for you.

I can’t show you the original sheet because I have deleted it. Unless there is a way to undelete a deleted sheet.

But my original sheet had rows below where the data ended, like in this image.

What do you call that? Where does the table end?

Thanks for your reply, @Badunit.

I think that you have described the boxes better than I did! Essentially they are the same thing that you have described as what I’m seeing. You just used the right words - thank you.

Your next question:

If it is that, add more rows to the table first. If it is not that, is there anything special about that row that you can tell?

Adding more rows is how I got the extra rows initially. No, I can’t see anything special about the row or the cell in particular.

You asked:

You describe not being able to drag the box past a certain row. Is it the last row of the table?

How can I tell if it’s the last row of the table? There are certainly rows below it, but what determines whether they are part of the table or not?

You asked about the brown box:

What is the box? What is its function? I cannot drag the yellow circle at the centre bottom of the brown box any further than the ‘last row’.

Then you stated:

Some additional info for completeness: If you have a pattern of formulas (not all the same formula), you can select the cells in the pattern and drag down with them all and it will duplicate the pattern as it goes.

What I’m trying to fill is a series of weekly dates. Nothing very complicated, I hope!

Thanks again.

I copied the whole table and then pasted it into a new spreadsheet.

I was then able to perform the operations that I was unable for do in the original sheet.

I’m working on my iPad at the moment, and I’m unable to get the autofill to work. It was working on the original spreadsheet but it wouldn’t let me go past that row.

I have deleted the sheet in the original spreadsheet and then copied back the sheet data from the new spreadsheet and so far, everything seems to be working as you have described.

Maybe there was a corruption issue with that sheet. I don’t know.

For now, it seems to be solved. Thank you for your patience with me today.

It was your suggestion that put me on the right track to solve the problem. Give yourself credit for that, please! I certainly wouldn’t have come up with that solution on my own.

Thank you, SG.