ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink - keyboard shortcut (https://www.excelbanter.com/excel-discussion-misc-queries/268084-hyperlink-keyboard-shortcut.html)

Xr8y

Hyperlink - keyboard shortcut
 
Pretty basic.. but I couldn't find the answer. I have a bunch of hyperlinks and I want to access them without using the mouse. Any help appreciated :)

thewizard

Quote:

Originally Posted by Xr8y (Post 962030)
Pretty basic.. but I couldn't find the answer. I have a bunch of hyperlinks and I want to access them without using the mouse. Any help appreciated :)

Hi, use the keyboard to navigate to the cell with the desired hyperlink. Press "Shift" and "F10." Use the keyboard to select "Open Hyperlink."

Xr8y

Quote:

Originally Posted by thewizard (Post 962047)
Hi, use the keyboard to navigate to the cell with the desired hyperlink. Press "Shift" and "F10." Use the keyboard to select "Open Hyperlink."

Great, thanks! :) that works.

I wonder if there is a quicker way??? It seems kind of time consuming for such a simple task... Shift+F10+"O"+"O"+Enter. Hmmmm... kinda puzzled.

thewizard

You could record a macro to perform the steps. That way, you'd just have to press a single button.

Quote:

Originally Posted by Xr8y (Post 962057)
Great, thanks! :) that works.

I wonder if there is a quicker way??? It seems kind of time consuming for such a simple task... Shift+F10+"O"+"O"+Enter. Hmmmm... kinda puzzled.


Xr8y

Quote:

Originally Posted by thewizard (Post 962071)
You could record a macro to perform the steps. That way, you'd just have to press a single button.

Awesome. Thanks, I will try that. I haven't worked with macros yet, but i will give it a try.

thewizard

Let me know if you need help with this. I can create a guide if you can't immediately figure it out.

Quote:

Originally Posted by Xr8y (Post 962082)
Awesome. Thanks, I will try that. I haven't worked with macros yet, but i will give it a try.



All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com