Blog Stats
- 2,511,767 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- When unhide row doesn't work...
- Dropdown calendar in Excel
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
SUMIF vs. GETPIVOTDATA in terms of performance in #Excel
Did you experience a slow workbook? How slow? Let’s say it takes more than 2 minutes to just open the file. This is actually what a colleague asked me for help. When I opened the workbook, I saw LOTS of … Continue reading
The very hidden gem of AutoFilter in #Excel
Don’t get me wrong. I am not talking about the Filter button sitting on the Data Tab of ribbon, although they look almost exactly the same. I am pretty sure that most people who use Excel five days a week … Continue reading
The proper way to filter values not equal to zero in #Excel
I didn’t think of blogging about this topic before. I thought that it is so straight-forward. Nevertheless, there is another way of doing so which is even more straight-forward BUT may give you unexpected results later on. And to my … Continue reading
Reapply Filter in #Excel
Did you notice that there is a “Reapply” button next to Filter on the Data Tab of ribbon? And wondering what it does? 🤔 Indeed, the “Reapply” button is dim until you have applied filter to at least one column. … Continue reading
Data Cleansing is never easy, even with #Excel Power Query
Don’t make me wrong. I am not complaining Power Query at all. If you have followed me for a while, you should know that I am a big fan of Power Query indeed. It is simply powerful! With Power Query, … Continue reading
Filter: It’s easy and not easy
Applying filter in Excel is a very common task. We used to filter a dataset and focus on a subset of data that we are interested in. It is super easy to filter. The problem is, are you sure you … Continue reading
Add emoji to your numbers 😁 in #Excel
Is it possible in #Excel? Of course, as you have just seen it! 😁 Indeed, it’s easier than you may have thought about. We can do it by custom format. First of all, select the cells that you want to … Continue reading
Quick Tip – Close all #Excel workbooks at once
Have you ever had more than 10 workbooks opened at the same time? Did you spend too much time to close them all one by one? If so, you will love this simple trick to close all workbooks simultaneously! The … Continue reading
Dense Ranking with Power Query – Unexpected Behavior and Workarounds
This post is inspired by the article – Dense Ranking in Power Query, written by PHILIP TREACY from myOnlineTraingHub. The first part of this post is a summary of what I read from Philip’s post. While the second part is … Continue reading
Replace values in filtered ranges using Copy and Paste trick in #Excel
Situation: In a filtered range of data, we made few changes on the side. Then we want to replace the original values with the updated values. What action appear on top of your mind? Copy and Paste of course. But… … Continue reading
Understanding Find and Replace in #Excel
Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading
Quick Tip – Probably the quickest way to open txt file with #Excel
Are you tired of seeing the (Text Import) Wizard 🧙♂️ every time you open txt file with Excel? In this super short video, you will see probably the quickest way to open a txt file with Excel. Enjoy! 😉
Posted in Excel Tips
Leave a comment
Lovely stickers in #Excel 365
Do you use stickers when you use communication apps like WhatsApp? I guess that’s almost a must-have features right now for communication apps. Would it be nice if you can use stickers in Excel too? Yes… you can, if you … Continue reading
Should I link to other workbooks…
…when writing #Excel formula Note: This post is not about “security” issue 🤷♂️ Is the following message familiar to you? I wonder… when you see this message, which button would you click? Please let me know by leaving comments … Continue reading
Quick tip – Zoom in and out of the #PowerQuery editor
In both #Excel and #PowerBI Did you know… we can ZOOM IN or zoom out everything but ribbon in the Power Query Editor in both Excel and Power BI Desktop… … by pressing CTRL+SHIFT+= CTRL+SHIFT+- respectively. The story behind the … Continue reading
Replace blanks with zero in #Excel
Following the techniques used in the previous post , we can perform many Excel magics for different scenarios. On top of my mind is to replace blank cells with zero. The first task is to select all blank cells in … Continue reading
Posted in Excel Tips
Tagged Ctrl Enter, Find and Replace, Go to special, Keyboard Shortcut
Leave a comment
Delete rows with empty cell(s) in #Excel
Guess what? We are going to do it with a sequence of keyboard shortcuts only. Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading
