Numbers spreadsheet doesn’t open where I left off

Hi GW,

"Curiouser and curiouser", said Alice.

Tested in Numbers 6.1 under macOS High Sierra 10.13.6

I can have a view of Row 3000 and I Save.

Close the document. It reopens with Row 3000 visible.

Quit Numbers and relaunch Numbers. The document reopens with Row 3000 visible.

Restart my machine and relaunch Numbers. The document reopens with Row 3000 visible.

I did not test with a document imported from Excel. This is a document created in Numbers.

What is your version of Numbers and macOS?

Regards,

Ian.

No way to do that that I'm aware of.

However, you can set the table up to let you quickly get to any row using command-F and a few keystrokes.

Add a column to your table. Enter the formula below in the first non-header cell in the new column:

=qwe&row()

Fill the formula into all cells of that column.

Once that's done, you can get to any row in the table by pressing command-f to open the find dialogue, enter qwe followed by the row number, then clicking Find next.

If you don't need that pin point precision, use this revision to the formula:

=IF(MOD(ROW(),20)=0,"qwe"&ROW()/10,"")

Fill down as before.

This will place the three character text string and the row number (without it final 0) in every twentieth row.

The search key will be restricted to even numbers, one digit shorter than the number of the row that is the desired target.

Regards,

Barry

From Numbers User Guide for Mac:

Use keyboard shortcuts in Numbers on Mac

You can use keyboard shortcuts to quickly accomplish many tasks in Numbers. To use a keyboard shortcut, press all the keys in the shortcut at the same time.

Move around within a spreadsheet

Shortcut for “Scroll to the end of the sheet” —> End or Fn-Down Arrow

Paul.

Paul writes:

"To use a keyboard shortcut, press all the keys in the shortcut at the same time."

That works if your coordination is perfect, but fails if you don't err in the 'right' direction.

My version: 'To use a keyboard shortcut, press and hold the modifier keys, then tap the action key.'

.

"action key" is always the last key named in the shortcut.

Regards,

Barry

You might want to try experimenting with this setting at System Preferences > General:

You could try unchecking Close windows ....

SG

Hi GobshyteWhyte,

If you have a footer row and an unused column put "Last Row" or "lr" or some such in the cell and do a find on that.

quinn