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!
Table of Contents
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.
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!
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.
Double-click the Format Painter button.
You can now apply it again and again without pressing the Format Painter button!
POWER TRICK #3:
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!
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.
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!
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.
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!
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.
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!
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.
The Format Panel is shown right away.
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.
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).
POWER TRICK #10:
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.
- 333 Excel Shortcuts for Windows and Mac
- How to Master Excel Formulas – The Ultimate Guide
- Mastering Excel Skills from Basic to Advanced
Bryan is a best-selling book author of the 101 Excel Series paperback books.