Tables in Agendas and Minutes

Before you start: which problem do you have?

Both problems below come from the same root cause — spreadsheets aren't designed for a fixed-width printed page, and pasting one directly into agenda or minute text asks the editor to squeeze something onto paper that may not have been composed with paper in mind. But they look different, and need different fixes:

• The whole table is unreadable, cramped, or breaks awkwardly across the page → this is Problem A: the table is too large or complex.
• One column (usually the first) has become far wider than it should be, squashing everything else → this is Problem B: a title row was included in the copy.

If you're not sure which you're looking at, check the first column specifically. If it's the odd one out, it's almost always Problem B.

Problem A: the table is too large or complex

What you'll see: a pasted table that's technically there, but unreadable once published — too many columns to fit the page width, text so small it's unusable, or a table that breaks across pages in a confusing way.

Why it happens: the text column in an agenda or minute item is sized for a printed page, in the same way as the rest of the document. A spreadsheet with a dozen columns of financial figures, or a dense schedule, was never designed to fit into that space. No amount of column-width adjustment inside the editor will make a genuinely large table readable at that width — it needs to be handled differently, not reformatted smaller.

The fix: export the table as a PDF and attach it, rather than pasting it as text.

1. In Excel, select the print area you actually want to include (use Page Layout > Print Area > Set Print Area if you only want part of the sheet).
2. Adjust the page setup so it prints sensibly — landscape orientation and "Fit to 1 page wide" are usually worth trying for wide tables (Page Layout > Page Setup). Alternatively export to multiple pages.
3. Export it: File > Export > Create PDF/XPS, or use Print, choosing a PDF printer as the destination.
4. Save the resulting PDF somewhere you can find it.
5. On the agenda item, attach it as a paper or annex rather than pasting the table into the item text — see Adding Papers and Annexes.
6. In the item text itself, add a short line pointing to it — something like "See attached financial summary" — rather than trying to reproduce the table inline.

As a rough guide: if a table has more than four or five columns, or more rows than would comfortably fit on a single page at a readable size, treat it as a candidate for this approach rather than pasting it directly.

Problem B: a title row was included in the copy

What you'll see: a pasted table where one column — usually the first — has become much wider than its actual content needs, pushing the rest of the table out of shape.

Why it happens: in Excel, a long title typed into a single cell (e.g. cell A1, spanning what looks like the whole table width) will visually spill over into the empty cells beside it, as long as those cells are empty. It looks like the title spans several columns, but as far as Excel is concerned, it's still just one cell with a lot of text in it. When that selection is pasted into the editor, only the real cell boundaries are respected — so the editor sizes that first column to fit the full length of the title, since that's genuinely what's in the cell. The visual illusion Excel was giving you doesn't survive the paste.

The fix: don't include the title row in what you copy.

1. In Excel, select only the actual data — start your selection from the real header row (the one with individual column headings), not the title row above it.
2. Copy and paste that selection into the agenda or minute text as normal.
3. Add the title separately, as its own line of text directly above the pasted table (a heading or bold line works well) — not as part of the table itself.

This keeps the title visible to anyone reading the published agenda or minutes, without it distorting the table's column widths.

A quick checklist before you paste

• Keep pasted tables small — a handful of columns and rows that will comfortably fit a printed page. Anything larger belongs in an attached PDF, not pasted text (see Problem A).
• Never include a title or heading row in what you copy from Excel — copy from the real column headers downward, and add any title separately (see Problem B).
• When in doubt, paste a small test table first and check how it looks before committing a large or complex one.