[Affiliate]
Blog Stats
- 3,287,192 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Copy data from strictly-protected sheet
- When unhide row doesn't work...
- Dropdown calendar in Excel
- Bug with copy and paste in Excel Table
- Convert an 8-digit number into Excel-recognizable Date
- Simple trick to look (hack) into hidden sheet
- Sequential number for visible rows only
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to lookup an image in #Excel
- Limitation (or bug?) with Filter by Color
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
The power of Dynamic Arrays in #Excel 365
… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult. It may require multiple steps, helper formula and/or helper tables though. And the number of helper tables depends on the complexity of the requirement. I … Continue reading
Posted in Excel in Action, Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, SORTBY, SUMIF
Leave a comment
Get a list of A to Z in #Excel
Have you ever tried to input “A” and then drag it down with a hope of getting a list of A to Z? If you tried (and without success), you may be wonder how I did it? You may find … Continue reading
Add Data Labels for Total to Stacked Columns in #Excel
When we create stacked columns in Excel, we exclude Total from the data as it may give an extra stack that we don’t want. However, we may want a data label for Total on the stacked columns, like the one … Continue reading
You think you know Copy and Paste in #Excel?
11 Excel Copy and Paste Tips and Tricks you should know Perhaps Ctrl+C and Ctrl+V are the pair of shortcuts you use on a daily basis. And probably you learned that on the first day your learned Excel. Nonetheless, do … Continue reading
Suggestion: Adding a button for number formats in thousand/million/billion in #Excel
Did you know what you may submit your ideas to improve Excel through UserVoice? The recent HOT news in the Excel community – the new XLOOKUP function is also resulted from an idea submitted in UserVoice. While everyone is super exciting … Continue reading
CTRL A to Z – Learn 25 #Excel Shortcuts with demonstrations
Do you know how many keyboard shortcuts we have in Excel? Honestly, I don’t know. I just know the shortcuts that I need to use. Believe it or not, from Ctrl+ A to Z, I use them all but M, … Continue reading
The proper way of copying worksheet in #Excel
It is not uncommon for people to copy entire worksheet to another sheet (be it on the same workbook, or another workbook, even a new workbook). Nevertheless, are we doing it the right way? Many people would do so by … Continue reading
Copy chart formats to other charts in Excel
If you know Format Painter, the on top of your mind solution should be using Format Painter to copy Chart Formats to other charts. However, it doesn’t work… 😦 No worries. Copy and Paste comes to recuse!! Really?!
Four Text to Columns tricks you cannot miss in Excel
Have your heard about “Text to Columns”? A big icon grouped into Data Tools of Data Tab of Excel? Be your answer Yes or No, you do not want to miss the following tricks that may help you transform data … Continue reading
Multiple short videos about using Fill in #Excel
If you have followed my blog for a while, you should know that I have created my YouTube channel recently. And a playlist – Excel Magic in One Minute was created in early June this year. So far, I’ve created 25 videos in … Continue reading
Free Excel Dashboard Webinars you should not miss
Have you ever had an Excel moment like this? “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s … Continue reading
[Guest Post] DRAW – The New Tab in Office 2019/365 for INKING
This is a guest post by Aprajita of ExcelChamps. Let me ask you something. Suppose you are presenting data to the management and suddenly an important point strikes your mind. Will you look around for a piece of paper and … Continue reading
Interesting behavior of Copy and Paste
This sounds silly, I know. To achieve what is stated in the above scenario, what we need to do is simply Select “January to March” from the slicer Copy the range C4:C9 Paste to C13 Then repeat the above steps … Continue reading
Updates on Excel Magic in One Minute
Six weeks ago, I created my YouTube playlist – Excel Magic in One Minute. As of today, I’ve already published 17 videos to the playlist. Meaning 2-3 videos per week. Not too bad as a weekend YouTuber (newbie), I guess. … Continue reading
Do your random numbers stay the same when you copy and paste in Excel?
This is an extension of my previous post – Freeze a random result with mouse trick. In my experience using Excel, from Excel 2000 to 2010, and recently 365 (I’d never used Excel 2013 though), I have experienced the same strange … Continue reading
Freeze a random result with mouse trick
Perhaps you have tried to use Excel to generate a random number for a lucky draw. That is easy. For example, if you want to generate a random number, you can use the function RANDBETWEEN. =RANDBETWEEN(1,1000) This will give you … Continue reading
How to sort bar chart in descending order?
Sound like a silly question, but it is a bit confusing indeed. One day, a friend asked me how to sort a bar chart in descending order. I told her to sort the data. She replied: “I did. The data … Continue reading
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
Smart Lookup in #Excel 2016 or later
Have your heard of Smart Lookup? Don’t confuse it with Excel Functions. It is nothing related to formula writing in Excel. Simply consider it is a web search engine (Bing) embedded in Excel. Watch it in action, and you will … Continue reading
Excel Magic in One Minute
Last Friday was a public holiday in Hong Kong. Yes, a long weekend! Guess what I dd over the long weekend? I’ve created a playlist – “Excel Magic in One Minute” on my YouTube Channel. The name says it all … Continue reading
wmfexcel 