Boost Your Productivity with Excel Mouse Double Click Tricks

In my first job, we had to go through a rigorous 3-week training before we got any real work.

One of the trainers was a 40 something guy with awesome Excel skills.

I used to call him the Excel Superman.

I still remember the first thing that he told us was to avoid the use of the mouse as much as possible and use the keyboard instead.

Till date, I completely agree with him.

If you want to be super fast in Excel, start using the keyboard.

BUT… Don’t dump the Mouse.

In this article, I will show you some indispensable mouse double click tricks.

Hopefully, you would agree that in some cases, using the mouse can add to your productivity.

Note: Unless until mentioned, a button click would refer to the left button of the mouse.

Collapse the Ribbon by Clicking on Tab Names

If you double-click on any of the tabs in the ribbon, it will collapse the ribbon menu and you will get more worksheet space visible on your screen. It works as a toggle, so when you double click again, the ribbon menu appears again.

Mouse Double Click Tricks - Collapse Ribbon

Autofit Column Width at One Go

This one is mighty useful if you have to autofit multiple columns at one go. Select the columns that you want to autofit and double-click on the column heading separator (when you hover over the separator, your cursor would change to an icon with two arrows)

Mouse Double Click Tricks - Column Width Autofit

NOTE: If you want to autofit all the columns, simply left-click on the triangle icon in the top left to select the entire worksheet, and then double-click on any column header separator.

Copy the Format Using Format Painter

You can copy the formatting style and apply it to a different set of cells using this trick. To copy format, select the cells (from which you want to copy the format) and double click on Format Painter Icon (in Home –> Clipboard)

You would notice that the cursor now changes to plus icon along with the format painter icon. Now simply select the cells where you want to copy the format, and poof, it’s done.

Mouse Double Click Tricks - Format Painter Double Click

Note: If you only want to copy the format once, click once on the format painter icon. When you double click, the format painter remains active and you can use it again and again. 

Close the Excel Workbook by Double Clicking on the Excel Icon

If you double click on the Excel Icon at the top left of the workbook, it displays the dialogue box where you can close Excel workbook with or without saving it.

Mouse Double Click Tricks - Close Excel

Quickly Select Text in a Cell in Excel

If you get into the edit mode in a cell in Excel (by double clicking on the cell or using F2), and you double click on a word, it gets selected. Now to select more text, simply drag the mouse while the left button is pressed.

Mouse Double Click Tricks - Select Text with Double Click

Note: Usually in office applications, if you double click on a word, the entire word gets selected, and when you triple click, the entire sentence gets selected. Triple click doesn’t work in Excel, so you need to drag after the double click.

Autofill Series with a Double Click

Autofill is a powerful feature that enables the user to quickly fill a series (vertically). For example, if you have data in a column, and you have to apply a formula in the adjacent column, instead of filling each cell, simply fill one cell, select it, and double-click on the bottom right of the selection to autofill.

Mouse Double Click Tricks - Autofill

You can also use this for numbers/months/quarters. Remember, for this to work, you need to have data in the adjacent column.

Rename Worksheet Names

How do you rename a worksheet? You double click on the tab name and type the new name. If you have been doing it some other way (which is highly unlikely), stop it and start using the mouse.Mouse Double Click Tricks - Rename Sheets

At one point in time, I had become obsessed with keyboard shortcuts and I was using the shortcut Alt + O + H + R for renaming a worksheet. But eventually, I realized using the mouse is easier and faster.

Go to the Last Row/Column with Data

This isn’t as much a trick as it is a good-to-know phenomenon. When you double click on the edge of a cell selection (vertical or horizontal), it will jump to the last cell which has the data.

Mouse Double Click Tricks - Go to Last cell

This is not the most efficient way, and I prefer using the keyboard (control + arrow keys).

The reason I have featured it in this article is that it drives many people crazy. So now, the next time it happens, you would know why your cursor jumped to a cell miles away.

I am a Keyboard Shortcuts fanatic, and I have memorized hundreds of Excel Keyboard shortcuts.

However, I still believe there are situations where usage of the mouse (or a combination of mouse + Keyboard) should be used for maximum efficiency.

What about you – Are you a Mouse person or a Keyboard person?

What’s your favorite mouse trick?

Do share with me in the comments section.

You May Also like the following Excel Tutorials:

  • GraH says:

    No kidding, you memorized +100 short cuts? I’m too lazy for that. I’ve got excellent mouse skills.
    One comment on short cuts: some are language sensitive. So if you don’t have an English Office version, you might be disappointed when trying to use them.
    Try CONTROL + ALT + V after the well known CONTROL + C. On the plus it is an easy one to remember too.

  • Muhammad Fathy says:

    very amazing tricks…

  • Jan Martens says:

    Hi Sumit, Autofit column width in one go ! I think i “ll never forget. I mistakenly? tried a shortcut CTRL+Shift+1( on the numeric pad) and I think it takes me to the last cell in a used range. Wanted to ask you what it is exactly? I have a french keyboard ( azerty). Thanks

    • Sumit Bansal says:

      Thanks for commenting Jan.. Control + Shift + 1 takes you to the last cell (at the bottom right) that has a value

  • Alex Sam says:

    last option is super, thanks Sumit

  • yogirajoo says:

    Quite useful tips !

  • Larry Anderson says:

    Need to move top or bottom of spreadsheet – CTRL + HOME to upper most left and CTRL + END to bottom right

  • Claude Van Horn says:

    My favorite mouse trick is to convert formulas to text by selecting the formulas, right-click the border, drag one col right or left, release and click “paste as values”. For me, it’s faster than the keyboard.

  • duncanwil says:

    Imagine you have a list of values based on formulas that you want to convert to values.

    Select the list and keep it selected
    Put the cursor over the edge of that range, say over the right or left border
    Right click and keep the right key pressed
    Drag your list up or down or left or right and then drop it back where you had it originally
    A menu opens and choose paste as value

    You have now converted formulas to values and this action takes a second to do but a minute to describe.

  • MF says:

    I guess one of the less used mouse tips would be using mouse to move cells with Shift Key.
    With this combination, we can move and insert cells into a table easily.

    Here’s my post for sharing:
    http://wmfexcel.com/2015/02/18/3024/

    • Sumit Bansal says:

      Thanks for sharing.. I will be covering more Mouse Tricks in my next article.. In this one, I have focussed on double click tricks

  • Gopalakrishna Rao. says:

    Thanks very useful tips/tricks. How about VBA Macros from Scratch.? Please publish like these short cut useful tips in Macros. Doing a great job indeed.

  • Mike says:

    I was not aware of #1, #4 or #8. Thanks!

  • >