collate alwyas ticked in print dialog

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

How do you get collate to stay unticked in the Print dialog in Excel ?

If you untick it in Word it stays unticked but in Excel it stays
ticked the next time you use Print even if it's during the same
session let alone the next time you use Excel or load a particular
file. We'd like collate to be normally off, not on.

Rob
 
AFAIK, you can't change this default setting in Excel. You could record
a macro that sets Collate to False, and prints the file.
 
Thanks Debra. I was beginning to expect that answer. It does seem a
rather stupid design decision, if it was a decision at all. Just
another example of how inconsistent Office programs still really are
in funny little ways and after all the versions we've had.
 

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

printer collate box unchecked in excel 1
Change default print settings Excel 2007 6
Printer Collate 4
How can I get Excel to NOT collate when printing. Unchecking col. 1
Print pages in collated order 3
Collate box in print dialoge box 1
print 2 sheets on one paper 5
Word documents won't collate, even though collate box is checked. 1

Back
Top