Email a Single Excel Worksheet Instead of the Workbook
Posted on April 16th, 2007 by Peggy Duncan
A question that came up in my Computer Magic! seminar at the Affordable Meetings conference in Chicago was about emailing a single Excel worksheet instead of the entire workbook.
Here is a method that will be faster than clicking File, Save As, renaming the workbook, and deleting what you don’t want to send.
- 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 and name the file, then send via email (click the File menu, Send To, Mail Recipient as Attachment).
To finish work quicker, you have to learn which button to click!
PEACE.
Peggy Duncan, Personal Productivity Expert
Filed under: Word-Excel-PowerPoint
