View Single Post
  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Peter,

That's not a stupid question at all. If the recipients need only to view
the sheet, one possibility is File - Send to - Mail recipient. There's an
option to include only the current sheet. The sheet will be put into the
email, as html.

If the recipient needs an actual Excel worksheet, you'll have to create a
workbook, since worksheets live only in workbooks. The recipient will need
Excel, or the Excel viewer to be able to work with the workbook. The
following will create an additional workbook, containing a copy of only the
current sheet. Right-click the sheet tab, Move or Copy, check "Create a
copy" and in the "to book" box, select "new book." You'll now be in a new
workbook containing only that sheet, which you can now save with an
appropriate name, and attach to an email later, or you can use File - Send
to - As attachment. In the latter case, the file name will be something
like "Book1.xls" unless you've first saved it with a better name. Your
original workbook will still be open -- you can get to it via Window, or
Ctrl-Tab.
--
Earl Kiosterud
www.smokeylake.com

"PeterM" wrote in message
...
Sorry for the stupid question, but I like to ask how to save only one item
of my spreadsheet. I need to send an email to a company, but the email
should just have certain spreadsheets. Better yet, several of my different
files need to be sent as well, but again only certain spreadsheets. Can I
combine the items then? I'm not doing all that well this morning, my
native tongue is not English, and when I'm sick, the English shuts down...
I hope you can make sense of this.