data sort box too big-can it be formatted

[Gord Dibben]

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

 

[Clee]

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

 

[Gord Dibben]

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

 

[Shane Devenshire]

Hi,

In case this didn't get through before

1. Please enter a quesion in the body of your emai; if you don't the web
won't let us reply, instead it displays the following error message.

"An error occurred while sending your post

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

This means, that to respond we need to start a separate thread - which is a
bad practice and wastes time.

===============
The sort dialog box starts out at its minimum each Excel session and is
remembered during the session. To make the window appear smaller you can
increase your screen resolution or get a bigger monitor.