Excel Functions


Excel Basics

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

5.7 Moving and Copying an Excel Worksheet

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.