Microsoft Excel

2.1 Opening Microsoft Excel 2.2 Microsoft Excel Startup Screen 2.4 Introduction to the Excel Interface 2.5 Customizing the Excel Quick Access Toolbar 2.6 More on the Excel Interface 2.7 Understanding the Structure of an Excel Workbook 2.8 Saving an Excel Document 2.9 Opening an Existing Excel Document 2.10 Common Excel Shortcut Keys 3.1 Entering Text to Create Spreadsheet Titles 3.2 Working with Numeric Data in Excel 3.3 Entering Date Values in Excel 3.4 Working with Cell References 3.5 Creating Basic Formulas in Excel 3.6 Relative Versus Absolute Cell References in Formulas 3.7 Understanding the Order of Operation 4.1 The structure of an Excel Function 4.2 Working with the SUM() Function – Excel 4.3 Working with the MIN() and MAX() Functions 4.4 Working with the AVERAGE() Function 4.5 Working with the COUNT() Function 4.6 Adjacent Cells Error in Excel Calculations 4.7 Using the AutoSum Command 4.8 Excel’s AutoSum Shortcut Key 4.9 Using the AutoFill Command to Copy Formulas 5.1 Moving and Copying Data in an Excel Worksheet 5.2. Inserting and Deleting Rows and Columns 5.3. Changing the Width and Height of Cells 5.4 Hiding and Unhiding Excel Rows and Columns 5.5 Renaming an Excel Worksheet 5.6. Deleting an Excel Worksheet 5.7 Moving and Copying an Excel Worksheet 6.1 Working with Font Formatting Commands 6.2. Changing the Background Color of a Cell 6.3. Adding Borders to Cells 6.4. Formatting Data as Currency Values 6.5. Formatting Percentages 6.6. Using Excel’s Format Painter 6.7. Creating Styles to Format Data 6.8. Merging and Centering Cells 6.9. Using Conditional Formatting 7.1 Inserting Images and Shapes into an Excel Worksheet 7.2 Inserting Shapes In Excel 7.3 Formatting Excel Shapes 7.4. Working with Excel SmartArt 8.1. Creating an Excel Column Chart 8.2. Working with the Excel Chart Ribbon 8.3. Adding and Modifying Data on an Excel Chart 8.4. Formatting an Excel Chart 8.5. Moving a Chart to another Worksheet 8.6. Working with Excel Pie Charts 9.1. Viewing your Document in Print Preview 9.2. Changing the Margins, Scaling and Orientation 9.3 Adding Header and Footer Content 9.4 Printing a Specific Range of Cells 10.1. Intro to Excel Templates 10.3. Opening an Existing Template 10.4. Creating a Custom Template 13.1 Understanding Excel List Structure 13.2 Sorting a List Using Single Level Sort 13.3 Sorting a List Using Multi-Level Sorts 13.4 Using Custom Sorts in an Excel List 13.5 Filter an Excel List Using the AutoFilter Tool 13.6 Creating Subtotals in a List 13.7 Format a List as a Table 13.8 Using Conditional Formatting to Find Duplicates 13.9 Removing Duplicates in Excel 14.1 Excel DSUM Function Single Criteria 14.2 Excel DSUM Function with OR Criteria 14.3 Excel DSUM Function with AND Criteria 14.4 Excel Function: DAVERAGE() 14.5 Excel Function: DCOUNT() 14.6 Excel Function: SUBTOTAL() 15.1 Creating an Excel Data Validation List 15.2 Excel Decimal Data Validation 15.3 Adding a Custom Excel Data Validation Error 15.4 Dynamic Formulas by Using Excel Data Validation Techniques 16.1 Importing Data from Text Files into Excel 16.2 Excel 2019

Excel Basics

5.7 Moving and Copying an Excel Worksheet

06/12/2020 53 lượt xem

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.

Moving and Copying an Excel Worksheet 1

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.

Moving and Copying an Excel Worksheet 2

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.

Moving and Copying an Excel Worksheet 3

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

Moving and Copying an Excel Worksheet 4

There is an option in here for a move or copy. If I go to there, we have got a few options.

Moving and Copying an Excel Worksheet 5

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.