Jump to last row
I have a numbers spreadsheet that has above 700 rows. How can I jump to the last row?
iPad, iPadOS 17
I have a numbers spreadsheet that has above 700 rows. How can I jump to the last row?
iPad, iPadOS 17
If you've got a keyboard you can use command-down arrow.
SG
If you've got a keyboard you can use command-down arrow.
SG
There do not appear to be any shortcuts for scrolling tables in the iOS version of Numbers. You might be able to shorten the process of scrolling this way, though:
In a new column put the formula ROW()=ROWS(A) in all data rows. It will be FALSE for all but the last row of the table.
Make a filter for that column to show rows that are TRUE.
You can hide this new column.
To use it,
I don't know if this is less work than manually scrolling 700 rows but it certainly would be for longer tables.
With a different formula you could have other rows showing instead of just the last one so you can get to particular other rows in the table more quickly.
Got another idea that requires no formulas or extra columns:
I haven’t got a keyboard
Many, many thanks. Absolutely brilliant!
Jump to last row