trimming blank cells
 

I've gone through life w/o needing to master excel; now I used it, and
I am soooooo clueless about it! How do I trim the blank cells off my
document? It prints at 60 pages, but there's only about 10 of data!
All these blank cells print out. Help!!

Select the area you want to print, then use the menu:

File | Print Area | Set Print Area

--

Vasant


"St. Matthew" wrote in message
oups.com...
I've gone through life w/o needing to master excel; now I used it, and
I am soooooo clueless about it! How do I trim the blank cells off my
document? It prints at 60 pages, but there's only about 10 of data!
All these blank cells print out. Help!!

Hi

You or formatted (cell format, or borders, or fill/font colors, etc) a range
of worksheet, bigger than used range, or you have some entry in some cell a
lot of rows/columns away.

a) Select a row below your data, hold down Shift key, and select a row ~4000
rows further. Delete selected rows. Do same with columns right to your data.
Check with print preview the number of sheets printed.

b) This is for case, when there are preformatted cells on sheet, and you
want to keep them. Your data range must have header row. Select the range
with your data+preformatted cells+header row. Switch autofilter on (from
data menu). Before printing, set the autofilter for some key column to 'Not
empty'.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"St. Matthew" wrote in message
oups.com...
I've gone through life w/o needing to master excel; now I used it, and
I am soooooo clueless about it! How do I trim the blank cells off my
document? It prints at 60 pages, but there's only about 10 of data!
All these blank cells print out. Help!!

Vasant Nanavati wrote:
Select the area you want to print, then use the menu:

File | Print Area | Set Print Area

SWEET! Thank u. :)