Category Archives: Excel Tips

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

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

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! 😉

Rate this:

Posted in Excel Tips | Leave a comment

Hide and Seek – Scroll Bars and Worksheet Tabs in #Excel

Did you encounter this?  All the worksheet tabs and scroll bars are gone in your Excel workbook!!! 🎶🎶 Tell me… how am I supposed to work without you…🎶🎶   No worries!  They are not gone.  They are just hidden (by … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – Formula Bar, Column and Row Headers

Have you ever experienced a shocking moment like this in #Excel? We are so getting used to see the formula bar, Column and Row headers that we take it for granted.  They should always be there for me…. aren’t they? … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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

Rate this:

Posted in Excel Tips, Power BI Desktop, Power Query | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , , , | 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

Rate this:

Posted in Excel Tips, Shortcut | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , , | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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

Rate this:

Posted in Excel in Action, Excel Tips | Tagged , , , , | 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

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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

Rate this:

Posted in Excel Tips | Tagged | Leave a comment