Let us talk about one more option dealing with worksheets, moving and copying sheets. We have seen renaming sheets adding sheets and deleting sheets. But what about moving the order of sheets or copying on a sheet. Maybe I need an exact duplicate of the monthly budget because this one is for 2020, 2021 is quickly approaching.
But now you need to create a whole new sheet that is just for 2021.
There are some simple techniques that you can use here to reorder or remove sheets, copy sheets.
First Moving sheets, I have only got two sheets in here, so let us quickly add a couple more sheets. I was going at the plus sign a few times here.
Now, I want to reorder those sheets. Sheet3 should go before Sheet1.
So here I will just click on Sheet3 Just activate that sheet and I am just going to left click and drag it, You see that little diamond and little upside down triangle, It is following around cursor. I am going to drag it all the way to the left of sheet2 and I will let go, I am now reordered the sheets really simple left click the sheet tab just drag it to where you want to place that sheet.
Now that is moving that literally moves that sheet in the order of your sheets at the bottom of your screen.
You can also copy sheets. I decide that monthly budget, this is 2020, I need to create a copy of that for 2021. If I hold them the Ctrl key and hold down the Ctrl key on my keyboard and then I am going to drag it. there is one little difference I still got that upside down triangle, but if you look at your mouse cursor you will move it up, now it is got that little piece of paper with a plus sign on it. That plus sign means I am going to copy it.
So, I have now got a copy of monthly budget and its monthly budget number two because you cannot have two sheets name the same thing, So they give it a little index number or a little number just to identify it.
But what if you wanted to move a sheet to another workbook. This is monthly budget workbook. What if I want to create a copy or move the monthly budget to a completely different excel file? How would I do that?
If you right click, I right click the monthly budget tab
There is an option in here for a move or copy. If I go to there, we have got a few options.
The first one is well where do you want to move or copy the sheets to. You can keep an inside of the active workbook in this case monthly budget or I can move it to a new book, I can pick from any other workbook that I have opened currently on my system, so I can grab the other workbook, I want to move it before a specific sheet or move it to the end of the workbook whatever I want to do.
And you have the option Create a copy, so you can do it within the one word but just click and drag, Ctrl click, and drag or you can right click. Use the move from copy command and you have got all your options.
And it will allow you to move to other workbooks.
Try it out, We want to keep our workbook pretty consistent so make sure you keep the monthly budget. If you create copies of a great can always delete them out, but do not move that one to another workbook.
If you want to make sure you save this one, and then you can scrap the old one it first got the other one. If you’d like to but I make sure you keep the monthly budget, we are going to do some super fancy formatting coming up in some next lectures here but get a feel for moving work worksheets and copying worksheets whether it is within the one workbook or within other workbooks.