| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to email one sheet only of a workbook
I have made a spreadsheet which has 5 sheets. How can I send only one sheet
by email. |
|
#2
|
|||
|
|||
|
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. -- Dave Peterson |
|
#3
|
|||
|
|||
|
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. -- Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
| Is it possible to email only one page of an Excel workbook? | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| format a 29 sheet workbook | Excel Discussion (Misc queries) | |||
Linear Mode
