To quickly create a copy of any sheet, hold Ctrl then left click and drag the sheet to its new location. You need to right click on the sheet ➜ select Move or Copy ➜ select which workbook to make the copy in ➜ select the new location ➜ check the Create a copy box ➜ and press OK.īut with this shortcut, you’ll be copying sheets in record setting time instead. Quickly Copy A SheetĬreating a copy of a sheet normally takes quite a few steps. You can move the view of the sheet tabs either left or right without selecting a new sheet. Hold Ctrl and left click on the left or right arrow to scroll the tab view to the first or last sheet. If this is the case, Excel may display three dots on either side of the sheet tabs to indicate there are more sheets. If you have a lot of sheets in your workbook then Excel may not be able to display them all on screen. This will open the Activate sheet menu. You can then select the sheet you want and when you press the OK button, you will be taken to that sheet. To use this menu, right click on either of the small arrows to the left of the workbook sheet tabs. 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
![custom mouse pointer clicks lower than desired custom mouse pointer clicks lower than desired](https://i.ebayimg.com/images/g/qvIAAOSwgzVf0VRG/s-l400.jpg)
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.
![custom mouse pointer clicks lower than desired custom mouse pointer clicks lower than desired](https://cdn.browserhow.com/wp-content/uploads/sites/3/More-cursor-and-upload-cursor-option-in-Custom-Cursor-for-Chrome.jpg)
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.
![custom mouse pointer clicks lower than desired custom mouse pointer clicks lower than desired](https://custom-cursor.com/img/img-1_1.png)
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.
![custom mouse pointer clicks lower than desired custom mouse pointer clicks lower than desired](https://allthings.how/wp-content/uploads/2021/07/allthings.how-how-to-change-mouse-pointer-color-and-size-in-windows-11-image-5.png)
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