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.

How to set print area in Excel For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

How to set print area in Excel For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

Return to Excel, and print the sheet. Print Preview may show the color, but don’t worry, it should print in black and white. If your printer is far away, print to a PDF file and then open it.

You can embed a PDF file into a cell of an Excel worksheet and then use Excel's security features to lock the object. This allows you to take advantage of both technologies.