Forum Discussion
How to fit data to a certain size while also ensuring all columns are included on each sheet
I'm trying to create a template that would fit some data into an 8 inch by 8.75 inch square while printing on standard 8.5x11 paper. I also need to somehow ensure that everything scales properly so t...
If you set the margins of the page you should be able to define the square within which Excel prints. To get all columns and an unknow # of rows, on the page setup dialog, select the "Fit to" option, enter 1 in the first box and leave the second box empty. It'll take some trial and error to get the print the way you like. Also, don't count on the same result if you print this from another computer or on a different printer.