Do you dread printing Excel worksheets? Never manage to print them the way you want to? Set the print area in Excel, and never fret again.

Ensure that you have set the printer settings and paper size correctly before printing. Setting a print area is a more efficient way of printing an Excel worksheet than printing the entire workbook.

You can set the print area of an Excel spreadsheet using the Print Area button to print only a selected area of a spreadsheet.

To really save time, use Excel’s Name function to create a kind of catalog of areas that you repeatedly print. To do that, block the first area you want to print and highlight it.

Adjust the page setup to mark the cells you specify for printing. Excel's time-saving preview in the "Print" command displays the layout for the selected print areas.

To define the print area for your worksheet, highlight the columns and rows to include, select "Print Area" on the Page Layout tab, and then choose "Set Print Area" from the drop-down menu.

Spread the lovePrinting an Excel spreadsheet on one single page is a common task for many users. It is important to make sure that the entire spreadsheet is visible and readable. This guide will show ...