Print area allows to print each set of print area on a new page.

You do not need to print the data of a worksheet, which you don't want.

By setting the print area, you will get resolved the problem of printing the entire sheet data instead of necessary one.

Print area enables more control over the workbook for printing the data.

In case your mind changes and you do not want to print by area, you can clear it out and go for the entire sheet print at once.

It helps when the users require the data to be printed by broken on different pages. Each defined print area will print on different pages. One of the advantages of using print area is that you can define multiple print areas in a single worksheet or a single workbook. It means that only a selected portion of the sheet gets printed instead of entire sheet on applying print area feature on the sheet. When the print command executes, only the selected area (print area) of the Excel sheet goes for print. What is print area?Ī print area is a special feature of printing in MS Excel that enables the users to print specific area (a range of cells) of a worksheet. In this chapter, we will instruct the Excel users to set the print area in a worksheet. This chapter and its topics will help you to set the print area. In MS-Excel, if you set a print area in a worksheet, only that selected part of the print area will be printed. This Excel feature is called as Print area.

Thus, they can set print area to print only the necessary part of the sheet.Įxcel allows the users to set the area to print a particular area of the Excel sheet. Sometimes, they may require to print a particular area instead of the entire sheet. All the time, the user does not need to print the entire sheet with data. Generally, when the Ctrl+P key (print command) is pressed in Excel the entire page gets printed by default. Next → ← prev How to set print area in excel?

Excel set print area to one page