If you’ve needed to email a single worksheet out of a workbook, here’s a quicker way to do it instead of saving a copy and deleting what you don’t want to send. This tip works the same in every version of Excel I’ve used. (I’ve recorded a video demo below.)
RIGHT-click on the tab of the worksheet you want to email (if you want to send more than one worksheet, hold down the Ctrl key and click each one).
Click Move or Copy…
Change the To book drop-down to (new book), then tick the Create a copy box, OK.
The desired worksheet(s) will now be in a separate workbook. Save (or not) and send via email.
To finish work quicker, you have to learn which button to click! I schedule regular training and will also come to you in person and on the Web.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
About SUITE TUESDAY: How-to video series produced How-to video series produced by personal productivity expert, Peggy Duncan. Real quick video tutorials of tech tips that will help you finish work quicker so you can go home. Explained in plain English with no fluff. Click to SUBSCRIBE to my YouTube channel. Free to share. #SuiteTuesday
About the Author: Peggy Duncan is an award-winning, international personal productivity expert, conference speaker, consultant, and coach. She uses her skills as a professional organizer, project manager, and computer trainer to help busy professionals spend less time working but get more done.
For the past two or three years, I’ve been creating videos of computer demos and to build excitement about events I’m involved in. When I needed somewhere to put them to gain the most exposure, YouTube was the logical solution. When I found out that YouTube is the number two search engine, I became even more focused on video, and I wanted to take my channel to another level.
UPDATE: YouTube commands change with no warning. I’ve ceased publication of the booklet mentioned below. But you’re in luck because I’ve recorded a lot of how-to videos and put them on my YouTube channel for free. Here is a link to the playlist (bear in mind that YouTube instructions change often. I do check these videos periodically and make changes via the annotations, but they will not be exact).
I started digging around YouTube and soon realized there’s a lot more to its capabilities than you see on the surface. I wanted to learn more and looked for a book. The only one I found was over 300 pages and had way more information in it than I needed. I ended up taking all my notes and tips and published How to Create, Build, and Manage a YouTube Channel Made Easy (no longer available). See the update above for another learning opportunity.
Click the image below to visit my channel, DigitalBreakthroughs, and learn from some of my videos. They’re separated into playlists to make it easier to go to what interests you. Let me know what you think by leaving a comment on YouTube.PEACE.