Using Excel for Layout and Printing

I'm a graphic designer with a few years of experience incorporating Excel content in design layouts, and for the first time I've been asked to use Excel to layout content. The client has a complicated spreadsheet that works as an interactive form, taking responses and running them through a hidden page of secret-sauce analytics before outputing results to a final report.

The thing is, they are hoping to use it in person with clients on an iPad, and then also print out all of the individual pages as a consistent-looking booklet.

I can make an excel page look good, but the printing just isn't going according to plan. When I go to print it distorts the pages. I can resize it to print, but then it doesn't work onscreen so well. And that's for one page: in a best-case scenario I'd need all of the pages to work for print and screen AND use the same scale so that they all look uniform.

Anyone have any pro tips on how to use Excel for clean, consistant page layouts?

Thanks,

-Calvin

There is an option under scaling to have it fit 1 page wide by 1 page high. Try that and see if that works for you.

Thanks for the response pboost,

Thats what I'm doing now, the trouble is that the different pages are different sizes and have different amounts of content. I want them to all print the same, so that the scale never changes.

I suppose my question is, how to set the same print area for every page when the pages are different so the scale is uniform?

If you are saying this as an example

Sheet 1 has 3 columns, sheet 2 has 5 columns, and sheet 3 has 10 columns, then for the same scaling, the other sheets have the same amount of columns. (example sheet 1 has 10 columns, sheet 2 has 10 columns, and sheet 3 having 10 colums).

Easy way of expanding without messing the formulas up is to insert a column. Without seeing a sample of what you are working on makes it a bit difficult to gauge what is going on.