Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default e-mailing an excel sheet

How do I send a spreadsheet via e-mail without all the formulas and
formatting showing?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
e-mailing with excel Wood Grafing Excel Discussion (Misc queries) 0 November 30th 06 12:58 AM
Can we print mailing labels from a Excel spread sheet? Doreski Excel Discussion (Misc queries) 3 October 17th 06 10:27 PM
E-Mailing a Proteced Sheet Gabe Excel Discussion (Misc queries) 0 February 7th 06 07:28 PM
mailing one sheet from workbook nospaminlich Excel Discussion (Misc queries) 2 June 30th 05 12:36 AM
how do i convert MS Word mailing labels into an Excel mailing lis. unrhyll Excel Discussion (Misc queries) 1 February 4th 05 01:19 AM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"