Office 365 excel hyperlink for particular worksheet ?

Alex CHAN 21 Reputation points
2021-09-17T09:29:12.67+00:00

I've create an Excel on Office365, and shared. Where can i find a hyperlink for this excel which point to particular worksheet, so that when another ppls click the link, it will show the correct worksheet?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,068 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,126 Reputation points
    2021-09-20T06:56:34.417+00:00

    Hello @Alex CHAN ,

    Welcome to Q&A Forum!

    According to my test, we cannot obtain a hyperlink to a particular worksheet in excel file. In other words, we cannot get the Office 365 excel hyperlink of a specific worksheet.

    Thanks,
    Echo Du

    =========================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


2 additional answers

Sort by: Most helpful
  1. Fabien Basmaison 1 Reputation point
    2022-04-01T13:55:01.297+00:00

    @Alex CHAN  : You can add a comment to any cell in any WorkSheet.

    From my experience, using the link to this comment should open the proper worksheet with the cell where the comment is, focused, and with the comment open.

    0 comments No comments

  2. Michael Harlow 1 Reputation point
    2022-04-08T21:56:03.333+00:00

    I found that if you add &ActiveCell='WorksheetName'!A1 to the end of the share URL it will open to the specified worksheet.

    If you want a specific cell in the worksheet then alter the A1 to the cell reference you want.

    I have tested this successfully.