How to Email a Single Excel Worksheet in a Workbook (with video demo)

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. 

Video Demo

ggy Duncan, Personal Productivity Expert

Related Posts with Thumbnails

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <br> <cite> <code> <del datetime=""> <dd> <dl> <dt> <em> <i> <img alt="" align="" border="" class="" height="" hspace="" longdesc="" vspace="" src="" style="" width=""> <ins datetime="" cite=""> <li> <ol> <p> <q cite=""> <strike> <strong> <sub> <sup> <u> <ul>