How to Multiply in Excel Using Paste Special Option

Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations instead of formulas.In paste special, you have four different options [Add, Subtract, Multiply, and Divide] which you can use.And today in this post, I’d like to show you how can you use paste special to […]

Top 100 Useful Excel Macro [VBA] Codes Examples

Top 100 Useful Excel Macro [VBA] Codes Examples Macro codes can save you a ton of time. You can automate small as well as heavy tasks with VBA codes.And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has?So today, I have listed some […]

Consolidate Data From Multiple Worksheets in a Single Worksheet

 In my starting days with Excel, I was really bad in capturing data. If you asked me to capture sales data for four different zones, I will create four different worksheets for that.  I was that bad. But, you always learn with your mistakes. Am I right? And, if you are doing the same mistakes like I […]

How to Highlight Blank Cells in Excel

It’s hard to recognize blank cells in a large data. Because a blank cell is just a white cell without any value.In most of the cases, blank cells represent some sort of gap, missing data, or a formula returns an empty string resulting in a blank cell.And that’s why it’s recommended to highlight these cells […]

How to Insert Bullet Points In Excel

How to Insert Bullet Points in Excel Capturing data in a right way is really important. In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet points. ​I mostly use bullet point lists to capture my day to day work (To do lists, […]