Jim from California asks why it takes two clicks to create a new workbook in Excel 2007. Episode 1197 shows you the solution. Learn Excel 97-2007 from MrExcel.com
Transcript of the video:
The MrExcel podcast is brought to you by “Easy-XL”!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by an old friend Jim from California.
First thing Jim asked is “Hey, how come you're not doing a podcast every day?” Well, as I explained to Jim, I have six books done and under my belt, my goal this week is to return to five podcasts a week, so let's see if we can do that.
Jim's question, great question, Jim says “Hey, I added the New icon to the Quick Access Toolbar.” So I'm imagining that Jim came here, and right-clicks and says Add to Quick Access Toolbar, but it's driving me crazy because it takes two clicks: click on New, and then click on Create.
Is there some way to get around that?
Alright well, let's go in the way-back machine and take a look at Excel 2003 and see what's going on.
Back in Excel 2003, of course we had a New icon here, and then we also had File, New… and those are two very different commands.
Everyone, of course, used this New command, because that was the one we saw all the time.
And I don't think anyone ever really used File, New… where you had to come over here and then choose Blank Workbook, essentially two clicks.
And what's happening in Excel 2007 is when you go to the Office icon, essentially the File menu and go to this, this is the old New… that was on the Excel 2003 file menu, the one that no one used.
So the other icon is still there, it's just to find it, it's a little bit tough.
We're going to right-click on the Quick Access Toolbar, Customize Quick Access Toolbar, not in the Popular Commands, we want to go to All Commands, and then scroll down to the end.
Let's see right there, OK, there it is, there's New… Jim, that's the one that you got when you went to the Office menu.
The one you want is the one that doesn't have the … we’ll add that one, actually get rid of this one because it's well, frankly, evil, click OK, alright.
And now, we can just click the icon and BAM, there's our new Book3.
Very easy to do, also, of course, Ctrl+N will continue to do it.
So there you have it, Jim from California, I know you're a Cleveland Indians fan, drive season starts just short time from now, and predictably ends just a shorter time from then.
Sorry to all the Cleveland Indians fans, it's tough being a Cleveland native, like I am, and following the Indians.
It's, you know, I used to growing up was “we’ll be finished in this 6th place” or “we’ll manage to move up to 5th place in the old American MLB”.
So I love the drive, just a tough, tough team to be a fan of.
Alright hey, I want to thank everyone for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by an old friend Jim from California.
First thing Jim asked is “Hey, how come you're not doing a podcast every day?” Well, as I explained to Jim, I have six books done and under my belt, my goal this week is to return to five podcasts a week, so let's see if we can do that.
Jim's question, great question, Jim says “Hey, I added the New icon to the Quick Access Toolbar.” So I'm imagining that Jim came here, and right-clicks and says Add to Quick Access Toolbar, but it's driving me crazy because it takes two clicks: click on New, and then click on Create.
Is there some way to get around that?
Alright well, let's go in the way-back machine and take a look at Excel 2003 and see what's going on.
Back in Excel 2003, of course we had a New icon here, and then we also had File, New… and those are two very different commands.
Everyone, of course, used this New command, because that was the one we saw all the time.
And I don't think anyone ever really used File, New… where you had to come over here and then choose Blank Workbook, essentially two clicks.
And what's happening in Excel 2007 is when you go to the Office icon, essentially the File menu and go to this, this is the old New… that was on the Excel 2003 file menu, the one that no one used.
So the other icon is still there, it's just to find it, it's a little bit tough.
We're going to right-click on the Quick Access Toolbar, Customize Quick Access Toolbar, not in the Popular Commands, we want to go to All Commands, and then scroll down to the end.
Let's see right there, OK, there it is, there's New… Jim, that's the one that you got when you went to the Office menu.
The one you want is the one that doesn't have the … we’ll add that one, actually get rid of this one because it's well, frankly, evil, click OK, alright.
And now, we can just click the icon and BAM, there's our new Book3.
Very easy to do, also, of course, Ctrl+N will continue to do it.
So there you have it, Jim from California, I know you're a Cleveland Indians fan, drive season starts just short time from now, and predictably ends just a shorter time from then.
Sorry to all the Cleveland Indians fans, it's tough being a Cleveland native, like I am, and following the Indians.
It's, you know, I used to growing up was “we’ll be finished in this 6th place” or “we’ll manage to move up to 5th place in the old American MLB”.
So I love the drive, just a tough, tough team to be a fan of.
Alright hey, I want to thank everyone for stopping by, we'll see you next time for another netcast from MrExcel!
