Trying to Exit MS Excel 2007

Dennis Faas's picture

Have you noticed that when you try to close MS Excel 2007 by clicking the little red 'x' in the upper right-hand corner that it just closes the workbook but not the application?

Well, you aren't the only one who has been aggravated by having to click the red x twice to actually close the application.

I have researched this behavior and have found out that this phenomenon usually occurs when you are using hidden workbooks or have a hidden workbook open. If all of your open workbooks are unhidden, you don't seem to have a problem using the quick method of clicking the red x.

So, once again, I went searching for an answer to thwart this behavior.

What I have found is that if you want to keep using that quick exit with the red x, the QAT (Quick Access Toolbar) will save the day for you.

Follow the steps below:

  • Click the down arrow at the right of the QAT and select More Commands toward the bottom.
  • Select All Commands in the Choose commands from field.  
  • Scroll down and find the Exit command.  
  • Use the Add button in the middle to place the command on the list for the QAT on the right.   You can then use the up and down buttons on the far right to place the command in the are where you want.  
  • Click OK.

Now, the next time you have hidden workbooks and try to exit MS Excel 2007, simply click the Exit button on the QAT instead of the red x and you will only be using one click!

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
Average: 5 (1 vote)