I'm not aware of a default setting in Excel for this and neither am I aware
of a central setting for Office applications, which is what led me to surmise
that it would be a setting within your printer driver's software. If your
printer is capable of collation (which it obviously is) then I'm very
surprised that it doen't appear as a selectable option somewhere. I don't
have access to your particular printer software, but have you checked the
various "options" and "advanced" settings in the properties?
Is it possible that you're saving this setting in your templates because
you're basing each one on a previous one that had the setting? Try setting up
a new template and then go to File¦Page Setup and Options (if it's available)
and make sure all the selections are as you want them before saving the
template.
If all else fails, do you have a manual for the printer? If you haven't, an
online version is available at
http://h10032.www1.hp.com/ctg/Manual/c00264442.pdf.
Sorry, but can't seem to help any further at the moment.
Regards
"dogmelissa" wrote:
I just checked in there, and collate isn't an option in my printer set up. :(
It seems to be program-specific, as when I print web-pages this option is
defaulted to off. It is turned on in *all* office applications, however.
Maybe I should post this in the general Office category.
Can you think of anything else I can try?
Thanks,
Melissa
"toni.gee" wrote:
The collate option is probably set as the default for your printer setup. Go
into Printers and Faxes in Control Panel and check the properties of your
printer - uncheck the collate option if it is selected and your printer
should print without collating unless you tell it otherwise.