[Affiliate]
Blog Stats
- 3,307,439 hits
-
Join 3,248 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Copy data from strictly-protected sheet
- Dropdown calendar in Excel
- When unhide row doesn't work...
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- A twist to turn Keep Duplicates into Keep Unique in #PowerQuery
- Advanced vlookup - wildcard characters "?" and "*"
- Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
- Convert text date into date with Power Query for #Excel
My YouTube Channel
My Facebook page
- My Tweets
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
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
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



