Defining the Print Area in Excel

Left to its own devices, Excel will print all the data that is in the currently active worksheet. You can however, force Excel to use a defined print area for the worksheet. Start by selecting the cell range that you want to print. Then, click the Print Area button under the Page Set up group on the Page Layout Ribbon and choose Set Print Area from the list.

To delete a print area, click the Print Area button and choose Clear Print Area.

To Define a Print Area in Excel

1. Click the Page Layout tab on the Ribbon.
2. Click the Print Area button and select Set Print Area from the list.
3. To remove a print area, click the Print Area button and select Clear Print Area from the list.

Tip: You can also add and remove a print area from the Sheet tab of the Page Setup dialog box.

Similar Posts:

• Inserting and Removing Page Breaks in Excel
• Inserting Headers and Footers in Excel 2007
• Grouping Worksheets in Excel
• Print a Word Table in Landscape
• Forcing a Worksheet to Fit in Excel
• Setting Margins in Word 2007
• Inserting a Hyperlink in Excel 2007

Tagged as: Excel 2007 Tips, Microsoft Office Tips