In this article, we are going to show you some mouse shortcut tips and tricks that will enhance your Excel productivity.

For keyboard shortcuts please see: 10 Most Useful Shortcuts in Excel

Mouse tips and tricks for Excel window and structure

Close All

Click on the close (X) button while holding down the Shift key to close all Excel workbooks at once.

Excel Mouse Tips and Tricks 01

Don’t Save All

To bypass the Don’t Save button for when closing each file without saving, click this button while pressing the Shift key. All Excel workbooks will be closed without saving.

Expand or collapse the Ribbon

You can toggle between expanded and collapsed modes of the Ribbon by double-clicking the title of active tab. For example, when the Page Layout tab is active, double-click on “Page Layout”.

Summary Statistics in the Status Bar

You can add minimum, maximum, average, and count of the items from your selection into the summary section on the bottom of the screen. All you need to is right click on the status bar and click on the option you want to add.

Excel Mouse Tips and Tricks 04

Mouse tips and tricks for sheet navigation

See all sheets and navigate

To see the list of all worksheets, right click on the two arrows (◄►) near the sheet tabs.

Scroll to the first or last sheet

To go to the first or last worksheet in your workbook, click on the arrows near the sheets tab.

  • Hold Ctrl and left click on the left arrow (◄) to go to the first sheet
  • Hold Ctrl and left click on the right arrow (►) to go to the last sheet

Copy a sheet

You can create a copy of a worksheet by clicking and dragging it, while holding down the Ctrl button.

Mouse tips and tricks for worksheet

Quick Navigation to cells at edges

If you double click an active cell's border, the last nonempty cell in the direction of the clicked border will be selected. This mouse shortcut works like in the End + Arrow key combination - just double click when you see the 4-direction arrow on the border.

Excel Mouse Tips and Tricks 08

Open the Clipboard

Clipboard saves all copied items, as your computer's memory capacity allows. Double click the Copy icon the Ribbon to copy data into the clipboard.

If the shortcut doesn’t work, you need to enable it manually. Follow these steps:

  1. Click the small arrow in the in the Clipboard section of the Home tab
  2. Click Options in the Clipboard pane
  3. Enable Show Office Clipboard When Ctrl+C Pressed Twice

Note that you can open the clipboard by pressing Ctrl+C twice as well.

You can learn more about the clipboard here How to use Clipboard in Excel article.

Quick cut and paste

You can move a group of cells to another location by dragging and dropping them while holding down the Shift key.

Excel Mouse Tips and Tricks 11

Lock Drawing Mode

You can lock the drawing mode and draw a shape as much as you'd like. All you need to do is to right click on the shape you want to draw multiple times, and select the Lock drawing Mode option.

Snap to Grid

Snap to Grid feature eases aligning shapes to our worksheets significantly. If you switch between on and off modes frequently, try to move or resize your shapes while holding Alt button. Snap to Grid becomes active when you are holding down Alt key.

Excel Mouse Tips and Tricks 13