Excel Print and Page Setup
Printing an Excel sheet looks simple until your table prints across three pages with half the columns on a separate page. Excel gives you a full set of controls to decide exactly what prints, how big it looks on paper, and where page breaks fall. This topic covers every setting you need to print clean, professional output.
Opening the Print Preview
Before printing anything, always check the print preview. Press Ctrl + P or go to File → Print. The right side of the screen shows exactly how each page will look on paper. Scroll through the pages using the arrows at the bottom. If the layout looks wrong, close the preview and adjust the settings below.
Page Layout Tab
The Page Layout tab in the Ribbon contains most print settings. Click it to see the options grouped into sections: Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange.
Setting Page Orientation
Orientation controls whether the page prints vertically (portrait) or horizontally (landscape).
Portrait (Tall) Landscape (Wide) +----------+ +------------------+ | | | | | | | | | | +------------------+ +----------+ Use Portrait for: Use Landscape for: - Short tables - Wide tables with many columns - Text documents - Charts and dashboards
Go to Page Layout → Orientation and choose Portrait or Landscape.
Setting Paper Size
Go to Page Layout → Size to choose the paper size. A4 is the standard size in most countries. Letter (8.5" × 11") is standard in the United States. Choose the size that matches the paper in your printer.
Setting Margins
Margins are the blank spaces around the edges of the printed page. Smaller margins give more room for your data. Go to Page Layout → Margins and choose from:
| Margin Preset | Top/Bottom | Left/Right | Best For |
|---|---|---|---|
| Normal | 1.91 cm | 1.78 cm | Standard documents |
| Wide | 2.54 cm | 2.54 cm | Documents with notes in margins |
| Narrow | 1.91 cm | 0.64 cm | Wide tables that need more space |
| Custom Margins | You choose | You choose | Precise control |
Scale to Fit
Scale to Fit forces your entire spreadsheet (or a selected portion) to print on a specific number of pages. This avoids the common problem of one or two columns spilling onto a separate page.
| Setting | What It Does |
|---|---|
| Width: 1 page | Shrinks all columns to fit across one page width |
| Height: 1 page | Shrinks all rows to fit down one page |
| Width: 1, Height: 1 | Forces the entire sheet onto exactly one page |
Find these controls under Page Layout → Scale to Fit. You can also set a percentage manually — for example, 80% shrinks everything to 80% of its normal size.
Setting a Print Area
A print area tells Excel to print only a specific range of cells, ignoring everything else.
Select the cells you want to print. Go to Page Layout → Print Area → Set Print Area. A dashed border appears around your selected range. Every time you print, Excel prints only that area.
To remove the print area and go back to printing the whole sheet, go to Page Layout → Print Area → Clear Print Area.
Page Breaks
A page break tells Excel where one printed page ends and the next begins. Excel adds automatic page breaks, but you can insert your own.
Inserting a Manual Page Break
Click the row below where you want a horizontal page break. Go to Page Layout → Breaks → Insert Page Break. A dashed line appears above the row you selected, marking the break.
Viewing Page Breaks with Page Break Preview
Go to View → Page Break Preview. Excel shows a blue-line view of exactly where pages break. Drag the blue lines to move page breaks where you want them. This view makes it easy to see and adjust all breaks at once.
Page Break Preview:
Page 1 | Page 2
+------------------------+|+------------------------+
| Row 1 || Row 21 |
| Row 2 || Row 22 |
| ... || ... |
| Row 20 || Row 40 |
+------------------------+|+------------------------+
Blue dashed line marks the break
Printing Row and Column Headers on Every Page
When a table spans many pages, the column headings (like Name, Date, Amount) appear only on page 1 unless you tell Excel to repeat them.
Go to Page Layout → Print Titles. In the dialog that opens, click the Rows to repeat at top field and click the row that contains your headings (for example, row 1). Click OK. Now row 1 prints at the top of every page.
Adding Headers and Footers
Headers appear at the very top of each printed page. Footers appear at the bottom. Use them for page numbers, the date, the file name, or your company name.
Go to Insert → Header and Footer. Excel switches to Page Layout view and shows three boxes at the top — left, centre, and right. Click any box and type your text. The Header and Footer Tools ribbon appears, giving you buttons to insert page number, total pages, date, time, and file path automatically.
Print Settings Summary Diagram
BEFORE YOU PRINT — CHECKLIST +-------------------------------------------+ | 1. Ctrl + P → Check Print Preview | | 2. Orientation: Portrait or Landscape? | | 3. Paper size: A4 or Letter? | | 4. Margins: Normal, Narrow, or Custom? | | 5. Scale to fit: 1 page wide? | | 6. Print area set? (optional) | | 7. Headers repeat on all pages? | | 8. Page numbers in footer? | +-------------------------------------------+
These settings stay saved with your Excel file. The next time you open the file and print, Excel uses the same layout settings.