Avatar of lianne143
Flag for United States of America asked on

How to spread the information to A3 and A4 paper in excel 2016


I have a excel sheet with data on it and would like to print in A4 and A3. When go to file print and preview selecting A4 , it has all the information , but shrinked to 70% of the A4 page.
If I select the A3 paper only 50% of information is shrinked  to this A3 page.

Is it possible to spread all the information across the A4 and A3 paper and are there ay settings that I need to do.
Printers and ScannersMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Owen Rubin

8/22/2022 - Mon

You can always force the information on the page (obviously will be printed much smaller). On the Excel sheet itself, set the print area before printing.
During the print dialog, select Print Selection to your selection and in the bottom, Fit Sheet on One Page.

I'm guessing that Excel has a Print Area set from the first print you did. Try clearing it, by clicking the Page Layout tab, then Print Area > Clear Print Area.

While you are at the Page Layout tab, also set the paper size by clicking the Size button. If the paper orientation is wrong, set it there, too.
Owen Rubin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes