Get instant access to this free e-book fully loaded with **Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes**.

You can’t add a zero before a number in excel. Whenever you try to add a leading zero, it disappears. Not matter what, how many zeros you trying to add, it will disappear. Let me tell you what’s the reason for this. In below example, I am trying to start a number with 0 but I […]

Check it out nowSerial numbers are an important part of data. Even every small data table in excel should have serial numbers. But, adding them manually is a pain. So, today I’ll show you 6 quick methods to automatically add serial numbers in excel. You can use any of these methods which you think is perfect for you. Table […]

Check it out nowSometimes, you have to perform some quick calculations in excel. And, you can use paste special for these quick calculations instead of formulas. In this post, you will learn a quick tip for these calculations. I will show you how can you use paste special to quickly multiply in excel. Not only multiple but subtract, divided, and […]

Check it out nowBullet point list is a useful method to stay organized, but unfortunately, there is no formal method to insert bullet points in excel. We don’t have any option in excel ribbon as we have in Microsoft Word. But that doesn’t mean we can’t insert bullet points in excel. In fact, we have more than one […]

Check it out nowEveryone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level. Do you? If not, then after reading this post you’ll love this tool. In this post, you will learn some useful examples to use find […]

Check it out nowDo you know a normal excel user press Ctrl + Z (undo) & Ctrl + Y (redo), 50 times in a day while working on a spreadsheet? And, still he/she is always confused that he/she has to press Ctrl + Z (undo) or Ctrl + Y (redo). Do you know there is a smarter way for Undo & Redo? […]

Check it out nowHere is the way 5 seconds way to Sort Columns In Excel in 5 seconds. Sorting columns in excel mean sorting data from left to right [horizontal direction]. This is useful when you have to streamline your data columns or you want to arrange them in alphabetic order. To sort columns in excel, all you have […]

Check it out nowI can bet, you never heard that you can select non-adjacent cells in excel without using a mouse. To select the non-adjacent cells most of the times you use CTRL + Click. But, now it’s time to change that way. In this post, I will show you how to select non-adjacent cells in excel without using […]

Check it out nowUsing Different Formatting In Single Cell sometimes makes a difference. While creating some awesome reports, dashboards, tables, etc. a small thing we always try to do perfectly, that is formatting. Formatting is the face of our reports. Excel gives us lots of options to makeover our spreadsheets (Font color, cell color, bold, italic, etc.). Have […]

Check it out now