You don’t have to waste paper on an entire Microsoft Excel 2007 worksheet when you only need certain parts of it printed. Microsoft’s spreadsheet program allows you to set a specific print area, which you can save if you plan to print out the same spreadsheet cells on a regular basis. You can change the print area at any time or clear it if you need to print the whole worksheet. Earlier versions of Excel require sorting through menus and toolbars to find the right commands. Excel 2007’s Page Layout tab, which you’ll find above the ribbon in Excel 2007, provides a straightforward way to perform these functions.
- Skill level:
Other People Are Reading
Open the Excel 2007 worksheet in which you want to define a print area.
Click a cell and drag the cursor over the rest of the cells you want to print to select them.
Go to the Page Setup group located on the Page Layout tab, and click "Print Area." Click "Set Print Area" to define the selected cells as the area of the spreadsheet you want to print.
Tips and warnings
- To add cells to your saved print area, select the additional cells you want to print. Click "Print Area" in the Page Setup group, and then choose "Add to Print Area."
- If you need to clear the print area, click any cell within the print area. Go to the Page Setup group, and click "Clear Print Area."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for