How can I delete an infinite number of garbage cells to the right

  • Thread starter Thread starter terry
  • Start date Start date
T

terry

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.
 
hi
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.

regards
FSt1
 
Back
Top