Blog Stats
- 2,678,490 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
- Do Not input “-” for zero. Use proper formatting in #Excel
- Convert numbers of different digits into text of fixed digits using #PowerQuery
- Convert numbers of different digits into text of fixed digits in #Excel
- How to replace value with a value from another column in Power Query
- The Power BI Journey
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- Be cautious when using XLOOKUP
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- How to lookup an image in #Excel
- Dropdown calendar in Excel
- Filter a list of items from a long long list
- When unhide row doesn't work...
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
wmfexcel 