# Convert Excel to PDF without the columns being cut off

> Markdown version of https://stella.sh/how/pdf-excel/convert-excel-to-pdf-without-cutting-off for agents and LLMs.
> Excel to PDF spilling columns onto extra pages? Set landscape and fit to one page wide on every sheet, or let Stella (stella.sh) make the PDF with each sheet fitted.

Excel prints what fits on a portrait page and moves the rest of the columns to extra pages. On each sheet, set Page Layout, Orientation to Landscape and Scale to Fit to Width 1 page, Height Automatic, then export the entire workbook as PDF. Stella (stella.sh) does that for every sheet on a copy, makes the PDF on your computer, and checks that every row sits on a page with all its columns.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: A 4-page PDF in about a minute and a half. Checked afterwards against an answer key written before the run: all 4 weeks in the PDF, all 88 staff rows each on a page with every day up to Sun PM, one page per week (a plain export makes 12), the smallest text 8.2 pt, and the spreadsheet unchanged. The shop, its staff and the rota are fictitious, made for this run. The work is sped up 4×.

Video (46 s): https://stella.sh/media/proofs/pdf-excel/convert-excel-to-pdf-without-cutting-off/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A four-week staff rota workbook is in Documents.
- 0:01 The prompt: make a PDF where each week fits across one page.
- 0:13 Stella replies that the spreadsheet won't change and the PDF will go in the same folder.
- 0:19 Fitting the sheets and making the PDF, sped up 4×.
- 0:31 Done: four landscape pages, one per week, all seven days and 22 staff on each, plus a note about roles that change between weeks.

What Stella does:

1. Finds the rota workbook in Documents: four sheets, one per week, 16 columns from Name and Role to Sun PM
2. Sets each sheet to landscape and one page wide, working on a copy so your spreadsheet's own print settings stay as they were
3. Makes one PDF of all four weeks and checks every staff member's row is on a page that also has Monday and Sunday
4. Saves Staff rota November.pdf next to the spreadsheet
5. Points out something in the data worth checking: some people's roles change week to week, which may be a typing slip

## The prompt to paste

```text
When I save my staff rota spreadsheet as a PDF the right-hand columns end up on separate pages. Make a PDF of it where each week fits across one page, with all the days together.
```

## Fit it yourself in Excel

1. **Check what's spilling.** Open File, Print and page through the preview. If the last columns appear on their own pages, the sheet is wider than the paper at 100% scale.
2. **Switch to landscape.** On the Page Layout tab, choose Orientation, Landscape. For wide sheets this alone often brings most columns back.
3. **Fit to one page wide.** Still on Page Layout, in the Scale to Fit group set Width to 1 page and Height to Automatic. Excel shrinks the sheet just enough for every column to fit across, and lets long sheets continue down onto more pages.
4. **Repeat on every sheet.** Page setup is per sheet. Click each tab and set it again, or select all the tabs first (right-click a tab, Select All Sheets) and change them together; ungroup afterwards so later edits don't go to every sheet.
5. **Export the whole workbook.** Windows: File, Export, Create PDF/XPS, Options, Entire workbook. Mac: File, Save As, File Format PDF, and choose Workbook. Open the PDF and check the last column is on every page.

## Where Stella stops

- Very wide sheets shrink a lot when squeezed onto one page. Here the smallest text was 8.2 pt; for something wider, Stella can say a sheet really needs two pages or suggest A3.
- Stella left the spreadsheet's own print settings alone. Ask it to change them if you want Excel's Print to come out the same way.
- The PDF is made on your computer; nothing goes to a converter site. Stella read the rota to check the PDF, so staff names went to the AI model you use.
- Recorded on Linux without Excel: Stella set the page layout on a copy and exported with the free LibreOffice. On Windows or a Mac it may use Excel instead, if you have it.

## Questions

**Why does my Excel PDF split columns onto separate pages?**
At 100% scale on portrait paper, the sheet is wider than the page, so Excel prints the overflow columns on their own pages after the rest. Landscape plus Fit to 1 page wide fixes it.

**How do I fit an Excel sheet on one page as a PDF?**
Page Layout, Scale to Fit: Width 1 page, Height 1 page. For long lists, keep Height on Automatic so the rows stay readable over several pages.

**Why is only one sheet in my PDF?**
Excel exports the active sheet by default. Choose Entire workbook in the export options, or select all the sheet tabs before saving.

**Can I combine the rota PDF with other PDFs?**
Yes, and you can put pages in any order after: see [reorder PDF pages](https://stella.sh/how/pdf-excel/reorder-pdf-pages). To send it as pictures instead, [convert the PDF to JPG](https://stella.sh/how/pdf-excel/convert-pdf-to-jpg).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft: Scale a worksheet](https://support.microsoft.com/en-us/Excel/scale-a-worksheet).

## Related problems

- [Convert a PDF to JPG, one sharp picture per page](https://stella.sh/how/pdf-excel/convert-pdf-to-jpg.md)
- [Reorder the pages of a double-sided scan and remove the blanks](https://stella.sh/how/pdf-excel/reorder-pdf-pages.md)
- [Change dates in Excel from US to UK when they come out wrong](https://stella.sh/how/pdf-excel/fix-dates-in-excel.md)
- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md)
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
