How to Print a Wide Excel Spreadsheet (Excel 2007 → Current)

Method 1 — Fit All Columns on One Page (Best Method)

This forces Excel to scale the sheet so the width fits on one page.

1. Open your spreadsheet in Excel.
2. Click the Page Layout tab.
3. Look for the Scale to Fit section.
4. Set:

• Width: 1 page
• Height: Automatic (or leave blank)

Now when you print, all columns will fit across one page.

✔ Works in: Excel 2007, 2010, 2013, 2016, 2019, 2021, 365

Method 2 — Use Print Scaling (Quick Method)

1. Press Ctrl + P.
2. Under Settings, find Scaling.
3. Choose:

• Fit All Columns on One Page

or

• Fit Sheet on One Page (fits both width and height)

Method 3 — Change Page Orientation

Wide spreadsheets print better in landscape.

1. Click Page Layout.
2. Click Orientation.
3. Select Landscape.

Method 4 — Reduce Margins

1. Go to Page Layout.
2. Click Margins.
3. Choose Narrow.

This gives more printable space.

Method 5 — Print Only Selected Columns

If you only need part of the sheet:

1. Highlight the columns you want to print.
2. Click Page Layout.
3. Click Print Area → Set Print Area.
4. Print normally.

Method 6 — Page Break Preview (Advanced Control)

1. Click the View tab.
2. Select Page Break Preview.
3. Drag the blue lines to control where pages break.

Best Professional Printing Setup

For most spreadsheets use:

• Landscape Orientation
• Narrow Margins
• Fit All Columns on One Page

This gives the cleanest printed result.

Extra Tip (Very Useful)

Add column headers to every page:

1. Go to Page Layout
2. Click Print Titles
3. Set Rows to repeat at top

Your headings will print on every page.