Excel Pros needed...

[trigun500]

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!

 

[trigun500]

ttt

 

[WildViper]

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.

 

[mayest]

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.

 

[petesamprs]

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

 

[trigun500]

I love you guys