Discussion :

[licpegpon]

Bonjour,

Lorsque j'ouvre un fichier Google sheet, je voudrais que celui-ci se positionne systématiquement dans un onglet particulier (par exemple onglet "Feuille 1") et que le curseur se positionne en cellule A1 (par exemple). Comment dois-je procéder SVP ?

Cdlt.
Jérôme.

[licpegpon]

Bonjour,

Voici la réponse faite par le forum support Google :

When you open a spreadsheet from Google Drive, you will always land in cell A1 of the first tab.

If you want to go to some other specific cell when you open a spreadsheet, the easiest way is to use a bookmark to a link like this:

https://docs.google.com/spreadsheets/d/[spreadsheet ID here]/edit#gid=[sheet ID here]&range=B2

You can get these links by right-clicking a cell and choosing Get link to this cell.

This feature only works when you have the link in a bookmark or in a text file or similar — when you open the file from Google Drive, you land at cell A1 of the first sheet.

If you want to open the spreadsheet at the last edited cell, or at the row with today's date, you will need to use a script like jumpToToday_.