![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Mar 2002
Posts: 67
|
Hello
I am trying to convert excel data to adobe file. However, becasue there are too many columns and some of the columns are cut off on adobe document. What should I do to solve this problem? Also, is it possible to set a certain number of rows to put on one page of adobe document Thanks in advance |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Toronto
Posts: 173
|
Prepare your Excel sheet for printing and use Acrobat as a printer.
In other words, you've got to go into page setup in Excel and set your sheets up to print (on whatever sized paper you need) and then print (use File|Print from the menu, not the printer button); in the Printer Name pulldown, look for Acrobat, and print to it. Also, again, you'll want to set up your "print area" in Excel. An easy way is to go to View|Page Break View on the menu - you'll see your page now the print area in heavy outline. You can adjust the print area by moving the heavy outline with your mouse.
__________________
Regards, Duane h. Office2003 in WinXP o. Office2007 in Win7 |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
To Add
f you want Excel to be PDF file Acrobat version 5 does this on the fly, a click of a button, watch the width thou. YOUIR need FULL version DSP software not READER.......this is critical, then PDF files are made. May i ask why... PDF is not my 1st choise.. poss other way if distribution, Remember PDF is all but dead file, in thats its not Excel and limited functions to it.
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|