Tag Archives: HYPERLINK

Send a cell content to Google search

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 | 10 Comments

Has Space or NoSpace in worksheet name?

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

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 | 6 Comments