Return to active Numbers cell

Today's Best Tech Deals

Picked by Macworld's Editors

Top Deals On Great Products

Picked by Techconnect's Editors

Reader Moises Majchel finds an unwelcome view when he opens a saved Numbers document. He writes:

When using Numbers, every time I open a saved spreadsheet, the view goes to Row 1, Column A. Since I use very long spreadsheets it is bothersome to have to look for the place where you finished working last time. How can I save the spreadsheet and open it later in the last place I was working?

First, make sure that when you save the document before closing it, the cell you’re working in is selected. Unless you’ve zoomed in on the document, Numbers documents should open displaying the selected cell. However, if like many people, you use a zoomed view, Numbers will save that view. Open the document and it’s likely you’ll see something other than the selected cell.

There’s an easy way to locate it, though. Just tap an Arrow key. Do so and the document will move to the location of the currently selected cell, which will be one cell away from the cell you were last working with.

Note: When you purchase something after clicking links in our articles, we may earn a small commission. Read our affiliate link policy for more details.
At a Glance
  • Pros

    • Trend lines and error bars on charts
    • Extensive function help
    • Keyboard entry of functions
    • Beautiful templates
    • New chart types
    • Table Categories ease data analysis
    • Many added functions


    • No support for Excel macros
    • Exports to Excel require rework
    • Some frustrations from Numbers '08 remain
    • Unable to lock cells
    • Larger files slow down the program
Shop Tech Products at Amazon