Exporting Spreadsheets to PDF Without Cut-Off Columns

A spreadsheet PDF drops columns when the print area, the paper orientation, or the scaling does not match the table. Set the print area to the cells you mean to send, use landscape for a wide sheet, and fit the width to one page only while the type is still readable. After the export looks right, Merge PDF can combine separate section files, and Compress PDF can shrink images you have already checked. Formulas, pivot filters, and row groups are frozen in the PDF. If someone has to audit or re-sort, send the .xlsx as well.

A Q3 actuals export showed how fast this fails. The sheet had 14 columns, portrait letter paper, and "fit sheet on one page." The PDF showed columns A through H. The text was 4 pt. Columns I through N were gone. The board meeting started in twenty minutes.

The export settings have to follow the column count. Otherwise the PDF is a cropped picture of the sheet.

Root causes of cut-off exports

• The print area includes 200 empty columns
• Fit all columns on one page shrinks the type until it is illegible
• Portrait on a 12-column table
• Margins plus a header and footer eat the width
• Hidden rows or columns show up as a surprise
• A page break lands in the middle of a merged cell

Excel export workflow

1. Clean the sheet

• Delete unused columns and rows outside the data
• Freeze the header row for a multi-page export (Print Titles, then repeat row 1)
• Keep number formats consistent. Invoice Rounding covers currency rounding

2. Set print area

Select the data block, then use Page Layout → Print Area → Set Print Area.

3. Orientation and size

• Use landscape for wide tables
• Use legal or A3 if the print shop supports it. Ask before you build the board packet
• Printable PDF Margins covers margins. Narrow margins are for internal reports only

4. Scaling

| Goal | Setting | | --- | --- | | Readable multi-page | 100% scale, landscape | | Fit width only | Width: 1 page, Height: automatic | | Fit entire sheet on one page | Last resort. Verify the font size | | Split by section | Multiple print areas or separate sheets |

5. Export

Use File → Save As → PDF, or Print, then Microsoft Print to PDF.

Check the page-count preview before you save.

Google Sheets

Use File → Print. Set landscape, scale, margins, and gridlines there. "Fit to width" and "Fit to page" have the same traps as Excel.

Multi-table reports

Unrelated tables stacked on one sheet leave headers stranded on the wrong page. Put them on separate tabs, export each tab, and combine them with Merge PDF, plus a cover sheet if you need one.

Charts and images

Charts sometimes export as vectors and sometimes as rasters. Test the color. PDF Color Profiles covers print color.

Large images inflate the file size. Run Compress PDF after you have verified the pages.

GST and tax columns

Invoices with more than one rate need the extra columns, which means a wide table and landscape pages. See Sales Tax Multiple Rates and GST Inclusive vs Exclusive.

When a PDF is the wrong file to send

• For an interactive pivot, send the Excel file with a password
• Live formulas do not survive. The PDF is a snapshot only
• For a huge data set, send a CSV plus a one-page summary PDF

Repeat header rows

In Excel, use Page Layout → Print Titles → Rows to repeat at top: $1:$1. A multi-page export without repeating headers leaves readers asking which column they are looking at.

Page breaks

Insert a page break before a major section header so a summary row is not left alone at the bottom of a page. Scroll the entire print preview before you send the file to the CFO.

Google Sheets limits

Complex Excel charts may render differently in a Sheets export. For a chart-heavy board pack, the native Excel PDF export is the better file.

Worked example: exporting a 10-column monthly P&L without orphan columns

1. Select the active table (A1:J48) and set Page Layout → Print Area → Set Print Area so scratch notes in columns L:N are excluded.
2. Switch orientation to landscape and set margins to Narrow (0.25 in left and right).
3. Under Scale to Fit, set Width to 1 page and Height to automatic. Do not set the sheet to 1 page tall on a 48-row sheet. That crushes 11 pt numbers down to 5 pt.
4. Set Print Titles → Rows to repeat at top: $1:$2 so the column headers appear on page 2, then export to PDF and combine the file with your executive summary cover in Merge PDF.

Limitations

Once the sheet is a PDF, formulas, pivot filters, and expandable row groups are frozen into static text and lines. If recipients need to audit formulas or re-sort rows, send the .xlsx file alongside the signed PDF snapshot.

Conclusion

For a wide table, set the print area, use landscape, and fit the width. Squashing the whole sheet onto one page is a last resort, and only if the type is still readable. Preview the page count before the board meeting.

If the text drops below 8 pt, add pages. Columns I through N still have to be visible. Smaller type will not put them back.