Excel spreadsheets can often be unruly documents that are best viewed on a computer monitor. But many situations call for a printed copy of a spreadsheet, which can be difficult if the spreadsheet is very large.
But if only certain parts of the spreadsheet need to be printed, then you can make things a little easier by creating a print area. This will allow you to set the parts of the worksheet to be printed, and it will leave everything else off of the printed copy.
Setting a Print Area in Excel 2013
The steps below will show you how to select an area in your spreadsheet, then set it as the print area. This means that only the selected portion of the spreadsheet will print. If you save the Excel file after setting a print area, then that setting will remain. If you find that only parts of a spreadsheet are printing, such as a spreadsheet that you have received from another person, then the print area is likely the reason for that behavior.
- Open your file in Excel 2013.
- Highlight the cells that you want to set as the print area. Excel will print blank cells if they are included in a print area, so this can be a helpful solution if you need to print out a blank grid and complete it manually, such as when doing a physical inventory.
- Click the Page Layout tab at the top of the window.
- Click the Print Area button in the Page Setup section of the ribbon, then click the Set Print Area option.
You can then click the File tab, then click Print to get to your Print Preview. This should now be showing only the print area that you just set.
If you wish to remove the print area, then simply return to the menu in Step 4, but select the Clear Print Area option instead.
Is your Excel spreadsheet difficult to read, even after setting a custom print area? Try printing with gridlines in Excel 2013 to see if that makes it easier to read a printed sheet.