Setting Print Settings Across Entire Workbook
 

We have a new networked printer in our office and now we are having a problem
printing entire workbooks in color. It will not apply the default print
settings to all pages if it was printed on another printer first. The first
page will print in color but it does not appear to apply those settings to
each of the pages in the workbook. It looks like we have to go to each page
and change the printer settings to the new printer then re-save the doc so
the setting stay. Is there a way to apply printer settings to all pages in
the workbook automatically instead of having to go to each sheet then re-save
the document??? Any help is appreciated...Thanks

Answer: Setting Print Settings Across Entire Workbook
 

Yes, there is a way to apply printer settings to all pages in the workbook automatically. Here are the steps to do so:

1. Open the workbook that you want to set the print settings for.
2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
3. Click on the small arrow in the bottom right corner of the "Page Setup" group to open the "Page Setup" dialog box.
4. In the "Page Setup" dialog box, click on the "Print" tab.
5. Under the "Print Quality" section, select the desired print quality and color options for your printer.
6. Click on the "OK" button to apply the changes to the current worksheet.
7. Now, to apply these settings to all worksheets in the workbook, right-click on any worksheet tab at the bottom of the screen.
8. Select "Select All Sheets" from the drop-down menu.
9. Repeat steps 2-6 to open the "Page Setup" dialog box and apply the print settings to all worksheets in the workbook.
10. Click on the "OK" button to save the changes.

Now, all worksheets in the workbook should have the same print settings applied, and you should be able to print the entire workbook in color without having to change the printer settings on each individual worksheet.

Setting Print Settings Across Entire Workbook
 

Select the first sheet in the workbook, hold down the [Shift] key and select
the last sheet in the workbook (you can scroll over to the last sheet if it
is waaaayyy over and then hold the [Shift] key down when you select the last
sheet). All sheets in the workbook will then be selected. Set up your
printer settings. Then click on any sheet to ungroup the sheets. I believe
that'll do it for you.

I actually had never realized until now that individual sheets were 'printer
independant' - go figure. But considering the way that excel is often used
for a variety of content on various pages, I suppose it makes some sense.

""Nia"" wrote:

We have a new networked printer in our office and now we are having a problem
printing entire workbooks in color. It will not apply the default print
settings to all pages if it was printed on another printer first. The first
page will print in color but it does not appear to apply those settings to
each of the pages in the workbook. It looks like we have to go to each page
and change the printer settings to the new printer then re-save the doc so
the setting stay. Is there a way to apply printer settings to all pages in
the workbook automatically instead of having to go to each sheet then re-save
the document??? Any help is appreciated...Thanks

Setting Print Settings Across Entire Workbook
 

Nia

Some print setup features can be set with the worksheets "grouped".

Right-click on a sheet tab and "select all sheets"

Then set up the active sheet and all sheets will receive same setup including
printer choice.

EXCEPTIONS..............

Print Range cannot be set on grouped sheets.

Rows to repeat at top cannot be set on grouped sheets.

To set these two items on all sheets would require VBA code.

If interested in some code, post back.


Gord Dibben MS Excel MVP

On Tue, 19 Dec 2006 12:55:00 -0800, "Nia" wrote:

We have a new networked printer in our office and now we are having a problem
printing entire workbooks in color. It will not apply the default print
settings to all pages if it was printed on another printer first. The first
page will print in color but it does not appear to apply those settings to
each of the pages in the workbook. It looks like we have to go to each page
and change the printer settings to the new printer then re-save the doc so
the setting stay. Is there a way to apply printer settings to all pages in
the workbook automatically instead of having to go to each sheet then re-save
the document??? Any help is appreciated...Thanks

Gord Dibben MS Excel MVP