How get rid large amount garbage cell in Microsoft Excel

**Iyyappan** · 21-02-2012

I highlighted many entire rows with color. Now my excel wants to print 115 pages. I can define a narrow print area, but I really want to delete the garbage color cells to the right. When I drag to the right, there seems to be an infinite number of cells.

**Alfons** · 21-02-2012

Don't drag. place your curser in the first row and column that you want to delete left. hold the shift key down with left hand and with right hand, hit end then the down arrrow. Hit the end key again then the left arrow. excel will select all cells from row 1 to bottom and from curser position in row 1 to far left. it will stop select if it hits data. once
selected, set your colors

**Gania** · 21-02-2012

You can try to delete the cell manually. There are number of options for the same. I am not aware of any automated process which can work for the same.