MacroRoni

Starter macros › Print & share

Print on one page

Landscape, narrow margins, centered, with gridlines, the header row on every page and page numbers.

Formats, highlights or saves files. Doesn't change your values.

What it does, step by step

  1. Landscape, fit to page
  2. Narrow margins
  3. Center on the page
  4. Print gridlines
  5. Repeat row 1 on every page
  6. Footer “Page &P of &N”

Use it in MacroRoni: open the Starter gallery, search for "Print on one page", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

More print & share macros

Print & shareSheet name and page numbersPrint the sheet name at the top and “Page 1 of 3” at the bottom of each page.Doesn't change valuesPrint & sharePDF with page numbersAdd page numbers, fit the page, and save the sheet as Report.pdf next to the workbook.Doesn't change valuesPrint & shareClean, then export CSVRemove extra spaces and hidden characters, then save the sheet as Export.csv.Changes data · backup on