Excel will typically only print cells that contain data. One additional reason that you might want to use print areas in Microsoft Excel is if you need to print some blank cells in your spreadsheet. I typically use one of these options if there are a couple of rows or columns that are printing on their own pages, as that can make the data difficult to read. There you will see the following options:
You can find this by going to File > Print then clicking the No Scaling button. If you have chosen a print area and find that you are still using more pages than you would like, then you might want to change the fit setting for the spreadsheet. If you are setting a print area in an Excel spreadsheet then it is likely because you are trying to reduce the number of pages that you use when you print the document. This is going to clear the existing print area. If you wish to remove the print area, then simply return to the menu in Step 4, but select the Clear Print Area option from the drop down menu instead. This should now be showing only the print area that you just set. Once you have defined the print area for your spreadsheet you can then click the File tab, then click Print to get to your Print Preview. If you are having difficulty visualizing the print area that you just selected, then it can help to check the print preview to see how everything will look.
#Excel 2013 print selection how to#
More Information on How to Set Print Area – Excel 2013 Our tutorial continues below with additional discussion on working with the print area in Excel 2013. Step 2: Highlight the cells that you want to set as the print area.Įxcel 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. 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. If you save the Excel file after setting a print area, then that setting will remain. This means that only the selected portion of the spreadsheet will print. The steps below will show you how to select an area in your spreadsheet, then set it as the print area. Microsoft Excel 2013 – Set Print Area (Guide with Pictures) Our guide continues below with additional information on setting a print area in Excel, including pictures of these steps. You can remove the reference to take your changes back.4 Additional Reading How to Create a Print Area in Microsoft Excel 2013 From now on, every printed page will start with header row. If you want to repeat a column or columns, use the Columns to repeat at left option.Ĭlick OK to save your settings. In the example below, we set Rows to repeat at top to 2 nd row to repeat. For example, to print the header row on each page, click the button and select the header row reference. Regardless of how you get to this step, you will need to be on the Sheet tab in the Page Setup dialog.Ĭlick the reference selector icon corresponding to the heading type you want to be repeated. You will see two reference inputs under the Print titles section. Once the dialog is open, go to the Sheet tab. You can find the link at the end of the Settings section. On the Print window, click the Page Setup link to open the Page Setup dialog.
You need to activate this feature from the Page Setup options. In this article, we are going to show you how to print header row in Excel to repeat on every printed page in Excel 2016, Excel 2013, Excel 2010 and Excel 2007.īy default, Excel does not print the headings of tables. If your worksheet contains multiple pages, you will see header rows or columns only printed in the first page by default.
0 kommentar(er)
