Converting a spreadsheet to PDF should be simple, but the result often disappoints: a price list spills onto six pages with two columns each, an attendance register prints with the last column on a separate page, or a tiny table sits in the corner of a huge empty page. The fix is mostly in preparing the sheet before converting. This guide explains how to convert Excel to PDF and make it fit neatly, whether on one page or across several readable pages.
Quick conversion in your browser
- Open Excel to PDF.
- Select your .xlsx, .xls or .csv file. The conversion runs in your browser; the file is not uploaded.
- Download the PDF and review every page.
The browser converter is approximate: it handles common tables well, but complex formatting, charts, merged cells and conditional formatting may look different from Excel. For a pixel-perfect result with full control over page setup, export from Excel or Google Sheets as described below.
Prepare the sheet: the five settings that matter
1. Set the print area
Select only the cells you want in the PDF and choose Page Layout → Print Area → Set Print Area. Empty cells with stray formatting far down the sheet are a common reason for extra blank pages.
2. Choose orientation
Wide tables with many columns fit better in landscape. Long lists with few columns fit better in portrait.
3. Scale to fit
In Excel, Page Layout → Scale to Fit: set Width: 1 page and Height: Automatic. This keeps all columns on one page width while allowing the rows to continue onto more pages. Setting both to 1 page forces everything onto a single page, which is fine for small sheets but makes text unreadably small for large ones.
4. Repeat header rows
For multi-page tables, Page Layout → Print Titles → Rows to repeat at top prints the column headings on every page, so readers know what each column means.
5. Adjust margins and paper size
Choose A4 for Indian offices and printing. Narrow margins give a little more space. Centre the table horizontally for a polished look.
Export from Excel or Google Sheets
- Excel: File → Save As → PDF or File → Export → Create PDF. Choose whether to export the active sheet, the selection or the entire workbook.
- Google Sheets: File → Download → PDF. The export dialog lets you set paper size, orientation, "Fit to width", margins, gridlines and repeated headers.
- Phone: in the Excel or Sheets app, use Share or Print and choose "Save as PDF".
Common problems and fixes
Columns cut off onto another page
Use "Fit all columns on one page" or Width: 1 page, switch to landscape, reduce column widths, or hide columns that are not needed in the PDF.
Text is too small to read
The sheet has too many columns for one page width. Hide unnecessary columns, shorten headings, wrap text in narrow columns, or split the table into two logical parts.
Blank pages at the end
Clear the formatting of unused rows and columns, or set a print area. You can also delete empty pages from the PDF with Remove PDF Pages.
Numbers show as ####
The column is too narrow for the value. Widen it before exporting.
Gridlines missing or unwanted
In Excel, Page Layout → Sheet Options → Gridlines: Print controls this. For a cleaner look, use cell borders instead of gridlines.
Typical uses in Indian offices and schools
| Document | Recommended setup |
|---|---|
| Price list or rate card | Portrait, fit to width, repeat header row, shop name in the header |
| Attendance register | Landscape, fit to width, freeze names column, repeat headers |
| Salary or expense statement | Portrait, totals bold, page numbers in the footer |
| Marks or result sheet | Landscape, fit to one page if small, otherwise fit to width |
| GST invoice from Excel template | Portrait, fit to one page, margins narrow |
After converting
- Add page numbers if you did not set them in Excel, with Add Page Numbers. See our page numbering guide.
- Combine several sheets or attach a covering letter with Merge PDF.
- Protect confidential sheets like salary data with Protect PDF; read how to password-protect a PDF.
- Add "Confidential" or your company name with Add Watermark.
Going the other way
If you received a table as a PDF and need it back in Excel, use PDF to Excel for digital PDFs or Convert to Excel (OCR) for scanned ones. Our PDF to Excel guide covers cleaning up the result.
Checking the result before sending
Open the finished PDF and scroll through every page at normal zoom. Check that totals are on the same page as the table they belong to, that column headings appear at the top of each page, and that no column has been pushed onto a page of its own. Check that dates and currency formats came out correctly, especially if the sheet uses Indian formats such as lakh separators or DD/MM/YYYY dates. If something is off, fix it in the spreadsheet and export again rather than editing the PDF; the spreadsheet stays your master copy.
Summary
Set a print area, choose the right orientation, scale to one page width, repeat header rows and check the preview before exporting. For quick conversions without Excel installed, use the browser converter and review the result carefully.
Try it now: Excel to PDF is free to start and works on mobile and desktop.
Open Excel to PDF