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.)
1) 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). 2) Click Move or Copy… 3) 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.