Hello
I print a grid of 3x3 cells on a pre-printed sheet of letter sized paper. Sometimes I need to print less than 9 cells and hate using a whole sheet for a couple of cells.
I think if I create custom size paper, I would be able to print 1 or 2 rows (3 or 6 cells), and save the rest of the paper for another day.
Any help on how to create and use the 5.5x11" paper size?
Thanks!
John
I am not sure that I fully understand what you intend as the measurements don’t seem to match the question.
However, click Format > Page Style select the tab Page and enter the width and the height that you want.
When you create a custom page size, that will use same area of the Letter or A4 size paper again and again. But you can rotate the paper in the printer. Then you can use 4 areas (2 on the one side and 2 on the another side) of the paper.
.
.
Here is a silly tip for using more areas on the paper:
Use a full size of the (A4) paper, and create a “ToPrint” sheet, with referenced data to print and wirh an offseted printing area.
Use macros to create a new “PrintRange”, or for inserting empty rows and/columns before the non-empty cellrange. In this case you will able use the empty areas of same paper.
(Use a helper DateTime cell in the cell range to recognise the last printed data.)