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. |
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 |
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 |
All times are GMT +1. The time now is 04:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com