73 Shortcuts for Excel

Shortcut 33 - Ctrl+Shift+G - Google a Cell

What if you could press Ctrl+Shift+G and whatever cell you're on will open google on the content of the cell.

This requires some VBA/Macro knowledge but is well worth it.

Find out how to use a URL to google something.

https://google.com/search?q=[search string]

https://google.com/search?q=chess

URLs and Parameters

URL is acronym for Uniform Resource Locator which doesn't mean much. It's also known as a web address.

It's what you type into a browser to go somewhere on the internet or when you click a hyperlink.

After the website name there is an optional

File name

Parameters

In the google example the "q" is the query parameter.

for parameters the first one begins with a ? (question mark) and the subsequent ones start with an & (Ampersand).

See the video at http://xl4b.com/Google_it

Steps:

Open the Visual Basic Editor

Add a module if one doesn't exist

Copy in the RunProgram code

Add the following



Sub GoogleIt()

  RunProgram "https://google.com/search?q=" & activecell

End Sub

Assign To a Shortcut key

Macro Dialog

Select "GoogleIt"

Press Options and set the key to Ctrl+Shift+G