Top 8 Most Useful Excel Mouse Click Shortcuts

2016-12-04

Unlimited Format Painter

 

format-painter

 

When you click the format painter you will be able to use it once, but if you double click it then you will be able to use it an unlimited number of times until you click the button again to turn it off.

  1. Highlight the area you would like to copy the format of.
  2. Go to the Home tab and in the clipboard section double left click the Format Painter button.
  3. Now single left click anywhere you would like to copy the format.

 

Easily Rename A Sheet

 

rename-sheets

 

Place your mouse cursor over the sheet you want to rename and double left click. Now type the name you want to change it to. A quick and easy way to change the name!

 

Show Pivot Table Data

 

show-pivot-table-data

 

This trick will quickly let you see the data behind a pivot table. To see the data that makes up Q1 totals, select a cell in pivot table in the Q1 summary row and double left click. This will create a new sheet will all the data that makes up the Q1 totals. An easy way to dig into the data.

 

Toggle The Ribbon

 

toggle-ribbon

 

Need extra space to view your spreadsheet work area? Double left click any tab on the ribbon to toggle the ribbon on and off.

 

Navigate Your Data

auto-adjust-column-width

 

If you have a large set of data and need to quickly navigate to the end of it you can double left click on any edge of the active cell cursor.

  • Double left click the right edge to go all the way to the right of your data
  • Double left click the bottom edge to go all the way down your data
  • Double left click the left edge to go all the way to the left of your data
  • Double left click the top edge to go all the way to the top of your data

 

Close Your Workbook

 

close-workbook

 

To close your workbook, double left click the Excel icon in the upper left most corner. Ok, this one is actually a long-cut as a single left click on the X in the upper right most corner will also close the workbook, but hey you have options now.

 

Copy Down A Formula

 

copy-down-formula

 

To easily copy down a formula, place your cursor over the lower right most corner of the active cell. The mouse cursor should turn to a black plus sign, now double left click and the formulas will copy down to the end of your data.

 

Navigate Through Your Sheets

 

navigating-sheets

 

If you have a lot of sheets in your workbook the best way to navigate to a particular sheet is to right click the arrows in the lower left area of your workbook. This will bring up a window with a list of all the sheets in the workbook and allow you to select one to navigate to.

 

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Related Articles

37 Awesome Excel Mouse Tips & Tricks You Should Know

37 Awesome Excel Mouse Tips & Tricks You Should Know

While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.

read more
25 Amazing Power Query Tips and Tricks

25 Amazing Power Query Tips and Tricks

Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.

read more

Comments

0 Comments

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest