Selecting 'collate' as default (Excel 2007)
 

Does anyone know if there is anyway to select €˜collate as default within the
print dialogue box? I find that on some sheets its set and others it isnt
(always the same sheets are or are not selected) and while in the grand
scheme of things its not insurmountable to click a box (or €˜Alt+O), when
Im quickly flitting from tab to tab using €˜Ctrl+P and then entering the
number of copies it means another keystroke to set it to collate €“ and then I
find Ive accidentally switched off collate on the odd sheets that the box is
checked!