Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
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!! |
#3
|
|||
|
|||
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!! |
#4
|
|||
|
|||
Vasant Nanavati wrote:
Select the area you want to print, then use the menu: File | Print Area | Set Print Area SWEET! Thank u. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |