Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to open hyperlinks in excel without mouse-click; is there any shortcut key/Keys

I have many hyperlinks in a column of excel-sheet.

Is/Are there any shortcut key/Keys so that after going to each cell(using keyboard) I can open those in browser without using mouse-click?

like image 818
Avidan Avatar asked Jan 28 '15 09:01

Avidan


1 Answers

In Excel 2016 (English version), I would say that the simplest way to do this is to

  • press the menu key (that has a similar effect to a right click)
  • press "o" twice
  • press "Enter".

The first "o" goes to "sort" ; the second "o" goes to "Open Hyperlink", and "Enter" then opens the hyperlink.

On a keyboard that does not have a menu key, one can press Shift + F10 instead.

menu key

Excel menu with open hyperlink selected

like image 63
Alexandre d'Entraigues Avatar answered Sep 19 '22 22:09

Alexandre d'Entraigues