![]() If you want Excel to ignore those selected areas and print the entire workbook, follow these steps:Ĭlick "File," then "Print" or use the "Ctrl + p" keyboard shortcut. Sometimes, you may want to print an entire worksheet or workbook, but you already selected print areas. Any page breaks you add or changed appears as solid lines. If you wish to break the pages into more segments to further divide your worksheet, do this:Ĭlick and drag the page break to the new location. The Excel programme breaks up pages you want to print automatically based on the page setting, and these appear as dashed lines. So, only use this option in extreme cases where you're not going to use the other print areas on the document. Note that this operation not only clears the print area you clicked on, but it removes every other print area on the worksheet. Go to the "Page Layout" tab, navigate to the "Page Setup" group, then click "Clear Print Area." If you don't require print areas on your workbook anymore, you can clear them by doing the following:Ĭlick any part of the worksheet that contains the print area. Related: How to List Microsoft Office Skills on a Resume (With Examples) How to clear a print area If you do this, Excel is going to create a new print area for the cells, which means they're going to print as a separate page. Note that you can't add cells that aren't adjacent to an existing print area. Go to the "Page Layout" tab, then navigate to the "Page Setup" group and click "Print Area", then click "Add Print Area." Select the cells you want to include in the existing print area of the worksheet. If you wish to enlarge the print area, you can add adjacent cells to it by taking these steps: How to add cells to an existing print area Once you've checked, click "Normal" or "Page Layout" to return to the way you were viewing the worksheet. To do that:Ĭlick "View" then click "Page Break Preview" under the "Workbook Views" group. How to view a print area in ExcelĪfter setting up a print area, check that you selected the right cells before printing. That way, you can print the same area of the sheet multiple times without selecting the cells again. Note that Excel automatically saves your changes when you save the workbook. When you hit print, each designated print area is going to be on a separate page. ![]() Navigate to the "Page Layout" tab and click on "Set Print Area" from the drop-down menu. Hold "Ctrl" as you select each cell group. If you want to set multiple print areas in the same worksheet, do this: Click the drop-down menu and select "Set Print Area." Navigate to the "Page Setup" bu on the menu ribbon and click the "Page Layout" tab. Select the part of the worksheet you want to print. Related: Excel Skills: Definition and Examples How to set the print area in Excelįollow these steps to learn how to set the print area in an Excel worksheet: ![]() When you hit the print button, the programme produces each designated section of the spreadsheet as a separate page, making them easier to handle and share with other people. Thankfully, you can designate several parts of a worksheet as print areas. If you frequently print a part or different parts of worksheets, it's vital to know how to specify the parts you want to print. It's important to know how to perform this operation, as spreadsheets can be extensive, which can make working with entire printouts cumbersome. That way, the application only prints the selected cells instead of the entire worksheet. It comprises one or multiple ranges of cells on the spreadsheet that you instruct the programme to print. What is a print area in Excel?Ī print area in Excel is a specific part of a worksheet you want to print. In this article, we provide instructions on how to set or clear print areas on an Excel worksheet and answer other commonly asked questions about the topic. If you use Excel for work, it's important to know how to use the different print options available on the software to make your work easier. People use the software for a wide range of purposes, including data entry and analysis, record keeping and basic and advanced accounting functions. Excel is one of the most ubiquitous spreadsheet tools, and many organisations expect their employees to be proficient in the application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |