how to email one sheet only of a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a spreadsheet which has 5 sheets. How can I send only one sheet
by email.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel shortcut options 0
Merge Multiple workbook sheets into one workbook 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Move or Copy Stopped Working? 0
Email workbook to multiple individuals with their specific data 3
Excel Excel spreadsheets opening at top instead of bottom. 4
Update workbook pages- how? 2
Start sheet in a workbook 2

Back
Top