Navigation between sheets can be made easier using the Activate sheet pop up menu. When you’re done, you can right click any of the grouped sheets and select Ungroup Sheets. This will allow you to group sheets that aren’t necessarily in sequence as well. To group sheet, hold Ctrl and left click on any sheets you want to group. It allows you to do the same edits on all the grouped sheets at the same time, which can save massive amounts of time if you need to edit the exact same thing on dozens of sheets. Grouping sheets together can be a really powerful tool. Mouse Shortcuts For Working With Sheets Group Sheets Together You can enable this or choose which statistics show up with a right click on the status bar and checking or unchecking the various options available in the following menu. You can see at-a-glance summary statistics in the status bar for any range of values you select in Excel. Enable Summary Statistics In The Status Bar But there is a slightly quicker shortcut for docking menus.ĭouble left click at the top of the menu when the cursor is a four-way arrow and the window will dock back to its last docked location (left or right side). You can then click and drag them back to the side to dock them again. You can also turn any of these into a floating window with a left click and drag action on the top title area. The PivotTable Fields menu, Format Chart Area menu and Format Shape menu all dock to the side of the workbook, just to name a few of them. There are a lot of Excel menus that dock to the side of a workbook. This will choose Don’t Save for all the open workbooks. There’s a shortcut to save all this clicking. Hold the Shift key and left click on the Don’t Save button. There is no Don’t Save All option in the subsequent menu! This means if you want to discard all the changes when closing all workbooks, you need to click Don’t Save multiple times.

Don’t Save All OptionĬlosing multiple workbooks is now easy with the above tip, but when these workbooks contain unsaved changes there is a new challenge. This will close all open workbooks at once. Hold the Shift key while you left click on the X.

Save all those clicks with this easy trick. If you’ve got a ton of Excel workbooks open and you want to close them all, then it can be a pain go through and close each workbook individually. Mouse Shortcuts For The Window Close Multiple Workbooks At Once In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks. There are also some great time saving mouse shortcuts as well.įor the ultimate in Excel efficiency, you should combine both keyboard and mouse. While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are a lot of great keyboard shortcuts in Excel that will save you time and are worth knowing.

How to add shapes in excel 2018