Excel Sort Window Gets Big

[djgonzales]

I've got Excel 2007 at both work and home and both have this weird thing. The
Sort Data dialog box gets bigger each time you open it until it fills the
entire screen. I've got 20" and 22" screens and that's pretty big for
sorting! It doesn't matter if I reload the program. It doesn't matter if I
drag the box to it's original size. It just keep getting bigger.

Is there a fix?

 

[Shane Devenshire]

Hi,

could it be related to Large Fonts? That's usually my
first guess when it's a problem like this...

Try changing your computer back to normal fonts, and the Sort Dialog
stopped growing. This definitely appears to be a bug in Excel 2007. The only
places I can find the problem are the sort and remove duplicates, which
appear to be about the only simple resizable dialog boxes in Excel. (not
counting charts)

So it sounds like a bug in the routine that saves the dialog box
size/location when there's non-standard DPI...

 

[djgonzales]

I just found another thread that said the same thing. But, I've not changed
font size on my home edition and when I looked at the control panel -
appearance, it showed normal font.

Would I change the fonts somewhere else?