Make a worksheet fit the printed page

To make a worksheet fit on a printed page in Excel, you can scale it using built-in print options. Here’s how:

✅ Option 1: Use “Fit Sheet on One Page” (Quickest Method)

1. Go to File → Print (or press Ctrl + P).
2. Under Settings, click the dropdown that says No Scaling.
3. Choose one of the following:
   • Fit Sheet on One Page — shrinks everything to fit on one page.
   • Fit All Columns on One Page — great for wide sheets.
   • Fit All Rows on One Page — for long sheets.
4. Check the Print Preview on the right.
5. Click Print when ready.

✅ Option 2: Use Page Layout Settings

1. Go to the Page Layout tab.
2. In the Scale to Fit group:
   • Set Width to 1 page
   • Set Height to Automatic (or 1 page to force everything onto a single page)
3. Excel will automatically scale the sheet to fit when you print.

⚠️ Tip: Be Careful with Scaling

• If your sheet is very large, shrinking everything to one page might make the text too small.
• You can try adjusting column widths or changing the paper to Landscape Orientation to help.