Shortcat jane how to#
Shortcat jane plus#
Shortcat jane free#

Unfortunately, unhiding multiple sheets is not directly possible in Excel.

Select the sheets using the methods mentioned above.

The tab that you right-click will become the active sheet. You can also right-click any of the selected tabs and choose Ungroup Sheets. To deselect multiple sheets you can just click on any tab that is not in the current selection. Any edits you make to the active sheet will also be made on all of the other selected sheets. To select all sheets in the workbook, right-click any tab and choose Select All Sheets. Sometimes you won't be able to undo the changes, and then have to pray that you saved the file. If you make a lot of edits to a sheet without realizing multiple sheets are selected it can spell disaster. I wish the application would turn a different color, or do a better job of warning us. When you have multiple sheets selected, the word “Group” appears after the file name in the header of the Excel application window. I've done this more times than I'd like to admit. However, if you forget to ungroup the sheets (see tip #6) then you could really mess up your workbook. This is a great time saver if you want to modify the value, formula, or formatting of specific cells on multiple sheets at the same time. When multiple sheets are selected, any changes you make the active sheet will also be applied to ALL selected sheets. IMPORTANT NOTE About Selecting Multiple Sheets You can continue to press this shortcut to select multiple sheets. This will select the previous/next sheet. The keyboard shortcuts to select multiple sheets are Ctrl+ Shift+ Page Up / Page Down. You can also hold the Shift key and left-click a sheet to select all sheets from the active sheet to the sheet you clicked. Hold the Ctrl key and left-click sheet tabs to add them to the group of select sheets. We can use the Ctrl and Shift keys to select multiple sheets. Checkout my post on Best Keyboards for Excel Keyboard Shortcuts to learn more. Especially when you are using a laptop keyboard.

Having the right keyboard can be important for us Excel users. You can then copy/paste or audit the sheets without having to navigate all over the workbook. These are great if you are toggling back and forth between two sheets. The keyboard shortcut to select the previous sheet is: Ctrl+ Page Up

The keyboard shortcut to select the next sheet is: Ctrl+ Page Down If you're a keyboard shortcut lover, like me, here are a few shortcuts to quickly move between sheets. This is much faster than scrolling, then selecting the first/last sheet with the mouse.

Shortcat jane how to#

If you want to speed up this process, checkout my post on how to Create Keyboard Shortcuts to Select the First or Last Sheet in Excel. Once you have scrolled to the front/back, you can then click the first/last sheet to select it. So yes, this action now requires two hands unless you have really really long fingers or use a left-handed mouse. You can see this tip by hovering your mouse over the buttons. You now have to hold the Ctrl key when clicking the sheet navigation buttons to scroll to the first or last sheet. These actions were consolidated into the sheet navigation buttons in the bottom left corner of the application window. Starting in Excel 2013 we lost the dedicated buttons to navigate to the first or last sheet. There were dedicated buttons to scroll to the first or last sheet in the workbook. If your workbook has a lot of tabs then you might want to quickly navigate to the first or last sheet in the workbook. 🙂 #2 Navigating to the First or Last Sheet

Shortcat jane free#

If you are in need of a high-five or pat on the back (and who isn't), then feel free to share this one with your boss and co-workers. You can also use this technique when multiple sheets are selected. It's much faster than right-clicking the tab and going to the Move or Copy… menu. I broke it out into 4 steps, but it really feels like 2 steps once you get the hang of it. Drag the sheet to the right until the down arrow appears to the right of the sheet.

Shortcat jane plus#

A plus symbol will appear in the sheet mouse icon.

Left-click and hold on the sheet you want to copy.

The quickest way to make a duplicate copy of a sheet is using the Ctrl+Drag method.

This is one of my favorite shortcuts that every Excel user should know. So in this post I share a few quick tips and shortcuts to save time with navigating your workbook. If you work with Excel files that contain a lot of sheets, then you know how time consuming it can be to work with the tabs.

Skill level: Beginner Tips for Navigating Worksheet Tabs Bottom line: Learn time saving tips and shortcuts for selecting and copying worksheet tabs.