MrExcel's Learn Excel #803 - Move or Copy Sheet

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 15, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top