Export One Excel Sheet to PDF with All Columns on One Page Width
In Excel desktop for Windows, fit the target sheet's columns to one page width and save it as PDF. Start with automatic page height so a long table can span several pages. Inspect both print preview and the saved PDF.
Published · Updated · FaultNote editorial policy
Who this guide is for and what to prepare
- People delivering only one sheet from a workbook
- People seeing cut-off columns or text that is too small in PDFs
What you need
- Save the workbook and identify the target sheet and cell range.
- Use Excel desktop on Windows; the web version has different page-setup capabilities.
- Identify the recipient's paper size and whether readability or a strict single-page requirement takes priority.
1. Choose the sheet and print area
Selecting several sheet tabs can include them together in output. Select only the intended tab and exclude working columns or notes that should not be delivered.
- Select only the target sheet tab and clear any grouped-sheet selection.
- Select the intended cells and use Page Layout → Print Area → Set Print Area.
- If an old range remains, clear the existing print area and set it again.
2. Set one page wide and automatic height
Fitting columns to one page width is different from fitting the entire table onto one page. Long tables are often more readable across multiple vertical pages.
Scroll horizontally to see the full table →
| Goal | Setting approach |
|---|---|
| Keep columns together | Start with one page wide and automatic height |
| Require exactly one page | Use one wide and one tall, then inspect text size |
| Keep small text readable | Review range, orientation, and paper size; allow multiple pages if needed |
- Under Page Layout → Scale to Fit, set Width to 1 page and Height to Automatic.
- For a wide table, choose landscape orientation and the recipient's paper size.
3. Check clipping and scaling in preview
Even a valid setting can shrink output excessively when the print area includes blank columns or long notes. Review the range before changing the scale alone.
- Press Ctrl + P and verify that the print target is the active sheet.
- Inspect the rightmost column, headings, last row, and page count.
- If output is too small, exclude unnecessary columns, use landscape, or allow additional pages.
4. Review PDF scope and save
Inspect the PDF publishing options too. Choosing the entire workbook can include sheets beyond the one you just reviewed.
- Use File → Save As or Save a Copy and select PDF as the file type.
- In Options, choose the active-sheet scope and review any page-range setting.
- Choose standard quality when readability is the priority and save the PDF with a separate filename.
5. Review the actual PDF
Reviewing the finished file catches publishing-scope mistakes as well as layout issues. A PDF does not replace the workbook for editing formulas.
- Open the PDF from its destination and verify that it contains only the intended sheet.
- At a practical reading zoom, inspect headings, numbers, and notes, then check every page for missing columns or unwanted blanks.
- If needed, revise the print area or page settings in Excel and compare a newly exported copy.
Limitations and requirements
- Setting both width and height to one page can make a large table unreadable.
- Print-area settings can persist in the workbook and affect later printing. Record the original setting if you need to restore it.
- PDF conversion does not guarantee that recipients cannot edit the file. Review the actual information being shared.
Frequently asked questions
Why does the table still span several pages?
Automatic height permits that. The columns remain together while rows can continue across pages for readability.
Why are other sheets included?
Check for grouped sheet tabs and an Entire workbook publishing scope. Select only the intended sheet and save again.
Official sources and verification date
Sources checked: . Check the official sources below for changes to supported systems, plans and menus.
Related practical guides
- Convert an Excel data range to a table
- Delete duplicate rows based on specified columns in Excel
- Create a dropdown list in Excel with data validation
- Freeze header row and leftmost column at the same time in Excel
- Import UTF-8 CSV in Excel without garbled characters
- LibreOffice Writer: Create a Document and Export It as PDF