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

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.

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

How to Delete Unnecessary Cells in Excel

1. Select the column immediately to the right of your data.
2. Hold down "Ctrl" + "Shift" and press the right arrow key to select all the columns to the right of your data.
3. Right-click on any of the selected column headers and choose "Delete" from the context menu.
4. In the "Delete" dialog box, select "Entire column" and click "OK".
5. Adjust your print area to only include the columns you need by selecting the columns you want to print, going to the "Page Layout" tab, clicking on "Print Area", and choosing "Set Print Area".

That's it! You should now have a much more manageable spreadsheet without all those unnecessary columns.

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

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

"terry" wrote:

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.