Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate correlation coefficient Correlation in Excel
  • How to create Gauge Chart in Excel
  • Randomize/ Shuffle List in Excel
  • Excel Pie Chart
  • How to create a Histogram in Excel

References

  • How to use Excel LOOKUP Function
  • How to get address of last cell in range in Excel
  • Count unique text values with criteria
  • Lookup entire row in Excel
  • How to use Excel OFFSET function

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation allow uppercase only
  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total
  • Excel Data validation allow weekday only

How to set or clear a print area in Excel Worksheet

by

Quick Tips On How To Set Multiple Print Areas in Excel

A print area is one or more ranges of cells that you designate to print when you don’t want to print the entire worksheet. If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection.

When you print a worksheet after defining a print area, only the print area is printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet.A worksheet can have multiple print areas. Each print area will print as a separate page.

Worked Example:   How to Break Worksheets into Pages in Excel

Set one or more print areas

On the worksheet, select the cells that you want to define as the print area.

Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page.

On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
  1. Set Print Area.
  2. Note: The print area that you set is saved when you save the workbook.

    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.

Add cells to an existing print area

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

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

    Note: If the cells that you want to add are not adjacent to 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 to an existing print area.

  2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add to Print Area.
  3. Add to Print Area

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

Clear a print area

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

  1. Click anywhere on the worksheet for which you want to clear the print area.
  2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.Clear a print area

Post navigation

Previous Post:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Identify Duplicate Values vs Remove Duplicates in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Not Equal To ‘<>‘ operator in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function

Date Time

  • Convert Excel time to decimal minutes
  • Extract time from a date and time in Excel
  • Get week number from date in Excel
  • Get day name from date in Excel
  • Get days before a date in Excel

Grouping

  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel

General

  • How to fill cell ranges with random text values in Excel
  • How to calculate percent variance in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • Excel Ribbon Quick Overview For Beginners
  • Count cells less than in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning