Home » Questions » Computers [ Ask a new question ]

Specify a specific worksheet to open for a Microsoft Excel workbook using a hyperlink

Specify a specific worksheet to open for a Microsoft Excel workbook using a hyperlink

I have a Microsoft Excel workbook with several worksheets.

Asked by: Guest | Views: 56
Total answers/comments: 1
Guest [Entry]

"This worked for me in Excel 2007:

I named the exact cell I wanted to open (by just selecting it and then typing the new name in the Name Box, which can be found to the top left).

Then the hyperlink goes [filename with full path]#[cellname] obviously without the brackets.

E.g. http://pathpart1/pathpart2/workbook.xlsm#OpeningCell

""OpeningCell"" would be the name I'd given to the cell.

Note that it didn't matter which worksheet I was on when I last saved the file. With the hyperlink set up like this I get to the exact cell every time.

I hope this helps."