Formatting Worksheets for Printing in Excel

In Excel, I'd like to print more than one worksheet (from a workbook) on a
single page - how can I do this?? Thank You

How do I print multiple worksheets (from one workbook) on one page in Excel?

hello there,

I have an issue when printing multiple excel worksheets in colour. I'm using Excel 2003.


The default driver setting for our printer is set to Black & White although it can do both colour and B & W. When trying to print multiple worksheets in a workbook if you go to the printer properties and change the setting to colour only the first sheet prints in colour the rest comes out as B&W.

It appears that the only method for printing all worksheets in colour is to select each worksheet individually and change its properties to colour. This is quite frustrating if you have a large workbook.

I have tried different print setting and worksheet options of selecting all worksheets together and grouping them or using the 'entire workbook' button.

Any advice or possibly scripts to overcome this would be appreciated.

thanks

I have an excel file with 42 worksheets. Each worksheet has several rows &
columns & their graph in the same spreadsheet. I cannot print all of them in
one go with their graphs(like one page of calculation & one page of graph.

I often need to print an Excel worksheet many rows (a few hundred) long but only a few (2 or 3) columns wide. Is it possible to print the "pages" side by side on one sheet of paper?

Same applies to very wide but short sheets - can they be printed below one another on the same sheet?

For this workbook, I'm attempting to get the values for each individual month to show as red if they are +-10% from the average for that value and green if the value is between the 10% threshold. I know that you can get around the limitations of Excel 2003 by naming each individual cell on the average sheet and then having the conditional formatting refer to those names, but I was wondering if there is an easier way to get this to work with a macro. The way that I had been doing it has me editing each individual cell due to the unique names and it was taking forever to get anything done. I have attempted to get something made, but I'm not very familiar with VBA at all. Any help would be greatly appreciated.

I have a workbook with 16 tabs. I want to select all the tabs and print to a pdf. When I do so by selecting the first and last tab and ensuring all are highlighted the conversion to pdf "chops up" the 16 tabs into uneven sections and forces me to re-save to the desired pdf as it goes along. Ideas?

Thanks

Good morning,

If you have a spreadsheet with 30 workbooks and there are always say 5 you want to print, is there a way of setting it up so when you hit print all five are printed?

Regards,

Jiminio

I have a excel file that has about 20 worksheets and want to print certain worksheets at one time. Each time will be different. Is there a way to print these using a macro or something else, so I do not have to select the worksheet tabs.

Hi,
I have an Excel 2003 Workbook with over 100 worksheets.
Each worksheet has 5 pages printable.
Is it possible to automate printing these pages double sided, with each worksheet starting on a separate page, and stapled?
Ta
Charlotte