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.)
2) Click Move or Copy…
3) Change the To book drop-down to (new book), then tick the Create a copy box, OK.
ggy Duncan, Personal Productivity Expert