how to email one sheet only of a workbook

R

Raven

I have made a spreadsheet which has 5 sheets. How can I send only one sheet
by email.
 
D

Dave Peterson

right click on the worksheet tab that you want to send.
select "Move or Copy"
On the next dialog, check the "Create a copy" checkbox on the bottom.
Use the "to book" dropdown and choose "(new book)"

Send the copy.

If you had formulas that referred to other sheets in the original workbook, you
may want to convert to values before you send.
 
G

Gordon

Raven wrote:
|| I have made a spreadsheet which has 5 sheets. How can I send only
|| one sheet by email.

The EASIEST (though not the ONLY) way is to copy that sheet to a new
workbook and email that.
 
Top