Position in the spreadsheet

What it is

After the page is reloaded, the spreadsheet opens on the same sheet, with the same scrolling by rows and columns and the same selection. Each sheet has its own position.

How to use it

1. Scroll the spreadsheet and select the cell or range you need.
2. Reload the page: you continue from that place.
3. Switching to another sheet does not erase the position on the previous one. When you come back, you are in the same place.

Limits

• The position is personal: other people in the workbook cannot see it.
• Each browser tab has its own position, even if the tabs have the same workbook open.
• The position survives reloads and navigation within the tab. Closing the tab or clearing the site data can erase it. It does not carry over between devices.
• The top-left visible cell and the offset inside it are remembered, so a new zoom and new row and column sizes are taken into account when you return.
• A deleted or hidden sheet is replaced by the first available one. The selection and scrolling do not go beyond the current size of the spreadsheet.
• The version history and a workbook preview in a chat do not change the remembered position.
• The draft of input, the clipboard and the undo history are not included.
• The remembered position does not save edits. Follow the saving through the status bar of the spreadsheet.

If something goes wrong

What you see on the screen	Why	What to do
After a reload, the start of the sheet opened	The position record is damaged, or the browser does not allow site data to be stored (including in private mode), or storage is full	Allow site data, or open the workbook in the browser’s normal mode
A different sheet opened	The earlier sheet was deleted or hidden	Choose the needed sheet at the bottom
A neighbouring cell opened, not the one you stopped at	Rows or columns were deleted	Go to the needed cell; the new place will be remembered