Print just the table
Set the print area to A1:H50, center it on a landscape page, then ask before printing.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Print area A1:H50
- Landscape, fit to page
- Center on the page
- Ask “Print it now?”
- Print the sheet
Use it in MacroRoni: open the Starter gallery, search for "Print just the table", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More print & share macros
Print & sharePrint on one pageLandscape, narrow margins, centered, with gridlines, the header row on every page and page numbers.Doesn't change valuesPrint & 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 values