• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Pros needed...

T

trigun500

Golden Member
Where I work there are times when I have to build files. Most of these files are from Excel workbooks. These workbooks have over 50 sheets within them. The problem I run into is when it comes time to print. Most (if not all) of the sheets do not fit on a single page. So the way they showed me how to fix this is go to print preview and any spread sheet that cuts over to two pages I have to reformat it to fit one page. So I spend almost 15mins per workbook making it so the sheets fit on one page. Is there a single step process where I just tell Excel to fit ALL sheets onto one page? Just so they don?t cut over.

Thanks for any help!
 
yes but it involves a little bit of work on your part. Probably about 3-4 mins?? maybe.

Anyways, here goes:

You can select the area you want to print on Sheet 1 and Click "Set Print Area". Depending on which Excel version you are using, this is normal found near the Print menu command.

Then move to Sheet 2 and select the area you want to print and do "Set Print Area". Continue until you have this for the whole workbook.

Then do Print Preview and say "Fit on # of Pages by # of Pages" ..landscape or Portrait mode and that should print all sheets on the respective pages.
 
WildViper is correct. However, you may not need to set the print area on every sheet. If you need to print everything in every sheet, then you do not need to set the print area. Just click on the first sheet tab and the Shift+click on the very last one to select all sheets. Now, go to page setup and set the sheets to print all on one page. That setting will be for each worksheet as you can confirm by doing a print preview. This will take all of 30 seconds at the most.
 
And you can save 15 seconds of clicking on each of the 50 tabs by just clicking the first one and then holding Ctrl + Shift + PgDn to select all the other tabs
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top