Mastering Excel Printing: Setup, Preview, and Best Practices

Learn how to effectively print your Excel spreadsheets. This guide covers page setup, print preview, scaling, headers/footers, and essential printing tips for professional results.

From Screen to Page: Your Essential Guide to Printing in Excel

While much of our work in Excel remains digital, there are often times when a printed copy is necessary – for meeting handouts, physical reports, or archival purposes. However, printing spreadsheets can be tricky; what looks perfect on screen might appear misaligned, cut off, or unreadable on paper. This module demysties the printing process in Excel, equipping you with the knowledge to ensure your printed output is accurate, professional, and exactly as intended.

We’ll cover everything from initial setup and previewing your pages to advanced options that give you granular control over your printed documents.

The Importance of Print Preview

Before you even think about hitting the print button, Print Preview is your most crucial tool. It shows you exactly how your worksheet will appear on paper, page by page.

1. Go to the File tab.
2. Click Print.

Here, you’ll see a preview on the right and printing options on the left. This is where you’ll make most of your adjustments.

Setting Up Your Page for Printing

The Page Setup options, accessible directly from the Print screen (usually under “Settings” > “Page Setup”) or via the Page Layout tab, are fundamental to controlling your print output.

Key Page Layout Options:

1. Orientation:

• Portrait: Taller than it is wide (default). Best for narrower worksheets with many rows.
• Landscape: Wider than it is tall. Essential for wide worksheets with many columns.
• Access: Page Layout tab > Page Setup group > Orientation.

2. Margins: The white space around the edges of your printed page.

• Normal, Wide, Narrow: Pre-set margin options.
• Custom Margins: Allows precise control. You can also choose to Center on Page horizontally or vertically for a balanced look.
• Access: Page Layout tab > Page Setup group > Margins.

3. Size: Select the paper size you are using (e.g., Letter, A4). Ensure this matches the paper loaded in your printer.

• Access: Page Layout tab > Page Setup group > Size.

4. Print Area: Define a specific range of cells you want to print, ignoring everything else on the sheet.

• To Set: Select the desired cells, then go to Page Layout > Print Area > Set Print Area.
• To Clear: Go to Page Layout > Print Area > Clear Print Area. This is vital if you’ve previously set an area and want to print the whole sheet again.

5. Breaks: Manually insert page breaks to control where one page ends and the next begins.

• Insert Page Break: Select the row below where you want the break, then Page Layout > Breaks > Insert Page Break. The break will occur above the selected row.
• Remove Page Break: Select a cell within the row/column affected by the break, then Page Layout > Breaks > Remove Page Break.
• Reset All Page Breaks: Use this if your manual breaks are causing issues.

6. Background: Insert a watermark image (usually a logo) that appears behind the worksheet content. This is typically used for draft or confidential markings.

• Access: Page Layout tab > Page Setup group > Background.

7. Print Titles: Specify rows or columns that should repeat on every printed page. This is crucial for large spreadsheets where you need headers on each page.

• Access: Page Layout tab > Page Setup group > Print Titles. In the dialog box, you can specify “Rows to repeat at top” and “Columns to repeat at left.”

Scaling Options: Fitting Your Data to the Page

One of the most common challenges is fitting wide or long spreadsheets onto a manageable number of pages. Excel’s scaling options are designed for this:

• Access: Found under Page Layout > Scale to Fit or within the Page Setup dialog box (under the “Page” tab).

• Options:

• Normal (100%): Prints content at its actual size.

• Fit Sheet on One Page: Shrinks the entire worksheet, no matter how large, to fit onto a single printed page. Use with caution, as text can become very small.

• Fit All Columns on One Page: Ensures all columns fit, but rows may span multiple pages. Good for very wide, short reports.

• Fit All Rows on One Page: Ensures all rows fit, but columns may span multiple pages. Good for very long, narrow reports.

• Custom Scaling: Set a specific percentage (e.g., 90%) or adjust “Tall” and “Wide” scaling independently.

Tip: When using scaling, always check Print Preview to ensure readability.

Headers and Footers: Adding Information to Every Page

Headers (top of the page) and Footers (bottom of the page) are ideal for including information that should appear on every printed page, such as page numbers, dates, file names, company logos, or report titles.

• Access:

• Page Layout tab > Page Setup group > Print Titles. Click the Header/Footer tab.

• Alternatively, go to View tab > Workbook Views group > Page Layout View. You’ll see distinct areas for headers and footers at the top and bottom of each page. Click into these areas to edit.

• Editing Headers/Footers: Excel provides pre-designed options (e.g., “Page 1 of 3,” current date) or allows you to create custom ones. You can insert:

• Page numbers

• Number of pages

• Current date/time

• File path

• File name

• Sheet name

• Pictures (like a logo)

Use the formatting buttons within the Header/Footer dialog to adjust font, size, and alignment.

Printing Options and Settings

On the File > Print screen, you’ll find several important settings under the “Settings” section:

• Printer: Select the desired printer.
• Settings:
• Print Active Sheets: Prints only the sheets currently selected.
• Print Entire Workbook: Prints all sheets in the workbook.
• Print Selection: Prints only the range you previously defined as the Print Area.
• Collate: Determines if copies of multi-page documents are printed in order (e.g., pages 1,2,3 then 1,2,3) or if all copies of page 1 print, then all copies of page 2, etc. Choose collated for multi-copy printing.
• Orientation, Paper Size, Margins, Scaling: These are shortcuts to the Page Setup options.

Advanced Printing Considerations

• Gridlines: By default, gridlines are not printed. To print them, go to Page Layout > Sheet Options > check the Print box under Gridlines.
• Headings: To print row and column headings (A, B, C… and 1, 2, 3…), go to Page Layout > Sheet Options > check the Print box under Headings.
• Black & White Printing: If your printer doesn’t support color or you need a monochrome output, check the Black & White option on the Page Layout tab (under Sheet Options). This converts colors and fills to shades of gray and black patterns.
• Draft Quality: For quick printouts where appearance isn’t critical, enabling draft quality can save ink/toner and speed up printing. This is usually a printer driver setting.

Conclusion: Print with Confidence

Printing in Excel involves understanding the relationship between your digital worksheet and the physical page. By mastering Print Preview, diligently using the Page Setup options (Orientation, Margins, Scaling), defining Print Areas, and leveraging Headers/Footers and Print Titles, you can take control of your output. Always preview before you print, and remember that thoughtful setup ensures your spreadsheets make a professional impression, whether on screen or on paper. Now that we’ve covered how to present our data physically, let’s dive into powerful tools for analyzing it: PivotTables.