How To Move A Chart To Another Worksheet In Excel 2016
Bottom line: Learn fourth dimension saving tips and shortcuts for selecting and copying worksheet tabs. Includes a few uncomplicated VBA macros.
Skill level: Beginner
Tips for Navigating Worksheet Tabs
If yous work with Excel files that contain a lot of sheets, then you know how time consuming information technology can be to work with the tabs. And so in this post I share a few quick tips and shortcuts to relieve fourth dimension with navigating your workbook.
#ane Copy Worksheets with Ctrl+Drag
This is 1 of my favorite shortcuts that every Excel user should know. The quickest style to make a duplicate copy of a sheet is using the Ctrl+Elevate method. Here are the steps.
- Left-click and hold on the sail you want to copy.
- Press and hold the Ctrl key. A plus symbol volition announced in the sheet mouse icon.
- Drag the sheet to the right until the downward arrow appears to the right of the canvas.
- Release the left mouse button. Then release the Ctrl key.
I broke information technology out into 4 steps, simply it really feels like ii steps once you lot become the hang of information technology. Information technology's much faster than right-clicking the tab and going to the Move or Copy… card.
You can also employ this technique when multiple sheets are selected. More on that beneath.
If you lot are in need of a high-five or pat on the back (and who isn't), and so feel complimentary to share this ane with your boss and co-workers. 🙂
#2 Navigating to the First or Terminal Canvass
If your workbook has a lot of tabs and so you might want to quickly navigate to the kickoff or concluding sheet in the workbook.
In Excel 2010 and earlier this was piece of cake. There were dedicated buttons to scroll to the showtime or last sheet in the workbook.
Starting in Excel 2013 we lost the dedicated buttons to navigate to the first or final sheet. These deportment were consolidated into the sheet navigation buttons in the bottom left corner of the awarding window.
You now have to hold the Ctrl key when clicking the canvas navigation buttons to scroll to the first or terminal sheet. You can encounter this tip past hovering your mouse over the buttons.
And then aye, this action now requires 2 hands unless you take really really long fingers or utilise a left-handed mouse. Something to brag about lefties… 😉
One time yous have scrolled to the front/back, yous can and then click the offset/concluding sheet to select it.
If you want to speed upwards this process, checkout my postal service on how to Create Keyboard Shortcuts to Select the First or Last Sail in Excel. This is much faster than scrolling, then selecting the first/last sheet with the mouse.
#3 Select Next or Previous Canvas
If you're a keyboard shortcut lover, similar me, here are a few shortcuts to quickly movement betwixt sheets.
The keyboard shortcut to select the adjacent sheet is: Ctrl+Page Down
The keyboard shortcut to select the previous canvas is: Ctrl+Page Upward
These are great if you are toggling back and forth between 2 sheets. Just motion the sheets side by side to each other. Y'all can then copy/paste or audit the sheets without having to navigate all over the workbook.
Having the correct keyboard tin can be of import for us Excel users. Particularly when you are using a laptop keyboard. Checkout my mail on Best Keyboards for Excel Keyboard Shortcuts to acquire more.
#four Select Multiple Sheets
We tin can use the Ctrl and Shift keys to select multiple sheets.
Concord theCtrl key and left-click sheet tabs to add together them to the group of select sheets.
You tin also hold the Shift key and left-click a sheet to select all sheets from the active canvass to the sheet you clicked.
The keyboard shortcuts to select multiple sheets are Ctrl+Shift+Page Up / Page Downward. This will select the previous/next sheet. You can go on to press this shortcut to select multiple sheets.
IMPORTANT Note About Selecting Multiple Sheets
When multiple sheets are selected, whatever changes yous make the agile sheet volition also be applied to ALL selected sheets. This is a not bad time saver if you want to modify the value, formula, or formatting of specific cells on multiple sheets at the same fourth dimension.
However, if you forget to ungroup the sheets (see tip #6) and so y'all could really mess up your workbook. I've done this more times than I'd like to admit.
When you accept multiple sheets selected, the word "Group" appears later on the file name in the header of the Excel application window. This is not much of a warning though. I wish the awarding would turn a different color, or practice a amend chore of warning us.
If y'all brand a lot of edits to a sail without realizing multiple sheets are selected information technology can spell disaster. Sometimes you won't exist able to undo the changes, then take to pray that you saved the file.
#5 Select All Sheets
To select all sheets in the workbook, right-click any tab and choose Select All Sheets.
The same rule applies here. Whatever edits y'all make to the active sheet volition besides be made on all of the other selected sheets.
#6 Deselect (Ungroup) Sheets
To deselect multiple sheets you lot tin can but click on any tab that is not in the electric current selection.
You can besides correct-click whatsoever of the selected tabs and choose Ungroup Sheets. The tab that you right-click will become the active canvass.
#7 Hide & Unhide Multiple Sheets
To hide multiple sheets:
- Select the sheets using the methods mentioned above.
- Right-click one of the selected tabs.
- Choose Hibernate.
The sheets volition be hidden.
Unfortunately, unhiding multiple sheets is not directly possible in Excel. When you right-click a tab and choose Unhide, you can only select one sheet from the list of hidden sheets in the Unhide window.
I accept a post on 3 Ways to Unhide Multiple Sheets in Excel that explains techniques for unhiding sheets with a macro.
Bonus Tip: Sheet List
If your workbook contains a lot of sheets and so yous tin right-click the tab navigation buttons to see a list of all visible sheets. You can so double-click a sheet in the list to bound to it.
This list only shows the visible sheets in the workbook, and at that place is no fashion to search it.
And so, I adult The Tab Hound Add-in to solve both of these problems and a lot more.
The add-in is packed with features (including unhiding multiple sheets) that make it faster & easier to navigate and alter the sheets in your workbooks.
I developed Tab Hound with VBA and the tools that are congenital into Excel. If you'd like to learn more about macros & VBA so checkout my costless training webinar that is going on correct now.
Click here to larn more and register for the webinar
Conclusion
I hope those tips help save some time out of your mean solar day. What are your favorite shortcuts for working with sheet tabs? Please leave a comment below with your suggestions, or any questions.
Thank yous! 🙂
Source: https://www.excelcampus.com/tips/shortcuts-worksheet-tabs/
Posted by: williamssaver1959.blogspot.com
0 Response to "How To Move A Chart To Another Worksheet In Excel 2016"
Post a Comment