This post teaches you how to set/change print area in Excel, how to set multiple print areas in Excel, how to clear print area in Excel, etc. If you want to recover deleted or lost Excel spreadsheets, Word files, or any other files from Windows computer, USB flash drive, etc. you can use MiniTool Power Data Recovery.
Sometimes you may only want to print a part of the Excel sheet. Microsoft Excel has a Print Area feature that lets you easily select print area in Excel. In this tutorial, you will learn how to set print area in Excel, how to change print area, how to clear print area in Excel, etc.
How to Set Print Area in Excel
How to set one print area in Excel
- In the Excel file, you can select a range of cells that you want to print.
- Next click Page Layout tab, and click Print Area in the Page Setup Then select Set Print Area option.
- If you want to print the selected area immediately, you can click File tab and click Print to print the Excel spreadsheet. If you want to save the print areas and print them later, you can press Ctrl + S keyboard shortcut.
The selected print areas are saved when you save the Excel workbook. When you send the Excel worksheet to the printer next time, only the selected areas will be printed.
How to set multiple print areas in Excel
- To set multiple print areas in Excel, you can select the first print area, then press and hold Ctrl key and select other non-contiguous print areas one by one.
- Next, click Page Layout -> Print Area -> Set Print Area. In this way, multiple print areas are selected, and each print area will be printed on a separate page. If you select adjacent print areas, they will be regarded as a single print area.
How to select multiple cells in Excel
- You can click Page Layout tab and click the small square-arrow icon at the bottom-right corner of Page Setup section to open the Page Setup window.
- Click Sheet tab and click the box of Print area.
- Then you can select the cells in Excel spreadsheet. To select non-continuous cells, you can press and hold Ctrl key and select the cells. To select continuous cells, you can press and hold Shift key and select the first and end cell.
- If you want to add cells to an existing print area, you can select the cells and click Page Layout -> Print Area -> Add to Print Area. Adjacent cells can be printed on one page while non-adjacent cells will be regarded as an additional print area and printed on a separate page.
How to print multiple areas on one page
- You can click File -> Print or press Ctrl + P.
- Click Printer Properties link under the Printer.
- Then you can find the Pages per Sheet option in the Printer Properties dialog.
How to preview Excel print areas
After you select the print areas, you can click View tab, click Page Break Preview in the Workbook Views section.
To return to the spreadsheet, you can click Normal option in Workbook Views section.
How to ignore or clear print area in Excel
If you want to print the entire worksheet next time, you can ignore or clear the print area.
To clear the print area in Excel, you can click Page Layout -> Print Area -> Clear Print Area.
To ignore the print area, you can click File -> Print or press Ctrl + P, click the drop-down icon next to Print Active Sheets and select Ignore Print Area.
In conclusion, this post offers some instructions for how to set print area in Excel, hope it helps. If you want to recover a mistakenly deleted Excel file or lost Excel files, you can try MiniTool Power Data Recovery. This program helps you recover any deleted/lost files from PC, laptop, USB, memory card, external hard drive, SSD, etc.
