Converting an Excel spreadsheet to a PDF that fits the page means getting every column onto the sheet without splits or orphans. Open the file in Excel for Windows. Use the built-in Save As or Export commands. They are free. They add no watermark. The trick is adjusting the page layout before you save, not after.
Choose What to Export Sheet, Workbook, or Selection
Decide what part of the file you need. Open your spreadsheet in Excel for Windows. Go to File and choose Save As. In the file type dropdown, select PDF. You can also use File > Export > Create PDF/XPS. Both paths lead to a dialog with an Options button.
Click Options to see three choices for what to publish:
- Selection: Exports only the cells you have highlighted before opening the dialog.
- Active sheet(s): Exports the current sheet, or multiple sheets if you hold Ctrl and click their tabs.
- Entire workbook: Exports every sheet in the file into one PDF. Each sheet starts on a new page.
This handles the entire-workbook-to-PDF task in one step.
Stop Columns from Splitting Across Pages
The most common problem when you convert Excel to PDF is columns getting cut off and continuing onto the next page. Use the Scale to Fit settings to stop it.
Switch to Landscape Orientation
For wide spreadsheets, change the page orientation first. Go to the Page Layout tab. Click Orientation and select Landscape. Your columns get more horizontal room.
Set Width to One Page
Still on the Page Layout tab, find the Scale to Fit group. In the Width box, select 1 page. Leave the Height setting as Automatic. This forces all columns to shrink so they fit on one page width. No more cut-off columns.
To fit the data vertically on one page too, set Height to 1 page. That gives you a single-page PDF.
Use Page Break Preview to Check Layout
Before you save, see exactly where pages will break. Go to the View tab and select Page Break Preview. Excel shows blue lines marking page boundaries. Drag these lines to adjust where pages split. Scale to Fit settings override manual breaks if they conflict. This preview confirms that no columns are orphaned on a separate page.
Limit the Export with a Print Area
To export only part of a sheet, set a print area. Select the range of cells you want. Go to Page Layout > Print Area > Set Print Area. A dashed border appears around the selected cells. When you use Save As or Export with the Active sheet(s) option, only that print area is exported. Extra data stays out of the PDF. To clear the print area later, go back to Print Area and choose Clear Print Area.
Add Gridlines to the PDF
Gridlines may not appear in the PDF by default. To include them, go to the Page Layout tab. In the Sheet Options group, check the Print box under Gridlines. This adds the cell grid to the PDF. The gridlines print in light gray and do not affect the data or formatting.
Convert Excel to PDF That Fits the Page
- Open your Excel file in Excel for Windows.
- Go to Page Layout > Orientation and choose Landscape for wide sheets.
- In Scale to Fit, set Width to 1 page.
- Optional: Set Height to 1 page to fit everything on one sheet.
- Optional: Select a range, then go to Page Layout > Print Area > Set Print Area.
- Optional: Check Gridlines > Print in Sheet Options.
- Go to File > Save As and choose PDF as the file type. Click Options and pick Active sheet(s) or Entire workbook.
- Click Save. The PDF is created without a watermark.
Other Ways to Convert
The methods above use Excel for Windows built-in tools. Without Excel, or for a quick conversion without adjusting settings, use a dedicated tool like pdf-file-converter.net. Upload your Excel file and it converts to PDF. The same fit-to-page principle applies: adjust the original spreadsheet layout first to avoid cut-off columns.