Convert Excel to PDF without the columns being cut off
A four-week staff rota as four landscape pages, every day of the week together.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 32 s in real time.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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×.
How Stella does it.
- Finds the rota workbook in Documents: four sheets, one per week, 16 columns from Name and Role to Sun PM
- Sets each sheet to landscape and one page wide, working on a copy so your spreadsheet's own print settings stay as they were
- Makes one PDF of all four weeks and checks every staff member's row is on a page that also has Monday and Sunday
- Saves Staff rota November.pdf next to the spreadsheet
- Points out something in the data worth checking: some people's roles change week to week, which may be a typing slip
The prompt.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.
Switch to landscape
On the Page Layout tab, choose Orientation, Landscape. For wide sheets this alone often brings most columns back.
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.
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.
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 it 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. To send it as pictures instead, convert the 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.
Checked against these sources on 13 November 2026.