They will also show how the layout will appear across separate pages. Once you’ve set one or multiple print areas, it’s a good idea to review what the output will look like before printing it on paper.Įxcel provides three tools that help reduce the possibility of formatting or layout issues. Each print area will appear on a separate page. Once you’ve selected the areas, follow the same steps in this section to print your selection. Instead, you select multiple ranges with the steps shown in the previous section. There is no special command to select multiple print areas. That means you don’t have to worry about losing the setup when reopening your document. This print area will usually remain in place even if you save and close the entire workbook. The printed output will include only the print area on its own page. ![]() Once you have selected the desired group or groups of cells, you now use the Excel tools.Įxpand the Print Area drop-down box in the Page Setup areaĪ designated print area will now appear on the worksheet, marked by dashed lines. Note that each group will print on its own page once you’ve set up the print area. Repeat for as many groups of cells as you want to include. Hold down the Ctrl key and select the next range. ![]() Start by selecting one range as in the earlier instructions. If you want to select several groups of cells for printing, follow these steps: However, there may be more than one grouping in the worksheet that you want to include in your printout. The selected cells are now highlighted.Ī single group of cells is often all that you want to print. Hold down the left mouse button and drag the cursor to the last cell in the range. How to Select Cells To Include In The Print Areaīefore setting a print area, you need to select the cells you want to include.Ĭlick on the first cell in the range you want to select. This tab is in the top ribbon to the right of the Home tab. When working with print areas, you will be using the Page Layout tab. If you’re not a regular Excel user, it’s easy to forget where the most useful features are hiding! The video below shows a worksheet with raw data on the left and analysis on the right.Ī print area can split the printout onto separate pages. It can greatly reduce paper waste.Īnother scenario is when you want two distinct sections in a single worksheet to print on separate pages. This is when a print area is the solution. The entire sheet may print on multiple pages, but you may only want a small section of the data. ![]() Suppose you have a large Excel sheet with data across many rows and columns. By setting a print area, only the data you want to print will appear on the final printed sheet. If you only need a portion of the data in your worksheet, aka a print area, unnecessary pages may be printed.Ī print area in Excel defines one or more ranges of cells that you select for printing. How to Select Cells To Include In The Print Areaīy default, Excel prints your entire worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |