Another question someone just asked me went something like this: "I have an Excel worksheet that has a table of colored boxes for people to fill in data. But there are over 20 unnecessary pages of boxes and lines that I can't get rid of, no matter what I do. I can set the Print Area, but can't I just delete all this stuff?"

If you want to get rid of everything, including formatting and formulas from a particular row or column all the way to the end of the worksheet, you can do it by deleting the entire rows and the entire columns, rather than just the cells themselves. You remove the rows and the columns separately.

To delete every row from a certain point to the very bottom:

1. Click the gray row header to the left of the first row you want to delete (the row number to the left of column A). The entire row will become highlighted.
2. Press F5 to display the Go To dialog box (or click in the Name Box -- above the Column A header and to the left of the Formula Bar).
   
3. Type 65536:65536, then press Shift + Enter. This will highlight all the rows.
4. Right-click any of the highlighted row headers, then select Delete from the popup menu.

To delete every column from a certain point to the right end:

1. Click the gray column header above the first column you want to delete (the column letter above row 1). The entire column will become highlighted.
2. Press F5 to display the Go To dialog box (or click in the Name Box -- above the Column A header and to the left of the Formula Bar).
3. Type iv:iv, then press Shift + Enter. This will highlight all the columns.
4. Right-click any of the highlighted column headers, then select Delete from the popup menu.