On Wed, 8 Oct 2008 12:29:02 -0700, 1bellavita2
wrote in part:
How do I send a spreadsheet via e-mail without all the formulas and
formatting showing?
There are at least a few possibilities depending on what you mean.

1. You want to send a printout of the spread sheet.

In this case use a pseudo printer to make a file on your disk
that is in a format that can be read by the person you are sending
to. For example, use a PDF pseudo printer.

2. You don't want the user to see or edit the formulas or formatting
information, but be able to navigate within the spread sheet.

In this case use Tools Protection and lock the entire sheet. You
might then want to unlock some of the cells so that the recipient
can change some of the values.

Depending on the version of Excel you use there might be other
things that you can lock or unlock.

Microsoft's Excel Viewer
(http://www.microsoft.com/downloads/d...DisplayLang=en)
might be useful in this case

3. I'm not sure what you mean by not having the formatting showing.

If you mean that the actual format control information should not
be vi sable, then locking the spreadsheet should handle it.

If you mean that only the default formatting and column width's are
used, then I don't know of an easy way to set things back to the
defaults. You could start by selecting the entire sheet and use
the Format, but I'm sure that there will be complications.
command
think