Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for Excel Tips

Sort Horizontally

sort columns in excel

Have you ever wondered that you can horizontally sort data in Excel? I mean, you can sort columns like you sort rows.This is a useful option to streamline columns or if you want to arrange them in alphabetic order.Want to know the best part?You just need 5 seconds for this.So today, in this post, I’d […]

Check it out now

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone.But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

Check it out now

Fill Justify

fill justify to replace with merging option

Fill justify is a life saver option.The single core motive to use fill justify in excel is to merge the data from multiple cells into a single cell.And, if you  have any other idea to merge text into one cell, leave it. Fill justify is a better option.So today, in this post, you will learn […]

Check it out now

Automatically Add Serial Numbers In Excel

how to automatically add serial numbers in excel featured image

Serial numbers are like salt. Their presence is not felt, but absence makes your data tasteless. Yes, they are important.With a serial number, you will have a unique identity to each data entry. But the sad news is, adding them is a pain. It’s really hard to add a number in every row one after […]

Check it out now

How To Multiply In Excel Using Paste Special

how to multiply using paste special in excel featured image

Sometimes, 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 now