Once re-sized it should remain at that size.

If not, I have no ideas for you.

It is a global setting and not saved with each workbook.


Gord

On Tue, 2 Jun 2009 10:01:01 -0700, Clee
wrote:

can it be formatted to stay the smaller size? I keep having to reduce it and
it is annoying


"Gord Dibben" wrote:

Excel 2007?

Sort Dialog box can be reduced to about 3 inch by 6 inch at smallest.

Use sizing arrows to bring down to that size.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 09:27:01 -0700, Clee
wrote: