iconvilla.blogg.se - Excel set print area

#Excel set print area how to

Step 4: To edit the print area displayed here, select the print area and click the Edit button. Step 3: A panel will open containing with all print areas set by the users. Step 2: Change the tab to Formula tab, where you will see the Defined Names group. Step 1: Open the Excel sheet in which you have set the print area. Edit print areaįirstly, we will show you how one can edit the print area. We will instruct you to edit or remove the print area in an Excel sheet. Excel allows the users to edit or remove the print area.ĭo not mislead, the steps for edit and remove the print area are totally different than setting the print area. You need to edit or remove the print area you have set earlier. Sometimes it might be possible that the requirement has changed. You will find this option inside the Formula tab under the Defined Names group section. Note: To edit or remove the print area, you can use Name manager. You will notice that the only print area will be showing inside the printing screen. Step 6: See the print preview for the print area data. Step 5: Click the File tab and click the Print option to print the created print area in the previous steps. Save the Excel file and close the file now and reopen it. Step 4: You will notice that the Print_Area text is appearing inside the name box it means that the print area has been set. Step 3: Click the Set Print Area option here. Step 2: Click the Print Area inside the Page Layout tab. You also select a range of cells.įrom the set of data, we will create a set of three years of data to print. Step 1: We have also taken an Excel sheet and selected a set of data to print it. Take an Excel sheet of data on which you can perform the steps to set the print area. You can follow this chapter till the end. This section of this chapter has the instructions to set the print areas in a worksheet. Print area is a very interesting feature of Excel. Each of the areas prints separately on different pages.įollowing are some important topics about set, edit, and remove print area that we will try to cover in this chapter: A worksheet can have multiple print areas.

Excel has a feature named as Print Area inside the Page Layout tab.

The user should set the print areas before sending the Excel data for print.

The Excel users can set more than one print area within a single worksheet/workbook.

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.

#Excel set print area how to

Next → ← prev How to set print area in excel?