Not sure. Could you attach the file where this has happened?
Why add at the top? Add to the bottom then sort. No need to insert.


You could set the print region manually. Select what you want to print, go to the Page Layout tab of the ribbon and click the Print Area icon and choose Set Print Area. Then print.
Alternatively, select the area you want to print, go straight to the Print Dialogue and choose Print Selection:
2024-09-29_224022.jpg

Correct.

Perfect!

Regarding Pecoflyer's suggestion of making the Original Grocery List a proper Excel table; I too considered that (it's very useful) but decided against advising that because you said that the user was not proficient at Excel. If the user tried adding a new entry not directly beneath the existing table (leaving a blank row inbetween, say to separate different day's purchases) then that row wouldn't get added to the table (the table wouldn't resize to include that new data). This would mean the pivot table source data wouldn't expand to include the new data. I didn't think you'd want to start training the user about adjusting a table's range.

What I did was to set the pivot table's source range to extend as far as you had added data validation to the cells, which was some 10,000 rows. I filtered out the blank rows in the Items field in the pivot (you could do that on the Date field instead). It'll take some time to fill 10,000 rows of purchases, let alone 20,000!

Or you can define a dynamic named range, and set it as print region.