I have a Numbers spreadsheet that lives in iCloud. I use edit on both an iPad and on a Macintosh. If I edit the spreadsheet on the Macintosh, save it in iCloud, and then open it on the iPad, it has no active cell. This means that I must scroll to the end (where I enter new information) by repeatedly swiping upward, which is tedious. With an earlier version of Numbers, the active cell stayed active, and I could use an arrow key on the iPad’s external keyboard to move it and the active cell would jump into visibility on the screen, with no scrolling required. When I open the spreadsheet on the Mac, where I can easily scroll using the mouse or page down with the keyboard, the active cell from the last edit on the iPad is still active. How can I keep the active cell when I open the spreadsheet on the iPad after editing on the Mac?
There must be some nuance that I’m missing, because on another sheet (tab in Excel-speak) in the same file, the active cell remains active, but on the primary sheet, it does not. Of course, the primary sheet has about a thousand rows to scroll through. This behavior is independent of which sheet I edit on the Mac.
Any ideas? Thanks.