# 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

## Overview

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!

## 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.

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

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

## 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.

Double-click the Format Painter button.

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

## 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!

## 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.

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

You now have your formula applied to the whole column!

## 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.

## POWER TRICK #6:

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!

## 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.

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.

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

## 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.

The Format Panel is shown right away.

## 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?

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

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).

## 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.

Further Learning:

##### 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.