Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
e-mailing an excel sheet
How do I send a spreadsheet via e-mail without all the formulas and
formatting showing? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
e-mailing an excel sheet
What do you consider as a "spreadsheet"?
A workbook and its worksheets or just a single worksheet? Whatever the case, make a copy and clear formats and paste specialvalues. E-mail that copy. Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 12:29:02 -0700, 1bellavita2 wrote: How do I send a spreadsheet via e-mail without all the formulas and formatting showing? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
e-mailing an excel sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
e-mailing with excel | Excel Discussion (Misc queries) | |||
Can we print mailing labels from a Excel spread sheet? | Excel Discussion (Misc queries) | |||
E-Mailing a Proteced Sheet | Excel Discussion (Misc queries) | |||
mailing one sheet from workbook | Excel Discussion (Misc queries) | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) |