Excel Right Click Cell, Open File Path, Create Hyperlink

0

I need to create hyperlinks to words in individual cells. Is there anyway I can right click on the cell and that directly opens "My Documents" folder and the file I click on creates a hyperlinks?

L White

Posted 2017-03-13T17:44:24.647

Reputation: 11

you can select the cell and Insert Hyperlink and choose the file – yass – 2017-03-13T18:14:00.290

By doing so, I would have to click several folders to get my file. When you have dozens of cells to link, it becomes overwhelming. I need a right click that can take me directly to the folder I need. – L White – 2017-03-13T22:24:49.773

Answers

0

Create the First Hyperlink as usual:
Write the word in the cell select the cell
Insert Hyperlink and choose My Documents then OK
Copy or Drag the cell with Hyperlink to other cells
Write the word you want and when you click on it, it will open My Documents
The Hyperlink is copied to the other cells even if you change the content (word)

yass

Posted 2017-03-13T17:44:24.647

Reputation: 2 409