WEBVTT Kind: captions Language: en 00:00:11.320 --> 00:00:15.610 By default, when you create a new workbook in Excel, it contains one worksheet called 00:00:15.610 --> 00:00:16.800 Sheet1. 00:00:16.800 --> 00:00:19.400 Sometimes, that's all you need. 00:00:19.400 --> 00:00:23.090 But if you want, you can create additional worksheets (and even customize them), so you 00:00:23.090 --> 00:00:26.890 can store large amounts of data all in the same workbook. 00:00:26.890 --> 00:00:30.760 As you can see, I've already made some progress creating worksheets for each month in the 00:00:30.760 --> 00:00:31.760 year. 00:00:31.760 --> 00:00:35.260 I still need one final sheet for the month of December. 00:00:35.260 --> 00:00:39.510 To quickly insert a new sheet, just click the New Sheet button, always found to far 00:00:39.510 --> 00:00:41.560 right of your tabs. 00:00:41.560 --> 00:00:45.280 Alternatively, you can copy one of your existing worksheets. 00:00:45.280 --> 00:00:49.590 This will create a new worksheet, and duplicate the contents—perfect for keeping track of 00:00:49.590 --> 00:00:52.850 my budget using the same table each month. 00:00:52.850 --> 00:00:57.789 All you have to do is right-click the worksheet you want… then choose Move or Copy from 00:00:57.789 --> 00:00:59.450 the menu. 00:00:59.450 --> 00:01:04.930 Next, check the box that says Create a Copy… and identify where you want the worksheet 00:01:04.930 --> 00:01:05.930 to go. 00:01:05.930 --> 00:01:10.000 I want mine to go to the very end of the list. 00:01:10.000 --> 00:01:14.509 Click OK… and a copy will appear with the same name as the original, plus a version 00:01:14.509 --> 00:01:15.509 number. 00:01:15.509 --> 00:01:19.909 Remember, this is the worksheet I needed for the month of December, so I'm going to rename 00:01:19.909 --> 00:01:25.470 it by right-clicking the tab… then choosing Rename. 00:01:25.470 --> 00:01:29.750 When you're done, click anywhere outside the tab to deselect it, or press Enter on your 00:01:29.750 --> 00:01:31.430 keyboard. 00:01:31.430 --> 00:01:36.950 I'm also going to update the worksheet itself. 00:01:36.950 --> 00:01:41.260 Next I'd like to review the rest of my worksheets, and make sure everything is in order; it looks 00:01:41.260 --> 00:01:43.760 like some of them need to be moved. 00:01:43.760 --> 00:01:50.630 To do this, just drag and drop the worksheet tabs into place. 00:01:50.630 --> 00:01:54.659 You can even color-code your worksheets to make them easier to reference. 00:01:54.659 --> 00:02:00.840 Just right-click the tab… then go to Tab Color. 00:02:00.840 --> 00:02:03.930 The color is less noticeable when the worksheet is selected. 00:02:03.930 --> 00:02:08.539 If you select another worksheet… you'll see the color the way it was intended. 00:02:08.539 --> 00:02:12.840 Finally, if you have a worksheet you don't need anymore, you can easily remove it from 00:02:12.840 --> 00:02:14.299 your workbook. 00:02:14.299 --> 00:02:19.769 All you have to do is right-click the tab… then choose Delete. 00:02:19.769 --> 00:02:23.070 Now it looks like we're all set. 00:02:23.070 --> 00:02:26.949 When you have multiple worksheets, you can work with each one individually, or you can 00:02:26.949 --> 00:02:28.970 edit several at the same time. 00:02:28.970 --> 00:02:33.100 This can be useful if you're working with lots of data that's closely related. 00:02:33.100 --> 00:02:34.190 Let's take a look. 00:02:34.190 --> 00:02:38.139 For example, I'm planning to move in the month of September. 00:02:38.139 --> 00:02:42.010 My rent is going to go up, and I'm canceling my gym membership too. 00:02:42.010 --> 00:02:45.669 That means I need to update not only this worksheet, but also the sheets for the rest 00:02:45.669 --> 00:02:47.169 of the year. 00:02:47.169 --> 00:02:50.190 We can edit them all at once just by grouping them. 00:02:50.190 --> 00:02:54.200 Start by selecting the first sheet you want to group, then press and hold Ctrl on your 00:02:54.200 --> 00:02:56.940 keyboard while you select the rest. 00:02:56.940 --> 00:03:01.060 Release the Ctrl key, and you'll be able to navigate and make changes to the data—changes 00:03:01.060 --> 00:03:04.040 that will apply to all the worksheets in the group. 00:03:04.040 --> 00:03:10.750 For example, if I change the rent to $775 in one worksheet… the rest of the group 00:03:10.750 --> 00:03:13.639 gets updated too. 00:03:13.639 --> 00:03:18.120 The same rule applies if I clear the row that contains my gym membership. 00:03:18.120 --> 00:03:26.230 To ungroup, just right-click one of the worksheets… then click Ungroup Sheets. 00:03:26.230 --> 00:03:30.560 Alternatively, you can click any worksheet outside the group—just be careful not to 00:03:30.560 --> 00:03:33.570 do that by accident. 00:03:33.570 --> 00:03:37.340 Worksheets are a great option for storing lots of data in the same workbook. 00:03:37.340 --> 00:03:42.130 And with the ability to group them, you can easily add or edit data anytime—whether 00:03:42.130 --> 00:03:44.310 you have hundreds of worksheets, or just a few.