Email single worksheets

  • Thread starter Thread starter Higesan
  • Start date Start date
H

Higesan

How do you email a single worksheet out of a workbook with multiple sheets. I
have not been able to figure this out. I am looking for an easy way rather
than attempting to cut and paste
 
This is the way that I do it:-

1. Create a copy of the Workbook (maybe give it a different name).

2. Go into the copy that you have created and delete all the sheets except
the one that you want to send.

3. Save the file and then send it with just the single worksheet that you
wish to send.

If my comments have helped please hit Yes.
 
To avoid having to delete the extra sheets, another method is:
1. Right click on the tab of the sheet you want to send
2. Select "Move or Copy"
3. Under "To Book" select "(new book)"
4. Put a check mark in "Create a copy"
5. Click OK

Now that one sheet will automatically open in a new workbook. Just save it
and send it.
 
Back
Top