Have you ever shared a link to a spreadsheet with many worksheets and wanted to let people open a specific worksheet by default when they access the link?
This is a commom need, but Excel remembers the last worksheet you were on, and launch that worksheet directly when you opened the file the next time. For the convenience, you may have bulit a navigation worksheet that contains links to all the worksheets in your spreadsheet. This article will tech you how to make a link to the navigation worksheet specifically.
The secret is to add a query parameter to the link.
Assume that you have a link to a spreadsheet like this:
https://yourcompany.sharepoint.com/:x:/s/CustomerFeedback/EQSrA0CJP9tOuX1oOLD9TGsBWUASTzVjxkBc1arF4F3-NQ
And the navigation worksheet is named “Nav”. What you need to do is to add ?activeCell=Nav!A1 at the end of the link. The complete link will look like this:
https://yourcompany.sharepoint.com/:x:/s/CustomerFeedback/EQSrA0CJP9tOuX1oOLD9TGsBWUASTzVjxkBc1arF4F3-NQ?activeCell=Nav!A1
This will make the link open the navigation worksheet when you open the link.
Also, you may wonder what !A1 means. It means the cell A1 in the navigation worksheet. When you open the link, Excel will automatically scroll to the cell A1 in the navigation worksheet. You can change the cell to whichever you want, but you cannot omit it because it is required. !A1 is usually fine for most cases.
A simple but usefull trick, right? Wish you enjoy it.