Double Click to Exit?

Double Click to Exit?

Are you currently using MS Excel 2007?

Do you sometimes notice that when you click the red X in the upper right corner of the title bar, Excel simply closes the workbook, but leaves the program running?

You’ve probably found that you actually have to click the red X again to get out of Excel, right?

Well, I don’t know about you, but that drives me crazy! I liked the quick escape hatch better. You know, you click the red X and Excel closes everything, asking you what to save along the way. So, what was the problem?

Well, after quite a bit of experimenting, I finally stumbled upon the reason for this weird behavior.

It seems I only experience this problem when I have a hidden workbook. When I use the red X while a workbook is hidden, the program doesn’t close with just one click. But, if all the workbooks are unhidden, it functions just as it always did.

So, it seems your only recourse is to never keep a workbook hidden. Or, is it?

I found that, once again, the Quick Access Toolbar saves the day!

If you use hidden workbooks and still want a swift exit, give this a try.

First, click the down arrow to the right of the Quick Access Toolbar and choose More Commands at the bottom. You’ll then be taken here:

Choose All Commands in the Choose commands from field.

Scroll down and find the Exit command.

Use the Add button in the middle to move it to the command list for the Quick Access Toolbar on the right.

You can then use the up and down buttons on the far right to place the command in the location you desire.

When everything looks good to you, simply click OK.


So, the next time you have hidden workbooks and try to exit Excel, just click the Exit button on the Quick Access Toolbar instead of the red X and you’ll be out of there with just one click!

~ April

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.