In Excel 2007, Microsoft has changed the behaviour of the X used to close the application. In Episode 646, I show you how to use the customize button to add a true Close Application button to the QAT.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey welcome back to the MrExcel netcast. I'm Bill Jelen.
Today, we have a question that was asked by Rich.
Rich in UK. Rich's upgraded to excel 2007 and noticed one very maddening thing, that's different from excel 2003 to excel 2007.
Let's look up here in the upper right hand corner of the excel window.
You see that we have 2 x.
The x that typically is close window, which will close the current file, and then the x which is typically close application.
Normally in excel 2003 if we would press close application it would close all the files.
It might ask us whether we want to save the changes or not.
But what's happened in excel 2007 is they've made both of these x's do the exact same thing.
So we press the top x, the close application and it asks if we want to save the current book, but closes the current book it does not however, close excel. Very very maddening that we don't have a real x that will close excel so the solution to this, is if we go to the office icon in the top left hand corner, you'll see that there's a button there for "Exit Excel" This is really the button that we need but they've hidden it away down here.
You know in the menu. What I'm going to do is right click and say "Add to Quick Access Toolbar" and you'll see that we now have an x up here in "Quick Access Toolbar".
This is the only thing that you can easily customize in excel.
So now if we have a new workbook Maybe I create some data there and I want to close excel, closing all of the open workbooks.
Now use this x instead of the x in the upper right hand corner.
A little bit maddening that microsoft changed this behavior, but by using the customized feature in excel 2007, you can very easily, close all the open workbooks and close excel.
Hey thanks for stopping by. We'll see you next time for another netcast from MrExcel.
Today, we have a question that was asked by Rich.
Rich in UK. Rich's upgraded to excel 2007 and noticed one very maddening thing, that's different from excel 2003 to excel 2007.
Let's look up here in the upper right hand corner of the excel window.
You see that we have 2 x.
The x that typically is close window, which will close the current file, and then the x which is typically close application.
Normally in excel 2003 if we would press close application it would close all the files.
It might ask us whether we want to save the changes or not.
But what's happened in excel 2007 is they've made both of these x's do the exact same thing.
So we press the top x, the close application and it asks if we want to save the current book, but closes the current book it does not however, close excel. Very very maddening that we don't have a real x that will close excel so the solution to this, is if we go to the office icon in the top left hand corner, you'll see that there's a button there for "Exit Excel" This is really the button that we need but they've hidden it away down here.
You know in the menu. What I'm going to do is right click and say "Add to Quick Access Toolbar" and you'll see that we now have an x up here in "Quick Access Toolbar".
This is the only thing that you can easily customize in excel.
So now if we have a new workbook Maybe I create some data there and I want to close excel, closing all of the open workbooks.
Now use this x instead of the x in the upper right hand corner.
A little bit maddening that microsoft changed this behavior, but by using the customized feature in excel 2007, you can very easily, close all the open workbooks and close excel.
Hey thanks for stopping by. We'll see you next time for another netcast from MrExcel.
