Can Excel settings default to always print entire workbook?

G

Guest

I have an Excel form that I use daily. It has 3 worksheets that when
printing, I want to print them all automatically. I cannot find a setting
other than in the Print (Ctrl+P) window that indicates what we want to print
(i.e. entire workbook).

Are there any settings that I can set so that it always prints the entire
workbook?

We are on Excel 2003 SP2
 
G

Gord Dibben

Evie

There is no default setting for entire workbook.

I would turn on the macro recorder when doing the File>Print>Entire workbook
then assign that macro to a button or shortcut key combo.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Entire Workbook acting strangely 1
Duplex Printing of Workbook with multiple worksheets 2
Print Entire Workbook 3
Printing a workbook but not getting page set-up results 1
Not printing the entire workbook 2
undesired "breaks" between worksheets 1
print entire workbook default 3
Set the print order of worksheets when printing entire workbook 2

Top