How To Set Print Area In Excel

You can set a specific cell or a cell vary as a Print Area if you happen to want to print solely that choice as an alternative of your complete doc. For instance, if you happen to’re calculating the sum of complete gross sales, you’d solely wish to print the outcomes. When you set the consequence cell vary as Print Area, you do not need to create a wholly new doc to position and print the outcomes.

Once you create a Print Area, you possibly can later add more sections to the prevailing Print Area. Allocating a piece as a Print Area is particularly helpful if you happen to incessantly print values from a specific space in your worksheet.

Step 1: Set a New Print Area

You can add a brand new Print Area in your worksheet from the web page format tab within the menubar.

1. Launch Excel.
2. Select the vary you wish to print values from the grid.
3. Head to Page Layout.
4. Click Print Area > Set Print Area.

Step 2: Add to an Existing Print Area

You can add a brand new space to the prevailing Print Area. However, if the world just isn’t neighboring your present Print space, Excel prints the added Print Area to a unique web page.

1. On your workbook, choose the cell vary.
2. Select Page Layout from the menubar.
3. Click Print Area > Add to Print Area.

Step 3: Edit Range in Print Area

If you’ve added a variety you didn’t intend to set as Print Range, you possibly can take away the person vary from the Page Setup Window. Similarly, you can even enter cell ranges so as to add to the Print Area.

1. Open your worksheet.
2. Head to Page Layout.
3. In the Page Setup part, click on the increase icon.
4. Select the Sheet tab.
5. Add or delete your vary within the Print space.

Step 4: Clear Print Area

Excel shows an alert while you set a single cell as a Print Area to verify your motion. You can choose the Cancel button from the warning message to clear the Print Area.

You can clear all Print Areas from the Page Layout tab.

1. Head to Page Layout out of your worksheet.
2. Select Print Area.
3. Choose Clear Print Area.