Ravindra BagaleCourses & study guides मराठी Track your progress

14. Protection, Sharing and Printing

14.4 Print Area and Page Breaks

By Last updated:

Steps in Excel

  1. Select the range to print (for example the City summary A1:F40) › Page Layout › Page Setup › Print Area › Set Print Area.
  2. To add another range: select it › Print Area › Add to Print Area (each area prints on its own page).
  3. View › Workbook Views › Page Break Preview – blue lines show page breaks; drag them to change pages.
  4. Insert a manual break: select the row below where the new page should start › Page Layout › Page Setup › Breaks › Insert Page Break.
  5. Breaks › Reset All Page Breaks removes manual breaks; Print Area › Clear Print Area removes the print area.

Worked example. A 90-row city-wise orders list: set a print area A1:H90, insert a manual page break above the first row of each new city (Pune starts row 2, Nagpur row 32, Nashik row 50…) so every city manager gets their own page.

Ravindra Bagale's Tip

Many students press Ctrl + P and print directly, and then 15 pages come out – half of them blank or with a single column. Before printing, always check in Page Break Preview and set the Print Area. Save paper, and the manager is happy too!

Worked example — print area and page breaks

Why

Aarti Kulkarni in Pune and Carlos Rivera abroad both need a clear, repeatable way to use print area and page breaks on a Summit Schools sheet without breaking totals.

What

Print Area And Page Breaks is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for print area and page breaks.
  2. Enter a small made-up value for Aarti Kulkarni using £ where money appears.
  3. Add a second value for Carlos Rivera using € so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for Summit Schools's sample row.
Meaning: Once print area and page breaks is correct on one row, copy the same pattern down the column.

Practice tasks (10+)

Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.

1. Rebuild the smallest example of print area and page breaks on a blank sheet for Pearl Textiles.

Hint: Use only the steps on this page. Keep numbers numeric.

2. Change one input for Priya Deshmukh and confirm the result updates.

Hint: If the result is stuck, check absolute vs relative references.

3. Repeat the same steps with a £ or € value for Sophie Martin.

Hint: Formatting must not break SUM.

4. Write the result meaning in one plain sentence next to the cell.

Hint: Imagine explaining it to a new joiners.

5. Add a second row and fill the method down.

Hint: Double-click the fill handle if the pattern is consistent.

6. Break the example on purpose, then fix it using this lesson.

Hint: Common break: text instead of a number.

7. Apply print area and page breaks to a 5-row made-up Pearl Textiles table.

Hint: Keep column headers clear.

8. Check your answer with a simple total or COUNT.

Hint: A wrong total usually means a format or key mismatch.

9. Swap ₹ and $ on one column and re-check totals.

Hint: Stored values stay the same; only the display changes.

10. List two mistakes beginners make with print area and page breaks.

Hint: Look back at the tip box on this page.

11. Teach the steps out loud in under one minute.

Hint: Why → What → How.

12. Save the sheet as PearlTextil_practice.xlsx.

Hint: Use a clear file name for class.

Loading practice tasks...

  1. Input cells to unlock (Easy): How many cells are in the Monthly target column?
  2. Total target (Easy): Add up the Monthly target column.
  3. Total actual (Easy): Add up the Actual column.
  4. Highest target (Easy): What is the largest value in the Monthly target column?
  5. Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
  6. Cities below target (Medium): How many cities have a Gap below 0?
  7. Manager for a city (Medium): Find the Manager for City "London".
  8. Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
  9. Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
  10. Best performer (Hard): Which City has the largest Actual?
  11. Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
  12. Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Print Area And Page Breaks?
Card 1: What is Print Area And Page Breaks? · Download PNG
Revision card 2: Tiny example — Print Area And Page Breaks
Card 2: Tiny example — Print Area And Page Breaks · Download PNG
Revision card 3: Checklist — Print Area And Page Breaks
Card 3: Checklist — Print Area And Page Breaks · Download PNG