Selecting 'collate' as default (Excel 2007)

T

Thistledown

Does anyone know if there is anyway to select ‘collate’ as default within the
print dialogue box? I find that on some sheets it’s set and others it isn’t
(always the same sheets are or are not selected) and while in the grand
scheme of things it’s not insurmountable to click a box (or ‘Alt+O’), when
I’m 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 I’ve accidentally switched off collate on the odd sheets that the box is
checked!
 

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

Top