I want to select a group of cells, add a header, select portrait/landscape, fit the cells to 1 sheet of 8.5x11 paper, preview and print.
I find myself jumping between printer settings preview and print.
What is the sequence of operations to doperform this function?
This answer only works for 1 page:
Set the print range for the cells you want to print.
select page size for paper size, orientation, and margins
Select Header and enter the data NOTE Header is 0.5 inches fixed.
on the print preview you can select zoom to fill the page.