The best way to organize your data within a workbook is to create a separate worksheet for distinct data sets. In this video, learn how to create, delete, and manage your worksheets.
- [Instructor] When you create an Excel workbook, it comes with one worksheet where you can store and summarize your data. The best way to organize your data within a workbook is to create a separate worksheet for distinct data sets. In this movie, I will show you how to work with worksheets and that will be to create, delete, and manage them. My sample file is the Manage Worksheets workbook and you can find it in the Chapter Four folder of the Exercise Files collection. This workbook contains two worksheets. The main one is Monthly.
Yearly is there so we can work with it a bit. If you want to move between worksheets, in other words, display a different worksheet, then go down to the list of sheet tabs. You see here Monthly and Yearly. Monthly is currently displayed. It is highlighted in green. To display the Yearly worksheet, just click its tab and there you go. If you want to add a worksheet, then click the plus button to the right of the sheet tabs. It's actually called the New Sheet button, and to get a new work sheet.
If you want to delete a worksheet, for example, the one that I just created, then control click its Sheet tab, and then click Delete. If the worksheet contained any data, then you would have been asked to confirm that you wanted to delete it. You can just click OK. If you want to rename a worksheet, then double click its sheet tab, like I'll do here with Yearly. So I double click that, and let's say, that I want to call it Yearly Revenue.
So I'll type that in, press return, and that is now the worksheet's name. You can move and copy worksheets in a number of different ways. If you want to move a worksheet, for example, to a different location in the same workbook without creating a copy, then you can simply drag its header where it wants to go. And you see here that I am dragging Yearly Revenue and a small, downward pointing, dark, gray triangle appears to the left of Monthly. When I release the left mouse button, they change positions.
If you want to copy a worksheet, then you can control click it. This case, I will control click Yearly Revenue, and then click Move or Copy. And here you have a number of options. You can move the worksheet as I did before, or if you select the Create a copy checkbox, then you will be copying it. You can copy it within the same workbook, or if you want to put it to a new workbook, click the two book controls down arrow, and click new book.
What that will do is create a copy of your worksheet in a new workbook. I'll go ahead and click OK. The new workbook appears and you can save it as you like. In this case, I'm not going to work with it at all. So I'll just close it out. Not save, and we're back in the original workbook. If I had left the Create a copy checkbox unselected, then I would have moved the worksheet and it would have been deleted from the original workbook and moved to the other one.
Finally, you can change a worksheet's tab color to call attention to it or, perhaps, to categorize it if you have a lot of worksheets within your workbook. To do that, control click the worksheet tab, and then point to Tab Color, and you see that you can select from all the colors that are available in Excel. In this case, I will change it to a medium orange. And you note, that it is currently selected and the text is in orange and the underline is also in orange.
If I display Monthly, then the top line changes to orange and the text goes back to gray. So if you want to call attention to a worksheet tab, changing its tab color is a great way to do it.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.