There are a lot of times when the mouse beats the keyboard in terms of efficiency in Excel.

Here are Top 10 Excel Double Click Mouse Tricks for Excel Power Users like you!

You will have a fun time increasing your productivity with these tricks!

DOWNLOAD EXCEL WORKBOOK

 

POWER TRICK #1:

Show or Hide the Excel Ribbon

There are times where we just want more space in our Excel Window and it is very easy to hide the Ribbon.

Double click on the active tab in your Excel Ribbon to hide it.

ribbon-01

Then you can double click again to show the Excel Ribbon.

ribbon-02

01-double-click-mouse-tricks

 

POWER TRICK #2:

Use Format Painter As Many Times As You Want

This is one very cool trick that saved me a lot of time! I wanted to copy the formatting, and I had to click the Format Painter multiple times.

It was cumbersome! Turns out there’s an option to lock in your Format Painter, so that you can reuse it again and again!

Pick the cells you want to copy the format from.

format-painter-01

Double-click the Format Painter button.

format-painter-02

You can now apply it again and again without pressing the Format Painter button!

format-painter-03

02-double-click-mouse-tricks

 

POWER TRICK #3:

Rename Worksheets 

Way before I found out about this tip, I had to rename worksheets by right-clicking on the sheet name, click on the Rename option, then type my name.

That’s a lot of steps!

An easier way, is to simply double click on the sheet name and you can rename it right away!

rename-01

03-double-click-mouse-tricks

 

POWER TRICK #4:

 Fill Formulas Down Vertically  

Imagine you had a Table, and you are creating a new column based on a formula’s output.

You can apply the same formula to the rest of the column with just a double-click.

Pick the cell that contains your formula.

fill-01

Double-click the lower right corner of the cell  to copy the formula to the rest of the column.

fill-02

You now have your formula applied to the whole column!

fill-03

04-double-click-mouse-tricks

 

POWER TRICK #5: 

Edit a Shape Quickly

If you have shapes, you can quickly edit shapes with just a double-click.

Double-click on your shape and you can edit the text of the shape quickly.

shapes-01

05-double-click-mouse-tricks

PIVOT BANNER

POWER TRICK #6: 

Auto Adjust Column Widths

There are a lot of times when I had data in a column but I could not see all of my data because the columns were too cramped!

Instead of adjusting the columns manually, there is a great double-click tip.

Double-click on the right edge of the column header you wish to resize and it will resize the column automatically for you!

auto-adjust-01

06-double-click-mouse-tricks

POWER TRICK #7:

Moving Across Cells of Your Data

Whenever I had a large set of data, I had to painstakingly scroll up to down, left to right, to move across the data…and boy, does it take a long time to scroll to the end of the data!

Turns out, there is a trick to quickly move across your data through double clicks!

Pick a cell you want to start on with.

move-01

Double click on the edge of where you want to go to.

For example, if we double click on the bottom edge of the cell, that means we will go downwards to the end of the data.

move-02

We have been quickly transported to our end of the data, without scrolling at all!

move-03

07-double-click-mouse-tricks

 

POWER TRICK #8: 

Access Chart Formatting Options Quickly

Whenever I had a chart and wanted to format it, I had to right-click the chart to select the formatting options. Turns out it is easily accessible through double clicking!

Double click on the border of your chart to access the formatting options.

chart-01

The Format Panel is shown right away.

chart-02

08-double-click-mouse-tricks

 

POWER TRICK #9: 

Show Pivot Table Data

Have you ever been given a Pivot Table, however you wanted to investigate the source data behind it to gain a better understanding?

Double click will help you with this too!

Have your Pivot Table ready.

Pick a cell that you wanted to drill down on.  In our example, Quarter 1 Total Sales.

pivot-01

Double click on that cell.

Excel will open a new worksheet with the data relating to that cell.  

(This data is for show only and any changes made here will not be reflected in the Pivot Table).

pivot-02

09-double-click-mouse-tricks

 

POWER TRICK #10: 

Close Workbook

You can also use the double click to close your Excel Workbook!

Go to the upper left corner of your Excel Application.

Double click on it and your Excel Workbook will close.

close-01

10-double-click-mouse-tricks

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Top 3 Excel Keyboard Tips There are a lot of hidden keyboard tricks to increase your efficiency in Excel. I am surprised myself with these hidden gems! Here are Top 3 Excel Keyboard Tips for Excel Power Users like you! You will have a fun time increasing your productivity with these tricks!  ...