Share an Excel Spreadsheet to open on a Specific Cell
I had an interesting request from a customer today. They use large spreadsheets and work in SharePoint and Teams.?They share links to spreadsheets, but when a user opens it they need to scroll through hundreds of rows or tab through multiple worksheets to find the information they need.?
They asked if it was possible to share an Excel workbook but have it so when the recipient opens it, it will open at the right spot for the information required.?
It just so happens there is way to do this.
Firstly create a shared link to the workbook you want to distribute by right clicking on it in SharePoint, OneDrive or Teams, and selecting "Share". Don’t forget to scope who your document will be shared with.?
Once you have configured those items, you’ll be able to copy the link.?Below you can see I’ve made it so only people in Contoso can edit the link.
Copy the link, and then paste it into Notepad, your browser, or anywhere you can paste text to edit it.?Once you’ve done that – simply add the following on the end of the URL.
&activeCell=SheetName!CellNumber
In my example below, I want the Excel spreadsheet to open on Sheet1, Cell B13.?So I’ve written &activeCell=Sheet1!B13 on the end of the URL.??
This now becomes the link you share.?When your intended recipient opens the URL, it will open to that exact location in the spreadsheet as you can see with the highlighted cell.
If you found this useful, feel free to like/share it and tell your friends or simply connect here on LinkedIn to follow my other articles and posts.
Development Technician at Magna Steyr
1 年Does not work for me in Oct. 2023 with Excel German Version 2302 (Build 16130.20218 Klick-und-Los). Neither Excel Web in Browser nor in the App. I'd like to see this working - in a consistent manner both in web-Excel and in the App. Also for write-protected spreadsheets.
Content Strategist and Manager
1 年Hey, nice trick! But, somehow, it didn't work for me. Maybe because this is a bit old. Now, Excel has this built-in feature where you can link to a specific cell. Just tap on the cell you want to link and right-click to open the menu. Scroll down to find "View more cell actions." Hover over it and click on "Get link to this cell." Tapping on it will copy the link to your clipboard. Share the link with your peers!
Director of Product Management at Blackhawk Network
1 年If you can't get this to work, and you're getting "This link has been removed" when you add &activeCell=Sheet1!B13 you likely just need to change the "&" to a "?". This seems to be especially true when you are linking to a document shared from OneDrive. Example: https://companyname-my.sharepoint.com/:x:/g/personal/username_companyname/Ed3jLXxZfEdDvTEVAAxBQsAB1EfWrX4Mt-bt4EqS_b5UuQ?activeCell=Sheet1!A1 That should fix the issue. I didn't see this tip anywhere online and I just figured it out, so thought I would share in case this is your issue!
Currently employed with a great company and not responding to requests for opportunities.
1 年I know this post is a bit old, but it still works 100% (Thank you for that!). Do you happen to know if there is an additional string I can add to the end to also force the link to open the file in the app and not in the browser?
Software Validation Manager at Ansys, Inc.
2 年Nice post, Noel. Also, if you have spaces in your Sheet Name, you need to surround it by single quotes, like for example: ...&activeCell='Sheet With Spaces'!B2 (note that this will be replaced in your browser by ...&activeCell=%27Sheet%20With%20Spaces%27!B2 because %20 is the encoding for a space and %27 is the one for single quote)