Sorting Dialog box keeps growing

Hello All..

I have only one user who has this problem.

She is on Excel 2007 on Win XP (1024/768 monitor resolution, 15 inch monitor)
Each time she opens and closes the Sort dialog box, the dialog box gets bigger when reopened.

This means that by the 3rd or 4th time she opens it, it is so large that she cannot get to the edges of the dialog box to make it smaller.

Odd that this only happens with only the sort dialog box... ..

Any Ideas?


LVL 74
Jeffrey CoachmanMIS LiasonAsked:
Who is Participating?
ShannonCallahanConnect With a Mentor Commented:
Try this:

(1)    Right click on your desktop and select “Personalize”

(2)    When the “Personalization” dialog box open, click on “Display” in the bottom left hand side of the dialog box

(3)    When the “Display” dialog box opens, check the size of text that you have selected

(4)    If you have selected “Medium – 125%” or “Larger – 150%” then change it to “Smaller – 100% (default”)

a.      Click the “Apply” button

b.      Logoff and re-logon to your computer for the settings to take effect

c.      Run Excel and see if this fixes your problem

(5)    If you already have “Smaller – 100% (default”) selected then this solution won’t help.


Jeffrey CoachmanMIS LiasonAuthor Commented:
Will try now,,...thanks
Jeffrey CoachmanMIS LiasonAuthor Commented:
Took a while to find the corresponding settings in Win XP, ...but I found it and set it to: 96 DPI, Standard, ...
...and it worked... ;


Jeffrey CoachmanMIS LiasonAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.