View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu


If you have Adobe Exchange or Adobe Professional installed - it will
usually put an icon on the menu bar which says convert to PDF.
This will convert the whole sheet or report.
If you just want to have the rows and columns you select - then select
your columns and rows. Go to Print - then select "Print Selection" -
then select "Print to File." Then in the Printer selection box -
Select Acrobat Distiller - then click on "Properties" - Select "Send
Fonts" - it is located under one of the "tabs" when you click on
Properties, click OK.
When you are back to the main Print Screen - select PRINT - You will be
asked for a file name and location. The file will default to something
like the following XXXXX.prn.
After the file is printed change the ".prn" to ".ps" double-click on
the file icon and it should convert automatically to PDF.
You cannot do this with Acrobat reader.
You will also have to configure your machine so you can see the 3
letter extension, i.e XXXX.doc for a word document, XXXX.xls for a
excel document.

The other solution is to save the whole sheet as pdf - then open it and
delete the pages you do not want to send and then "crop out" what you do
not want to send on the single page.
Sometimes only procedure gives better results that the other, ie
convert directly from Excel or save as a file and then convert.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2297436