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 Excel 2010. (I’ve recorded a video demo below.)
- RIGHT-click on the tab of the worksheet you want to email (if you want to sen
d 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.
Video Demo
PEACE.
Peggy Duncan, Personal Productivity Expert
