How do I save a document so I won't print many pages of empty ce.

B

beth

After I finish a document, when I print it out, it keeps printing pages and
pages of empty cells. How do I keep it from doing this? Tell me how to cut
the empty cells offl.
 
R

RagDyer

You have to set your "print area" to exactly what you want to print.
Several ways to do this, one of which is to *select* your print area, then:
<File> <PrintArea> <SetPrintArea>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

After I finish a document, when I print it out, it keeps printing pages and
pages of empty cells. How do I keep it from doing this? Tell me how to cut
the empty cells offl.
 
G

Gord Dibben

Beth

Set your Print Area before printing.

File>Print Area. Clear the current one and set a new one.

Also, Excel estimates where your used range starts and stops.

Hit CRTL + END to see where Excel takes you.

If cells way below and right of what your actual used range is were once used
then cleared, Excel thinks they are still active.

Select all rows below your data. SHIFT + END + Downarrow. Edit>Delete.

Select columns to the right of your data. Same as above.

NOW.......Save the file, close and re-open.

Gord Dibben Excel MVP
 
L

Llobid

Beth...

I have found that the easiest way to set your print area is to navigat
to the bottom, right cell in the spreadsheet that you want to print an
click in that cell.

The hold down the Ctrl - Shift - Home key combination to highlight you
print area. Then go to File...Print Area...Set Print Area.

You may then have to go to Page Setup and set the file to print
certain number of pages wide by a certain number of pages tall (
usually delete that number and let Excel decide how many pages t
print.
 
Top