How to set a print area in Excel. Scenario on hand: We have a sheet with product names. What we want to accomplish: Explore how to set a print area in Excel by following these steps: Go to the Page ...

To clear the print area, go to the “Page Layout tab -> print area -> clear print area.” Also read: How to Move a Column in Microsoft Excel. How to Modify Cells in an Existing Print Area. You can ...

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.

Select the cells that you want to include in your printout. You can do this by clicking and dragging your cursor over the cells, or you can press “Ctrl + A” to select all cells in the sheet.

If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Sometimes the wrong print area has already been set, in which case you want to clear it.