Blog Stats
- 2,092,138 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- When unhide row doesn't work...
- 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
- UPPER, lower, Proper
- 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?
- Filter a list of items from a long long list
- Sequential number for visible rows only
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
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
Compare two #Excel workbooks for changes
In about 5 years ago when I was still using Excel 2010, I wrote a post Compare two documents for changes â Word and maybe Excel. Lukas left a comment: In the Inquire Add-In you have the option to compare … Continue reading
What-If analysis in #Excel – Part 2
Basic of Two way Data Table This is an extension of the post What-If analysis in #Excel. If you do not know about Goal Seek or One-Way Data Table, you may read Start the new decade with Goal Seek in #Excel and What-If … Continue reading
What-If analysis in #Excel
Basic of One way Data Table This is an extension of the post Start the new decade with Goal Seek in #Excel.  In that post, we talked about using Goal Seek to find the initiate savings required to obtain a … Continue reading
Start the new decade with Goal Seek in #Excel
Happy New Year of 2020! Wish you all an Excellent year decade ahead! đ Have you made your new year resolutions? Or you are relying on Excel to set your goals of the year? Did you know that Excel has … Continue reading
Insert Current Time or Today using #Excel functions or shortcuts
It’s not uncommon to insert a date stamp or time stamp on a spreadsheet. We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading
Create in-cell chart with Sparklines in #Excel
đ”đ€Do you wanna build the Sparklines? Sparklines is not a new feature of Excel. It was introduced in Excel 2010. Yes, almost a decade ago. But I am quite sure it’s still something new to a lot of regular Excel … Continue reading
Create in-cell chart with Conditional Formatting in #Excel
Have you ever seen an Excel sheet with in-cell bars to visualize the data like the ones below, and wonder how they are made? Believe it or not, you can do it in one less than a minute with Conditional … Continue reading
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
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
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
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
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
