Question EN

How do I set a print area in Excel?

Answer

Select the range you want, then go to Page Layout → Print Area → Set Print Area. Now only that selection will print.

Detailed explanation

Setting a print area lets you print just the part of your worksheet you need, not everything.

How to Set the Print Area

Select the range of cells you want to print
Go to the Page Layout tab
Click Print Area → Set Print Area

Done! Now Ctrl+P will print only this area.

How to Add Another Area

If you need to print multiple non-contiguous ranges:

Select the new range
Print Area → Add to Print Area

Each range will print on a separate page.

How to Clear the Print Area

Page Layout → Print Area → Clear Print Area

Visual Check

The print area shows as a blue border in Page Break Preview mode (View → Page Break Preview).

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free