Excel for congtyketoanhanoi.edu.vn 365 Excel 2021 Excel 2019 Excel năm nhâm thìn Excel 2013 Excel 2010 Excel 2007 More...Less

If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don"t want khổng lồ print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed. You can địa chỉ cells to expand the print area as needed, and you can clear the print area to lớn print the entire worksheet.

Bạn đang xem: Where is set print area in excel 2007, 2010, 2013, 2016, 2019 and 365

A worksheet can have multiple print areas. Each print area will print as a separate page.


Note: The screen shots in this article were taken in Excel 2013. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.


What do you want lớn do?

Set one or more print areas

On the Page Layout tab, in the Page Setup group, click Print Area, và then click Set Print Area.

*

To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview in the Workbook Views group. When you save your workbook, the print area is saved too.

vị trí cao nhất of Page

Add cells lớn an existing print area

You can enlarge the print area by adding adjacent cells. If you add cells that aren’t adjacent khổng lồ the print area, Excel creates a new print area for those cells.

On the worksheet, select the cells that you want to add to the existing print area.

Xem thêm: 50+ Câu Hỏi Của Nhà Tuyển Dụng : Đừng Xem Nhẹ Bước Này!, Các Câu Hỏi Phỏng Vấn Tìm Việc Làm Thường Gặp


Note: If the cells that you want to add are not adjacent lớn the existing print area, an additional print area is created. Each print area in a worksheet is printed as a separate page. Only adjacent cells can be added khổng lồ an existing print area.


On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add lớn Print Area.

*

When you save your workbook, the print area is saved as well.

top of Page

Clear a print area


Note: If your worksheet contains multiple print areas, clearing a print area removes all the print areas on your worksheet.


Click anywhere on the worksheet for which you want lớn clear the print area.

On the Page Layout tab, in the Page Setup group, click Clear Print Area.

*

đứng top of Page

Need more help?

You can always ask an expert in the Excel Tech Community or get congtyketoanhanoi.edu.vn in the Answers community.


*
*
*

Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)