Turn off collation permanently in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry
 
What is collation?
Do you reefer to the Print Option?
If so, Uncheck the Collate Box.

Menubar

File > Print...
 
Yes, I refer to this. I was wanting to know if there is a way to do this
permanently so that I don't have to uncheck that box every time.
 
Yes, I go to the Print dialog box and there is an option to uncheck Collate.
I was wanting a permanent way so that I don't have to uncheck this box every
time.

I was hoping that someone knew of a way to do this.

Sherry
 
It is interesting that the option does not stay off, at least until you close
Excel!!

There may be something in the registry(RegEdit.exe) but I could not find it.

Create a toolbar button
Record a macro then uncheck the Collate box.

Assign this genearated code to yor Toolbar button.


- Mark
 
Back
Top