Blog Stats
- 2,678,520 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
Monthly Archives: March 2017
Simple trick to look (hack) into hidden sheet
This post is inspired by the previous post Excel Humor #9 – You do not see me Situation Suppose you are going to share an Excel workbook to your colleagues. However there is a worksheet with sensitive data that you don’t want them to … Continue reading
Excel Humor #9 – You do not see me
This is a true story with modification… I can’t believe it happened when I first heard it, but then I realize some changes made on Excel 2016 (not sure if also in Excel 2013). Here’s today humor: If you are working … Continue reading
Interactive Chart with navigation panel [NO VBA]
Isn’t it nice? Don’t think that this is difficult. No VBA is required. Indeed you only need to know a few Excel skills in order to create an interactive chart with navigation panel like this. The skills required: Conditional formatting … Continue reading
Posted in Chart
Tagged Conditional Formatting, Form Controls, INDEX, Interactive chart, Linked Picture, ROW
3 Comments
wmfexcel 