Question 1

How to convert an Excel spreadsheet to PDF that actually fits

Accepted Answer

Set a print area, then use Page Layout → Scale to Fit with Width set to 1 page and Height left on Automatic. Add repeating header rows through Print Titles, switch to landscape for wide tables, and export with File → Export → Create PDF/XPS. Never set both Width and Height to 1 page.

Question 2

How to add page numbers to a PDF

Accepted Answer

To add page numbers to a PDF, open it in a page numbering tool, pick a position such as bottom centre, choose a format such as "1 of 12", set the starting number, and say how many opening pages to leave unnumbered. The numbers are drawn onto each page and cannot shift later.

Question 3

How to add a header or footer to a PDF

Accepted Answer

To add a header or footer to a PDF, open it in a header and footer tool, type the text for the left, centre and right positions, set a margin of about 36 points from the paper edge, then apply it to the pages you want. Headers and footers are drawn onto each page as real text.

Question 4

How to make a weekly meal plan and shopping list you can print

Accepted Answer

Build a one-page plan with seven day columns and rows for the meals you actually plan, put an aisle-grouped shopping list on the reverse, and merge the week's recipes into a single PDF behind it. Print one copy for the fridge and one for the shop.

Page Numbers

Guides that use this tool