WEBVTT Kind: captions Language: en 00:00:10.110 --> 00:00:14.930 Every Excel workbook contains one or more worksheets, kind of like a book contains many 00:00:14.930 --> 00:00:16.550 sheets of paper. 00:00:16.550 --> 00:00:22.730 New workbooks contain three blank sheets by default - Sheet1, Sheet2, and Sheet3. 00:00:22.730 --> 00:00:26.320 But imagine what it would look like if you were working with an even larger amount of 00:00:26.320 --> 00:00:27.500 data. 00:00:27.500 --> 00:00:31.710 Creating and customizing a range of worksheets could really help you stay organized and get 00:00:31.710 --> 00:00:33.700 the most out of Excel. 00:00:33.700 --> 00:00:37.800 I've already made some progress color-coding and renaming most of my worksheets. 00:00:37.800 --> 00:00:40.000 But where did they all come from? 00:00:40.000 --> 00:00:44.340 There are two ways to add worksheets to your workbook: either by copying or inserting a 00:00:44.340 --> 00:00:45.340 new one. 00:00:45.340 --> 00:00:50.230 I do need to add one final sheet for the month of December, so this is a good place for us 00:00:50.230 --> 00:00:51.230 to start. 00:00:51.230 --> 00:00:55.690 To quickly insert a new sheet, just click the Insert Worksheet icon, always found at 00:00:55.690 --> 00:00:57.690 the end of your list of tabs. 00:00:57.690 --> 00:01:01.530 A new blank worksheet will appear, ready for your content. 00:01:01.530 --> 00:01:07.180 To copy one of your existing worksheets, right-click the tab, and select Move or Copy from the 00:01:07.180 --> 00:01:08.530 menu. 00:01:08.530 --> 00:01:13.110 This will create a new worksheet, and duplicate the contents - perfect for tracking my budget 00:01:13.110 --> 00:01:16.150 from month to month using the same table. 00:01:16.150 --> 00:01:20.130 Just check the box next to Create a Copy, and identify where you want the worksheet 00:01:20.130 --> 00:01:21.130 to go. 00:01:21.130 --> 00:01:24.770 I want mine to go to the end of the list. 00:01:24.770 --> 00:01:30.400 Click OK, and your copy appears with the same name as the original, plus a version number. 00:01:30.400 --> 00:01:34.420 Remember, this is the worksheet I needed for the month of December, so I'm going to go 00:01:34.420 --> 00:01:39.979 ahead and rename it by right-clicking the tab, and then choosing Rename. 00:01:39.979 --> 00:01:47.720 Now type the name, click anywhere outside the tab or press Enter on your keyboard, and 00:01:47.720 --> 00:01:49.659 you're all set. 00:01:49.659 --> 00:01:54.100 As you can see, the table from the November worksheet has been copied over, so I'm just 00:01:54.100 --> 00:01:58.840 going to change this to December to match. 00:01:58.840 --> 00:02:03.450 Now we can take a look at this extra blank worksheet that I no longer need. 00:02:03.450 --> 00:02:10.190 To delete a worksheet, all you have to do is right-click the tab, and choose Delete. 00:02:10.190 --> 00:02:14.490 Finally I'd like to show you how to color-code and move worksheet tabs by going all the way 00:02:14.490 --> 00:02:17.700 back to my original sheet - Sheet1. 00:02:17.700 --> 00:02:26.150 First I'm going to rename it… then give it its own unique color (like I've done for 00:02:26.150 --> 00:02:32.450 the rest) by right-clicking and going to Tab Color. 00:02:32.450 --> 00:02:36.090 The tab still appears white because the worksheet is selected. 00:02:36.090 --> 00:02:39.700 Select any other tab and you'll see the color change. 00:02:39.700 --> 00:02:44.011 Now I'd like to move this first worksheet, being that it's for the previous year, to 00:02:44.011 --> 00:02:45.870 the very end of the list. 00:02:45.870 --> 00:02:50.120 To do this, just click and drag the tab where you want it to go. 00:02:50.120 --> 00:02:51.700 There! 00:02:51.700 --> 00:02:53.920 Now everything is in order. 00:02:53.920 --> 00:02:58.390 Using worksheets (and taking the time to customize them) is a great way to organize your data 00:02:58.390 --> 00:03:22.700 and make it easier to navigate.