Make sure to print the document before you close and reopen it. When you close the Excel file, the print areas will be automatically removed. Make sure to check out our section on printing tutorials for Excel so you can see other tips for making your printed spreadsheets look nice. Note: you can also print the active sheets (first select the sheets by holding down CTRL and clicking the sheet tabs) or print the entire workbook.
![excel 2010 print selection excel 2010 print selection](https://media.gcflearnfree.org/weborbassets/uploads/ID_85/print_backstage.png)
To print the selection, click the big Print button. Next, under Settings, select Print Selection. Paste into Word, this takes a few moments Select the rows to be repeated at top in the table, then indicate. First, select the range of cells you want to print. Setting the print area for a worksheet is one of the most useful tips for printing in Excel, especially when working on large spreadsheets, but it is not the only tip for printing in Excel. Select and copy columns from Excel spreadsheet. Go to Page Layout tab > Print Area > Clear Print Area: Remove a Set Print Area so the Entire Worksheet will Print Again But, how it looks will depend on your data setup and the other print options that you choose. Here, Excel put both sections on different pages and, given that our printed data set is quite small, it doesn't look so great. Go into Print Preview and you can see how they will print (File > Print in excel 2010 and later - File Print Preview in Excel 2003 - Office Button > Print > Print Preview in Excel 2007):.Those specific sections are now ready to be printed:.Now, if you want to select more areas to print, simply repeat steps one and two as much as needed, except that instead of clicking Set Print Area, you will now click Add to Print Area:.Once you do this, you will see a dotted outline around the area that you just set to be printed:.Go to the Page Layout tab and click the Print Area button and then click Set Print Area (for Excel 2003, go to the File menu and then Print Area and then click Set Print Area):.Note: If the Print Titles button is locked (greyed out), it may. (If you are printing multiple sections on your worksheet, you can select these sections by hitting Ctrl and selecting them now or wait for step 4): Select File > Print > Show Print Preview to see what the printed spreadsheet will look like. Select the part of your data that you want to print.
![excel 2010 print selection excel 2010 print selection](https://www.exceltip.com/wp-content/uploads/2013/07/img1228.jpg)
Steps to Print Specific Parts of a Worksheet in Excel You can select a single part of a worksheet or multiple parts of a worksheet to print. This allows you to select sections of important data to print without having to move those sections of data to other spreadsheets in order to print them. In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet.