Tag Archives: HYPERLINK

Send a cell content to Google search

Posted on June 29, 2019 by

This is a continuation of previous post, in which I talked about the potential use of Smart Lookup for an Excel  dashboard.  However there is limitation.  It drove me to think of an alternative. Instead of asking user to trigger Smart … Continue reading →

Rate this:

Posted in Formula | Tagged | Leave a comment

Has Space or NoSpace in worksheet name?

Posted on March 1, 2018 by

Have you received workbook from others that carries underscore _ as if a space in their worksheet names?  Did you wonder why people use underscore when we can actually use space in worksheet name? Well… did you know… long long time ago, #Excel … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

The missing link of HYPERLINK function in #Excel help

Posted on February 17, 2018 by

I seldom use the HYPERLINK function in #Excel.   Normally I insert hyperlink by CTRL+K, then setting the reference I want the link to go to.   That is super easy (or quick and dirty)! Note: You may go to Insert tab on ribbon … Continue reading →

Rate this:

Posted in Formula | Tagged | 2 Comments