by Allen Wyatt
(last updated December 22, 2018)
Jim noticed something frustrating when he was wrapping up a session with Excel. When he opens a workbook, everything is fine and works great. When he closes the workbook by clicking the close button at the upper-right of the program window, the workbook closes but Excel remains open. There is no workbook open at this point; only a blank Excel program window. He has to close it explicitly, which means an extra step when closing down Excel. He wonders if there is a way to make Excel close completely when he closes the last workbook on which he is working.
Before getting into theories and workarounds, it is good to review a bit about close buttons. Actually, in Excel 2007 and Excel 2010 there are two close buttons near the upper-right corner of the screen. One is red; if you hover the mouse over it, the ToolTip simply says "Close." This is the close button for Excel itself. The other is not red; if you hover the mouse over it, the ToolTip says, "Close Window." This is the close button to dismiss the document window.
In Excel 2013 and later versions this changed. There is now a single close button at the upper-right of the screen. Hover over it with the mouse and the ToolTip says "Close." In other words, Microsoft has done away with the "Close Window" button in later versions of Excel. Interestingly enough, the problem that Jim describes has also been done away with; it only exists in Excel 2007 and Excel 2010, and then only on some systems. (I verified this on several systems; the problem occurs when you click the Close button—the red one. On the last workbook, on some systems, it closes the workbook window, but leaves the program window open.)
The prevailing theory as to why this occurs in Excel 2007 and Excel 2010 is that Microsoft changed the way the Personal workbook was handled. As the story goes, since the Personal workbook is always open (even when it is hidden), the Excel program window stays open because Excel senses that a workbook (the Personal workbook) is still open.
Nonetheless, it is still frustrating. There is a way around it, but it involves changing how you close workbooks and the program. Instead of clicking on the close icon (the red X in the upper-right of the screen), use the following shortcut keys:
It is this second shortcut that is the handiest for shutting down Excel. It is interesting to note that in Excel 2013 and later versions these keys do essentially the same thing—they close one Excel workbook at a time. Even though both shortcuts close one Excel workbook at a time, Ctrl +F4 leaves Excel open while Alt+F4 closes Excel after the last workbook is closed. This is a completely different behavior than in earlier versions of Excel.
You could also try a modification on your red-X-clicking routine: Hold down the Shift key as you click. This modification has the same result as pressing Alt+F4, closing Excel and all open document windows.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11315) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
When you open a workbook, Excel examines that workbook to make sure it can understand the data it contains. This can lead ...Discover More
If you need to look at different parts of the same worksheet at the same time, the answer is to create windows for your ...Discover More
By using a command-line switch, Excel can be started in safe mode. This means that the program is loaded with bare-bones ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.