Print and page setup in Excel is the one skill most beginners skip entirely — and it always comes back to bite them at the worst possible moment.

Picture this. You have spent two hours building a clean, organised spreadsheet. Budget figures all lined up. Column headers perfectly labelled. You hit Ctrl + P, click Print, and walk over to the printer feeling good about yourself. What comes out? Seven pages of chaos. Your data is split in bizarre places, the column headers only appear on page one, and there is an entire blank page at the end for absolutely no reason.

Sound familiar? You are not alone. This is one of the most common frustrations for anyone learning Excel. The good news is that once you understand how to print Excel spreadsheets properly, it takes just a few minutes to make any spreadsheet look polished and professional on paper. This lesson walks you through everything — page views, print areas, page breaks, headers and footers, repeating titles, scaling, and all the print settings you need before you ever click Print again.

Understanding Page Views in Excel

Before you touch a single print setting, you need to know about the three ways Excel lets you view your spreadsheet. Switching between these at the right time will save you a huge amount of trial and error.

Normal View

This is where you spend most of your time. It is the default working view — plain grid, no page edges visible, no margins. Great for entering and editing data, but it gives you no sense of how your spreadsheet will actually look when printed.

Page Layout View

Here’s the thing: Page Layout View is the view most beginners never use, and it is genuinely one of the most useful features in Excel for printing. It shows your spreadsheet exactly as it will appear on paper — page edges, margins, and a live header and footer area at the top and bottom of each page. And you can still edit your data while you are in it. To switch, go to the View tab and click Page Layout.

Page Break Preview

Page Break Preview shows your entire spreadsheet with blue lines marking where each page will split. Dashed blue lines are automatic breaks. Solid blue lines are manual breaks you have added yourself. You can drag these lines to new positions, which makes adjusting your layout incredibly quick. To enter it, go to View and click Page Break Preview. Think of these three views like three different pairs of glasses — Normal for working, Page Layout for checking appearance, Page Break Preview for fixing splits.

How to Set an Excel Print Area

What Is a Print Area and Why Does It Matter

The Excel print area is simply the range of cells you tell Excel to print. Without one, Excel prints everything on the sheet that contains any data at all — including any stray cell you accidentally typed in three weeks ago sitting in column AZ doing nothing. Setting a print area means you are in charge. You decide exactly what goes on paper.

Setting, Clearing, and Adding to a Print Area

Print Area vs. Print Selection

You’ve probably seen the Print Selection option in the Print dialog. Here is the difference: a Print Area is saved with the workbook and used every time you print. Print Selection is a one-time choice in the Print dialog that resets after each job. Use Print Area for regular reports. Use Print Selection for a quick one-off.

Page Orientation, Paper Size, and Margins

Portrait vs. Landscape

Portrait is taller than wide — use it when your spreadsheet has more rows than columns. Landscape flips the page on its side, giving you more horizontal room for wide tables. Go to Page Layout > Orientation to switch.

Choosing the Right Paper Size

Most of the world uses A4. North America typically uses Letter. Make sure your Excel paper size matches what is actually in your printer — otherwise your margins and scaling will be slightly off. Go to Page Layout > Size to change it.

Adjusting Margins

Margins control the empty space around the edges of your page. Go to Page Layout > Margins and choose Normal, Wide, or Narrow — or click Custom Margins for exact values.

Scaling: How to Fit Your Data on One Page

Fit Sheet on One Page

This squeezes your entire spreadsheet — rows and columns together — onto one page. It works, but with a lot of data the text can become tiny and unreadable. To use it: go to Page Layout > Scale to Fit, set Width to 1 page and Height to 1 page.

Fit All Columns on One Page

Trust me on this one — this option is almost always better. It forces all columns to fit within the page width while letting rows continue naturally onto more pages. Your text stays readable and columns never get chopped off at the right edge. Set Width to 1 page and leave Height on Automatic.

Custom Scaling

For precise control, type a percentage into the Scale field. 100% is normal size. 85% is slightly smaller. Try not to go below 75% or the text will be too small for most people to read comfortably.

Working with Excel Page Breaks

Where Excel Inserts Automatic Page Breaks

Excel calculates page breaks based on your paper size, margins, and scaling. These appear as dashed lines in Normal View and dashed blue lines in Page Break Preview. You cannot move automatic breaks directly, but changing margins or scaling will shift them.

How to Insert and Remove Manual Page Breaks

To remove a single break: click the row or column beside it, then go to Page Layout > Breaks > Remove Page Break. To clear all manual breaks at once: go to Page Layout > Breaks > Reset All Page Breaks.

Dragging Breaks in Page Break Preview

In Page Break Preview, you can click and drag any blue page break line to a new position — no menus needed. Dashed automatic breaks turn into solid manual breaks the moment you move them.

Adding Excel Headers and Footers to Your Print

Headers print at the top of every page. Footers print at the bottom. They are invisible in Normal View but appear in Page Layout View and on every printed page. Use them for page numbers, the document title, your company name, the date, or a file path.

Accessing the Header and Footer Tool

Switch to Page Layout View. You will see a gray box at the top of each page that says Click to add header. Click inside it to start editing. You can also go to Insert > Header & Footer.

Adding Page Numbers, Dates, and File Names

When you click inside the header or footer, the Header and Footer tab appears on the ribbon. Use the buttons to insert automatic elements:

• Page Number — inserts the current page number
• Number of Pages — inserts total page count. Use both together for “Page 1 of 3” style numbering.
• Current Date — updates automatically each time you print
• File Name / Sheet Name — inserted automatically

Adding a Company Name or Logo

For plain text, click in the header area and type. For a logo, click in the header area and choose Picture on the Header and Footer tab to insert an image file.

Print Titles: Repeat Rows and Columns on Every Page

Why Print Titles Are a Game Changer

Imagine printing a 10-page spreadsheet where row 1 holds column headers like Date, Product, Region, and Sales. On page one they are visible. By page three they are long gone, and the reader is staring at a wall of numbers with no idea what column is what. Print Titles solves this in about 30 seconds.

How to Set Rows to Repeat at Top

How to Set Columns to Repeat at Left

Same process — click inside the Columns to repeat at left field instead, click the column letter you want, and click OK.

Excel Print Settings: The Final Checklist Before You Print

Printing Gridlines and Headings

Here is something that surprises almost every beginner: Excel does not print gridlines by default. The grid you see on screen does not appear on paper unless you turn it on. To print gridlines, go to Page Layout > Sheet Options and tick the Print checkbox under Gridlines. To also print row numbers and column letters, tick Print under Headings.

Black and White Mode and Draft Quality

If your spreadsheet has colored cells and you want to avoid color ink, force Excel to print in black and white. Open the full Page Setup dialog (click the small arrow at the bottom right of the Page Setup group), go to the Sheet tab, and tick Black and white. Draft quality prints faster but at lower resolution — fine for internal review copies, not for final submissions.

Print Order

When a spreadsheet spans multiple pages both down and across, print order controls the sequence pages are numbered. Down, then over prints all pages going down the left column first, then moves right. Over, then down does the reverse. Find this in the Sheet tab of the Page Setup dialog.

How to Print an Excel Spreadsheet or Save It as a PDF

Print and Page Setup in Excel: Quick Recap

Frequently Asked Questions

How do I stop Excel from printing blank pages?

The most common cause is a stray cell far below or to the right of your actual data. Press Ctrl + End to jump to the last used cell. If it is well beyond your data, delete those empty rows and columns, then set a print area to lock in only what you need.

Why do gridlines not appear when I print?

Excel does not print them by default. Go to Page Layout > Sheet Options and tick the Print checkbox under Gridlines.

How do I print only a selected range in Excel?

Either set a print area for that range, or press Ctrl + P and change Print Active Sheets to Print Selection in the Settings dropdown. Note that Print Selection only applies to that one print job.

Can I save my Excel file as a PDF and keep all my print settings?

Yes, completely. Your print area, headers, footers, orientation, and scaling all carry over into the PDF when you use Microsoft Print to PDF as your printer.

Keep Learning

This lesson is part of the XplorExcel beginner series. If you are still getting comfortable with the ribbon and finding your way around, head back to Lesson 1: Excel Interface at XplorExcel.com. And if you want your data to look just as sharp on screen as it does on paper, check out Lesson 5: Formatting Cells at XplorExcel.com — borders, shading, and number formats that make any printed spreadsheet much easier to read.