View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default How to Print Exactly the Spreadsheet?

Hi,

Check for the following:

1. Check the Print area.
2. Cancel the Print area and set the print area.
3. Check whether Custom View is used for printing. If Custom View is used
follow the procedure as illustrated below:

Print using Custom View.

Do the following:

1. Select a range of cells.
2. On the View menu, click Custom Views.
3. In the Views box, click the name of the view
(view: A set of display and print settings that you can name and apply
to a
workbook. You can create more than one view of the same workbook without
saving separate copies of the workbook.) you want to print.
4. Click Show.
The range of cells will be shown as selected
5. Click Print.
6. Under Print What, click Selection
7. Click OK.

Note: You craete as many Custom View as possible, and print only those
views. Most important thing is you must select the range and during print you
must select Selection option. You can chage the Page sige before printing.

4. On the File menu, click Print Preview.
5. Click the Margins button and adjust the handles, and then click the Close
button to return to the Excel sheet. Now click the Print command under the
File menu.


Challa Prabhu


"PHPBABY3" wrote:

Hello,

Someone sent me a spreadsheet and when I print it it leaves big white
space on some sides, and runs off the page on other sides. Of course,
it should use up the blank space and not disappear off the edge. I
set the margis to zero but it doesn't seem to understand what zero
means.

How do I make it just print the spreadsheet? It would fit if it
wouldn't mess the margins up.

C-B