How to Email Single Worksheet Out of Workbook in Excel





Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Jul 25, 2009

http://www.PeggyDuncan.com Peggy Duncan shows you how to email one worksheet out of a workbook instead of creating a copy of the full workbook and deleting what you don't need.

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... 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.

This tip works the same in all Excel I've tried.


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...