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

How To Highlight Top-Bottom N Values In Excel

The best way to highlight top bottom values is by using conditional formatting. It’s quick, simple and all you need a few clicks. But, the best part is, you don’t even have to write a formula for this. I have been using this since I have got my first job. Whenever my boss called me with […]

1 14 15 16 17 18 28