Skip to content

GuideMake and fix PDFs

Sheets

Sheets turns Excel workbooks into PDFs, spreading wide sheets over more pages rather than shrinking the text too small to read.

All chapters

When to use it

  • Ledgers, financial records or schedules that need to become exhibits or go into a bundle
  • A wide sheet that prints with text too small to read when Excel fits it to one page
  • A workbook with hidden rows, columns or sheets, where you need to know what is hidden
  • A workbook with many sheets when you only want some of them
The Sheets screen: workbooks checked, with a wide sheet spread over pages so its text stays readable.

Before you start

  • Desktop Microsoft Excel on this computer (Microsoft 365, Office 2021 or Office 2024). Sudex uses it in the background both to read each workbook’s sheets and to make the PDFs.
  • The workbooks: .xlsx, .xlsm, .xlsb or .xls, or CSV files.
  • Workbooks that need a password to open: save an unprotected copy in Excel first.

Step by step

  1. Open Sheets

    Click Sheets under MAKE & FIX PDFS in the side bar, or press Ctrl+8.

  2. Click Add spreadsheets

    Choose workbooks or CSV files, or drop them or a folder anywhere on the window. Sudex reads each one with Excel and lists every sheet, hidden and empty ones included; hidden sheets start unticked.

  3. Look over the sheets

    Click a workbook to open its sheets, and a sheet to see its first page, the size its text will print at, its smallest text and its pages, with a sentence on what was done. The strip at the top counts sheets that fit as they are, adjusted, and too small to read; All, Adjusted and Problems filter the list.

  4. Set the rules for every sheet

    With APPLY THESE SETTINGS TO on All sheets, work through Smallest text size, The page, If it still won’t fit, What goes in, Top and bottom of every page and What gets saved. Point at a choice to see it on the page before you click it.

  5. Set a sheet by hand if you need to

    Click Only the sheet I’m looking at to set that one sheet’s orientation, paper, margins and pages side by side, or switch off Include this sheet in the job. It stops following the rules until you click Put it back under the rules.

  6. Open Worth checking first

    The drawer at the foot lists sheets too small to read, sheets that run to 60 pages or more, hidden rows, columns and sheets, workbooks that link to other files, and any workbook that can’t be opened.

  7. Click Convert

    The button says how many, for example Convert 3 spreadsheets. Stop after this one finishes the file being worked on and then stops.

  8. Read the results

    Every workbook is accounted for: converted, couldn’t be, not reached, or left out by you. Read anything under NEEDS YOUR EYE, then click Open the folder, Send to… to put the PDFs into Bundle, Pages or Stamp, or Back.

Settings worth knowing

Smallest text size1
Never make text smaller than
A number, as % of normal size or pt type size; it comes set at 60%. A sheet that would need smaller text is spread over more pages instead.
The page7
Which way up
Portrait, Landscape, or Whichever fits (as it comes).
Paper size
A5, A4 (as it comes) or A3.
Space round the edge
Narrow, Normal (as it comes) or Wide margins.
Grid lines
Prints the cell grid lines. On to start with.
Row numbers and column letters
Prints Excel’s row numbers and column letters. Off to start with.
Black and white
Prints without colour. Off to start with.
Headings on every page
Find it (as it comes) finds the heading rows and repeats them on every page; No repeats none; As saved uses what the workbook says.
If it still won’t fit7
Trim the margins one step
Wide → Normal → Narrow. On to start with.
Spread over pages side by side
Cuts the sheet into columns of pages. On to start with.
Use a bigger sheet
A5 → A4 → A3. Off to start with.
Try earlier / Try later
The arrows beside each step change the order the steps are tried in; the switch turns a step off.
Most pages side by side
How many pages wide a sheet may be spread, from 2 to 10; it comes set at 2.
Order when it splits
Down, then across (as it comes) or Across, then down.
If it still won’t fit
Convert and flag (as it comes) converts the sheet anyway and flags it; Leave it out leaves it out and lists it.
What goes in5
Column widths
Fit to contents (as it comes) widens columns so nothing is cut off, stopping at 60 characters, after which text wraps; Fix #### only widens only columns showing ####; As saved leaves widths alone.
Fit row heights to their contents
On to start with, so a row is not cut off half way down.
Wrap all text
Wraps the text in every cell; turning it on also turns on Fit row heights to their contents.
Show hidden rows
Prints rows hidden in the workbook. Off to start with.
Show hidden columns
Prints columns hidden in the workbook. Off to start with.
Top and bottom of every page1
Change…
Click a box on the little page (left, middle or right, at the top or bottom), then type in it or pick Sheet name, File name, Page 1 of 10, Today's date or, when the job is filed under a matter, Matter name, and click Done. Nothing is printed there unless you put it there.
What gets saved2
Save as
One PDF per file (as it comes), One per sheet, or Both.
SAVE INTO
The folder for the PDFs; Converted, beside the first workbook, unless you click Change.
Only the sheet I’m looking at6
Which way up
Portrait or Landscape for this sheet only.
Paper size
A5, A4 or A3 for this sheet only.
Space round the edge
Narrow, Normal or Wide for this sheet only.
Pages side by side
How many pages wide this sheet is spread, from 1 to 10.
Include this sheet in the job
Switch off to leave the sheet out; it is still listed and reported.
Put it back under the rules
Shown once a sheet is set by hand; makes it follow the rules again.
⋯ menu (THE RULES)4
Make these my defaults
Every new list starts with these rules.
Back to my defaults
Puts your own saved rules back.
Back to how the program came
Puts the original rules back; sheets you set by hand keep their settings.
Clear the list
Takes every spreadsheet off the list. The files are not touched, and you can undo it.

What you get

  • One PDF per workbook, named after it (for example “Trust ledger.pdf”), or one per sheet named “Workbook - Sheet.pdf”, or both, in the folder you chose (Converted, beside the first workbook, unless you change it). A name already taken gets a number.
  • A results screen listing every workbook with the files saved and their page counts, any sheet that came out smaller than your smallest size, and anything else worth knowing.

What Sudex checks for you

  • Every sheet of every workbook is listed, hidden and empty ones too, so nothing in a workbook disappears without a word.
  • Each sheet is measured against your smallest text size before converting, and flagged Too small to read if the rules can’t get it there.
  • Hidden rows, columns and sheets, links to other files, and very long sheets are pointed out in Worth checking first.
  • Excel works on a temporary copy of each workbook, with macros disabled before it is opened, and links to other files are not refreshed.
  • Each original is read again afterwards to confirm it did not change.
  • Every workbook gets an outcome, and the results headline says “Nothing was skipped quietly.”

Tips

  • Point at any option and the page preview shows its effect, with a Preview badge; move away and it goes back. Nothing changes until you click.
  • The smallest text size is the setting that matters most. In the app’s words: “For 11 pt text, 70% is about 8 pt, the size of a footnote.”
  • Mail, Pages, Bundle and Stamp use the rules saved here with Make these my defaults for the spreadsheets they convert, not whatever is on this screen, so save good defaults.
  • Links to other files are not refreshed, so the PDF shows the values as last saved, which is usually what you want for evidence.
  • Chart sheets and macro sheets are not converted; if you need them, convert them from Excel directly.
  • A CSV file goes in as one sheet with every value exactly as written: “000123” keeps its zeros and long numbers are not turned into 1.23E+15.

If something goes wrong

A workbook won’t open

Read the line under it in the list. “… is locked with a password, so it cannot be opened without one” means: open it in Excel with the password, save a copy without one, and convert that. “Excel could not open '…': it looks damaged, or it is not really a workbook” means: open it in Excel to see whether Excel can repair it, and convert the repaired copy.

Nothing lists, or every workbook fails

If the reason is “Microsoft Excel is not installed, or its COM automation is not registered on this machine”, Sheets can’t work on this computer yet. In Settings, Microsoft Office on this computer shows whether Excel was found.

A sheet is marked Too small to read

Even with everything the rules allow, it can’t reach your smallest size. Try switching on Use a bigger sheet, allowing more pages under Most pages side by side, lowering the smallest size, or setting that sheet by hand. With Convert and flag it is converted anyway and flagged; with Leave it out it is left out and listed.

It says Excel opened the file in Protected View

The message is “Excel opened '…' in Protected View and would not export it.” Open it in Excel once, choose Enable Editing, save, and convert again.

Rows or sheets I can see in Excel are missing

They may be hidden in the workbook. Switch on Show hidden rows or Show hidden columns, or tick a hidden sheet in the list to include it. The workbook itself stays as it is.

Picture at full size