![]() In this section, we show three additional print settings to achieve what you need. You will often want to customize your printouts for clarity and appearance. It’s easy to miss the tiny arrow! This picture will help you out:Įach of these tools also has keyboard shortcuts for access. In the “Page Setup” group, click the small arrow in the bottom-right corner. Follow these steps in your Excel worksheet: ![]() You can modify the print area before printing your document by using the Page Setup Dialog Box. Once you’re satisfied with the preview, click on the Print button to quickly print your document. Within Print Preview, you can modify the print settings, such as print orientation, scale, and paper size if needed. Review the document displayed in the preview pane. Select Print or press Ctrl+P on your keyboard. To access Print Preview, follow these steps: This tool allows you to view how the entire document will appear when printed. Print PreviewĪnother way to ensure your print area is set correctly and your data is displaying accurately is by using Print Preview. You can adjust margins, headers, and footers directly in the view. Observe the cells and formatting in the Page Layout View. Follow these steps:Ĭlick on the Page Layout button in the Workbook Views group. The Page Layout View provides one way of checking that your data will be displayed accurately on the printout. 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 |