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

➲ Continue Reading

Excel’s AUTO FORMAT Option

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

➲ Continue Reading

Excel Fill Justify to Merge Text from Multiple Cells to One Cell

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

➲ Continue Reading

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

How to Copy Chart Formatting To Another Excel Chart [Trick]

Let’s say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format.Applying the same formatting to all the charts is a tedious task, the same thing again and again.It’s a pain.The good news is: there is a super quick solution to your pain. All you […]

➲ Continue Reading