Pages 10.1, Numbers 10.1, and Keynote 10.1
Apple has updated all three of its iWork apps to version 10.1, bringing more video capabilities to Pages, Numbers, and Keynote. You can now add YouTube and Vimeo videos to your documents and spreadsheets by copying the video URL, clicking the Media button and selecting Web Video, and then pasting the URL to insert it. You can also add titles and captions to objects in Pages and Numbers (including Web videos, image galleries, drawings, text boxes, and charts). Pages can now import an iBooks Author book for editing, and Numbers adds new functions that enable you to match patterns, manipulate text, and create flexible formulas.
Keynote now enables movies and audio to play through slide transitions (by adding the same file to consecutive slides), adds the Play Slideshow in Window option to give you access to other applications while presenting locally or via video conferencing, and improves object pointers so they stay pointed in the correct direction while following a motion path. (Free; Pages, 299.9 MB, release notes; Numbers, 215 MB, release notes; Keynote, 435.5 MB, release notes; macOS 10.14+)
(I’m posting here because I first had the problem with Numbers 10.1.) How can I easily get to the bottom of a Numbers spreadsheet that just refreshed itself on an iPad?
When I make Numbers the active app on an iPad, sometimes it refreshes the active spreadsheet. (This is sometimes appropriate, because occasionally I have edited the spreadsheet on a Macintosh. The spreadsheet is stored in iCloud.) If Numbers has refreshed the spreadsheet, it seems to make the upper left cell visible on the screen. I typically want to edit in a cell near the bottom of the spreadsheet.
It used to be that I could edit the Numbers spreadsheet on my Macintosh, save it with the active cell near the bottom, and open it on the iPad with the active cell preserved. This was useful because then I could use the arrow keys on the iPad’s external keyboard to change the active cell, which would bring it into view. Numbers 10.1 does not preserve the active cell, the arrow keys have no apparent effect (until I select a cell, but I can only select a cell that I can see), and I scroll to the bottom by dragging repeatedly. (The spreadsheet has about 800 rows, is growing, and I shudder to think of the pain it would be to edit the spreadsheet on a screen the size of the original iPhone SE.) I believe the new behavior is related to the new reading mode (I don’t know what Apple calls it, but the counterpart is Edit mode), but I’m not sure.
Repeating the opening question, how can I easily get to the bottom of a Numbers spreadsheet that just refreshed itself on an iPad? Thanks for any help.
(Edited to add that Numbers 10.2 for Macintosh requires Catalina, which I plan not to install. I would like to use the same version of Numbers on both the Mac and the iPad.)