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 […]

➲ Continue Reading

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 of the useful codes examples to help you […]

➲ Continue Reading

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

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 to in data tables but when you are working on lists the best way is to use bullet points.I mostly use bulleted lists to capture my day to day work (To do lists, Important points).Now, the bad […]

➲ Continue Reading