In our first Where's it Wednesday segment, I tried to figure out where the popular Move or Copy Sheet command is hidden in Excel 2007. Check out the cool new Wednesday theme from George Wood in Episode 803!
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:
Well, hey. It's a Where Is It Wednesday. I want to thank George Wood.
George Wood made our jingle for Where Is It Wednesday.
This is going to be an occasional feature that takes a look at popular features that are very easy to use in Excel 2003 but we can't find them at all in Excel 2007.
I was out doing an Excel 2007 seminar the other day, and they had just switched over to Excel 2007 within the last week, and they were so frustrated that they could not find MOVE OR COPY SHEET.
Now, in Excel 2003, this great feature is right there under the EDIT tab, and they said, well, where is that in Excel 2007?
Well, at first, I didn't know.
So, my standard trick when I don't know is I want to go to the quick access toolbar and customize, and then what we're going to do is, in the left-hand dropdown, choose ALL COMMANDS, and find, down in the Ms, MOVE OR COPY.
So, I'll scroll down here to the Ms, and, typically, what we do is hover, and it says it's on the HOME tab in the CELLS group and then look for MOVE OR COPY SHEET.
Alright.
Well, sounds simple enough.
We go to the HOME tab.
Here's the CELLS group.
There's 3 dropdowns.
None of them are MOVE OR COPY SHEET.
We go to FORMAT and there is MOVE OR COPY SHEET.
Now, this makes no sense at all to me.
Why would something having to do with worksheets be under format cells?
Clearly not where it was before.
Now, the reason that this was never an issue to me is because I never used MOVE OR COPY on the EDIT tab.
I always just right click on the tab name and choose MOVE OR COPY, and great way to use this very powerful dialog box that allows me to take this sheet and either make a copy of it at the end of the workbook or even move it to a brand new workbook.
Either one will work but, if you were used to using it on the old EDIT menu, certainly very hard to find in Excel 2007.
I want to thank George Wood for that great new theme and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
George Wood made our jingle for Where Is It Wednesday.
This is going to be an occasional feature that takes a look at popular features that are very easy to use in Excel 2003 but we can't find them at all in Excel 2007.
I was out doing an Excel 2007 seminar the other day, and they had just switched over to Excel 2007 within the last week, and they were so frustrated that they could not find MOVE OR COPY SHEET.
Now, in Excel 2003, this great feature is right there under the EDIT tab, and they said, well, where is that in Excel 2007?
Well, at first, I didn't know.
So, my standard trick when I don't know is I want to go to the quick access toolbar and customize, and then what we're going to do is, in the left-hand dropdown, choose ALL COMMANDS, and find, down in the Ms, MOVE OR COPY.
So, I'll scroll down here to the Ms, and, typically, what we do is hover, and it says it's on the HOME tab in the CELLS group and then look for MOVE OR COPY SHEET.
Alright.
Well, sounds simple enough.
We go to the HOME tab.
Here's the CELLS group.
There's 3 dropdowns.
None of them are MOVE OR COPY SHEET.
We go to FORMAT and there is MOVE OR COPY SHEET.
Now, this makes no sense at all to me.
Why would something having to do with worksheets be under format cells?
Clearly not where it was before.
Now, the reason that this was never an issue to me is because I never used MOVE OR COPY on the EDIT tab.
I always just right click on the tab name and choose MOVE OR COPY, and great way to use this very powerful dialog box that allows me to take this sheet and either make a copy of it at the end of the workbook or even move it to a brand new workbook.
Either one will work but, if you were used to using it on the old EDIT menu, certainly very hard to find in Excel 2007.
I want to thank George Wood for that great new theme and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
