Look Who it Was Random video

Excel - The "X" for Close Excel now closes just the workbook. How to Close Excel? - Episode 833

311 views · Published 9 January 2009 · 2:23 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: The "X" for Close Excel now closes just the workbook. How to Close Excel?
Welcome back to another episode of the MrExcel netcast! I'm Bill Jelen and today we're tackling another "Where Is It Wednesday" challenge. First off, a big thank you to George Wood for the awesome theme song for this segment. Now, let's get into the issue at hand.

There are two "X" icons in the top right corner of Excel. Way back in Excel 2003, the top one closed Excel and the bottom one closed the current workbook. Today, both Close the Current Workbook. How are you supposed to close Excel?

In previous versions of Excel, clicking the X in the upper right-hand corner would close the workbook but keep Excel open. However, in Excel 2007 and newer versions, both X's now have the same function - closing the workbook. This can be frustrating when you have multiple workbooks open and only want to close one. But don't worry, I have a solution for you.

Instead of clicking the X in the upper right-hand corner, go to the Office button in the top left and double-click it. This will prompt Excel to close the application, giving you the option to save any unsaved workbooks. But here's a cool undocumented trick - hold down the Shift key while clicking "No" to quickly close all unsaved workbooks. No more clicking "No" for each individual workbook.

Now, I know what you're thinking - how were we supposed to figure this out? Well, I don't have an answer for that. But I hope this tip helps you save some time and frustration when trying to close Excel. Thanks for tuning in to the MrExcel netcast, and I'll see you next time for more helpful tips and tricks. Don't forget to subscribe and hit that notification bell to stay updated on all our latest videos. See you soon!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Back in the good old Excel, you could click the upper "X" in the top right corner to close Excel. Well...that does not work anymore - both of the "X"s will close the workbook. In Episode 833, I will show you the quick way to close out of Excel. (Maybe you work at a dot-com, and your manager would be upset if you were doing spreadsheets instead of playing solitaire?)

Table of Contents:
(00:00) Introduction
(00:28) "Where Is It Wednesday" theme
(00:38) Issue with closing workbooks in Excel 2007
(00:52) Alternative method for closing Excel
(01:05) Undocumented trick for closing Excel quickly
(01:38) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Close Excel in Excel 2007
Close Excel with X button
Close workbook keep Excel open
Double-click Office button
Excel X button
Exit Excel
No to all option in Excel
Office button
Save unsaved documents in Excel
Shift key to close Excel quickly
Where Is It Wednesday

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152041/

More from this channel