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?)
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, it's another “Where Is It Wednesday”.
Want to send thanks to George Wood for that great “Where Is It Wednesday” theme.
Today, it's just a tiny one that's driving me crazy.
Up here in the upper right-hand corner we have two X's, and for the longest time, all previous versions of Excel, hitting this X would close the workbook but keep Excel open; and hitting this X would close Excel.
Well, now, for some unknown reason, they made both of these X's do the exact same thing.
So, if I hid the upper workbook-- right now I have 10 books open, Book 1 through Book 10-- if I hit the upper X, in the old Excel that would close Excel; but now it just closes Book 10 and it does not close Books 1 through 9.
Well, you could always go to the Office button and choose Exit Excel.
Couple of clicks here-- here's a great undocumented trick what we can do-- is just go to that Office button and double-click-- double-click.
Excel, basically, now is trying to close the application.
Now I have some unsaved documents here and it's going to ask me for each one-- do you want to save it or not.
It's always frustrating to me that we have "Yes", "Yes To All", but there's no "No to all".
Another cool trick: Hold down the Shift key when you click "No"-- that's basically like saying "No to all"-- and we're out of Excel very, very quickly.
So if you're trying to figure out how to close Excel like we've been able to do for the last 20 years, in Excel 2007, instead of going to the top right, go to the top left and just double-click.
How were we ever supposed to figure that one out?
Don't know.
Alright, I want to thank you for stopping by, i'll see you next time for another netcast from MrExcel.
Well, it's another “Where Is It Wednesday”.
Want to send thanks to George Wood for that great “Where Is It Wednesday” theme.
Today, it's just a tiny one that's driving me crazy.
Up here in the upper right-hand corner we have two X's, and for the longest time, all previous versions of Excel, hitting this X would close the workbook but keep Excel open; and hitting this X would close Excel.
Well, now, for some unknown reason, they made both of these X's do the exact same thing.
So, if I hid the upper workbook-- right now I have 10 books open, Book 1 through Book 10-- if I hit the upper X, in the old Excel that would close Excel; but now it just closes Book 10 and it does not close Books 1 through 9.
Well, you could always go to the Office button and choose Exit Excel.
Couple of clicks here-- here's a great undocumented trick what we can do-- is just go to that Office button and double-click-- double-click.
Excel, basically, now is trying to close the application.
Now I have some unsaved documents here and it's going to ask me for each one-- do you want to save it or not.
It's always frustrating to me that we have "Yes", "Yes To All", but there's no "No to all".
Another cool trick: Hold down the Shift key when you click "No"-- that's basically like saying "No to all"-- and we're out of Excel very, very quickly.
So if you're trying to figure out how to close Excel like we've been able to do for the last 20 years, in Excel 2007, instead of going to the top right, go to the top left and just double-click.
How were we ever supposed to figure that one out?
Don't know.
Alright, I want to thank you for stopping by, i'll see you next time for another netcast from MrExcel.
