Pinterest Pixel

Top 10 Excel Double Click Mouse Tricks

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

Download Excel Workbook
Bryan
Posted on

Overview

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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

Here are the Top 10 Double Click Cell in Excel Tricks for Excel Power Users like you!

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

Download excel workbookDouble-Click-Mouse-Tricks.xlsx

 

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.

Top 10 Excel Double Click Mouse Tricks

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

Top 10 Excel Double Click Mouse Tricks

 

Watch Excel double click shortcut on YouTube and give it a thumbs-up!

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

Double-click the Format Painter button.

Top 10 Excel Double Click Mouse Tricks

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

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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 Excel double click cell on the sheet name and you can rename it right away!

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

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

Top 10 Excel Double Click Mouse Tricks

You now have your formula applied to the whole column!

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline
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!

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

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.

Top 10 Excel Double Click Mouse Tricks

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

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

The Format Panel is shown right away.

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

Double click on that cell.

Excel will open a new worksheet with the data relating to that cell. This is how you can use Excel double click to source!

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

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

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.

Top 10 Excel Double Click Mouse Tricks

Top 10 Excel Double Click Mouse Tricks | MyExcelOnline

Further Learning:

If you like this Excel tip, please share it
Top 10 Excel Double Click Mouse Tricks | MyExcelOnline Top 10 Excel Double Click Mouse Tricks | MyExcelOnline
Top 10 Excel Double Click Mouse Tricks | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  How To Use Excel For Dummies

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...