WEBVTT Kind: captions Language: en 00:00:07.410 --> 00:00:12.100 So far, I'm only using one worksheet in my workbook. 00:00:12.100 --> 00:00:17.430 My inventory is only for one month and only appears on one sheet. 00:00:17.430 --> 00:00:24.039 But let's take a look at how you can use the other sheets to accomplish your goals in Excel. 00:00:24.039 --> 00:00:30.150 By default, three sheets appear when you create a new workbook. 00:00:30.150 --> 00:00:35.550 If you want to change this default setting, you can do that in your Excel Options. 00:00:35.550 --> 00:00:39.940 I'm going to leave the default setting set to 3 for right now. 00:00:39.940 --> 00:00:46.940 I can add new sheets as I need them. I would like to name this first sheet January. 00:00:48.170 --> 00:00:55.170 To do this, just right-click the sheet tab, and from the menu that appears, choose Rename. 00:00:57.350 --> 00:01:04.350 Now, the word Sheet appears highlighted, and you can begin typing the new name. 00:01:07.810 --> 00:01:14.800 If I want to rename the next sheet, I just select it, and do the same thing. 00:01:14.800 --> 00:01:21.770 Or if you prefer to use the Ribbon you can click the Format command in the Cells group 00:01:21.770 --> 00:01:30.800 on the Home tab, and then select Rename Sheet. The word Sheet appears highlighted, and you 00:01:30.800 --> 00:01:40.539 can begin typing the new name. You can use whichever method you prefer. 00:01:40.539 --> 00:01:46.420 Personally, I use the first way I showed you. I think it's a bit faster for me but you'll 00:01:46.420 --> 00:01:52.920 learn what works for you. Since my default sheet setting is 3, I need 00:01:52.920 --> 00:01:57.300 to add more sheets so that I can list my inventory each month. 00:01:57.300 --> 00:02:04.300 To add a new sheet, left-click the Insert Worksheet Icon, and a new sheet will appear. 00:02:04.550 --> 00:02:09.810 I'll do this several more times, so that I will have enough sheets. 00:02:09.810 --> 00:02:15.720 If you'd prefer to use the keyboard shortcut, just press the Shift key and the Function 00:02:15.720 --> 00:02:22.720 11, of F11 key, at the top of your keyboard. If you decide you want to delete a sheet, 00:02:25.350 --> 00:02:32.350 just right- click the sheet and select delete. Or, if you like using the Ribbon command, 00:02:33.200 --> 00:02:38.810 just select the sheet you want to remove, and click the drop-down arrow next to Delete 00:02:38.810 --> 00:02:44.860 in the Cells group on the Home tab. From the menu that appears, select Delete 00:02:44.860 --> 00:02:54.540 Sheet. Ok, now you know how to rename, add, and delete 00:02:54.540 --> 00:02:58.340 sheets. Let's actually go ahead and rename these two 00:02:58.340 --> 00:03:10.620 sheets. We can add the rest of the months later. 00:03:10.620 --> 00:03:16.560 On my January sheet, I have all my inventory information for that month, but all my other 00:03:16.560 --> 00:03:20.780 sheets are blank. I want to copy all this information to my 00:03:20.780 --> 00:03:26.480 February sheet. I can do that by selecting it all, selecting 00:03:26.480 --> 00:03:33.380 the Copy command, and then left-clicking the February sheet to select it. 00:03:33.380 --> 00:03:39.709 Now I can click the Paste command and select paste from the list and all the info appears 00:03:39.709 --> 00:03:45.100 on the sheet. This is a lot easier to do than typing this 00:03:45.100 --> 00:03:50.900 information into the sheet but copying and pasting into multiple sheets can be time consuming, 00:03:50.900 --> 00:03:57.350 also. This is where grouping comes in. 00:03:57.350 --> 00:04:02.440 Before I group my sheets, I need to copy the information I want to paste. 00:04:02.440 --> 00:04:07.490 I actually just want to paste my heading and categories to the remaining months, so I need 00:04:07.490 --> 00:04:12.690 to select this information and click the Copy command. 00:04:12.690 --> 00:04:17.739 Now we're ready to group. To group contiguous sheets, or sheets that 00:04:17.739 --> 00:04:24.410 are all in a row, click the first sheet you want to group, then press and hold the Shift 00:04:24.410 --> 00:04:30.430 key on your keyboard, now click the last sheet you want to group. 00:04:30.430 --> 00:04:37.430 See how March, April, and May all changed color and now the sheet tabs are white? These 00:04:37.990 --> 00:04:43.060 sheets are now grouped together. Select a cell where you want the information 00:04:43.060 --> 00:04:49.419 to start. Now, click the Paste command. 00:04:49.419 --> 00:04:56.419 And the information appears. But instead of pasting it to just one sheet, 00:04:56.440 --> 00:05:03.440 it appears in all three sheets. We can also make formatting changes when sheets 00:05:03.480 --> 00:05:08.300 are grouped. For example, I want to add 2008 to the beginning 00:05:08.300 --> 00:05:12.610 of my title. If we do it once, the change will appear on 00:05:12.610 --> 00:05:19.320 all three sheets that are grouped. It looks like I need to change the width of 00:05:19.320 --> 00:05:26.320 my columns as well. That looks a lot neater. 00:05:28.370 --> 00:05:32.870 As you can see, the tabs are still white, which indicates they are still grouped. 00:05:32.870 --> 00:05:39.870 To ungroup sheets, just right-click one of the sheets, and select Ungroup from the list. 00:05:42.180 --> 00:05:47.930 Before we finish talking about grouping, let me show you one other way to group.What if 00:05:47.930 --> 00:05:54.740 I want to make a change only to two or three sheets and they aren't side by side? You can 00:05:54.740 --> 00:06:01.470 do this using the Control key. Select the first sheet you want to group, 00:06:01.470 --> 00:06:07.120 then press and hold the Control key on your keyboard. 00:06:07.120 --> 00:06:14.120 Now select any of the other sheets you want to group, and release the Control key. 00:06:14.199 --> 00:06:20.790 You can see that the sheets you selected now appear in white and are grouped together. 00:06:20.790 --> 00:06:26.690 If I make a change now to one, it will appear in all the grouped sheets, but not the ones 00:06:26.690 --> 00:06:33.690 that weren't grouped. So, whatever I change will only appear in March and May. 00:06:35.949 --> 00:06:39.699 There is one more thing about working with worksheets that I want to show you because I find it helpful. 00:06:39.699 --> 00:06:45.729 This is the ability to freeze, or lock, specific rows or columns in your spreadsheet. 00:06:45.729 --> 00:06:51.490 Excel calls this freezing panes. When you freeze panes, you select rows or 00:06:51.490 --> 00:06:56.910 columns that will remain visible all the time, even as you are scrolling. 00:06:56.910 --> 00:07:02.449 You see, right now when I scroll down my spreadsheet, I can't see the column headings that let me 00:07:02.449 --> 00:07:06.800 know what type of information each column contains. 00:07:06.800 --> 00:07:11.759 If I scroll to the right, I can't see the column that tells me what item all this inventory 00:07:11.759 --> 00:07:18.759 information refers to. To freeze a row, select the row below the 00:07:19.759 --> 00:07:24.930 one that you want to freeze. Since I want row 1 and 2 to appear at 00:07:24.930 --> 00:07:30.150 the top even as I scroll, I'll select Row 3. 00:07:30.150 --> 00:07:37.150 Now, click the View tab. In the Window group, click the Freeze Pane 00:07:38.030 --> 00:07:44.520 command to view the list. And choose Freeze Pane. 00:07:44.520 --> 00:07:51.520 Everything above this line is frozen in place. Now, when I scroll in the worksheet, the first 00:07:52.310 --> 00:07:59.280 two rows stay pinned at the top so I can always see the column headings. 00:07:59.280 --> 00:08:06.250 To unfreeze the pane, just click the Freeze Pane command, and select the Unfreeze command. 00:08:06.250 --> 00:08:12.570 Now, you can do the same thing with columns. Let's say we want the first two columns to 00:08:12.570 --> 00:08:18.310 always appear on the left. Just select the column to the right of the 00:08:18.310 --> 00:08:25.310 columns you want frozen, and then click Freeze Pane, and Freeze Pane again. 00:08:27.180 --> 00:08:32.039 Now as we scroll to the right, those columns stay right in place. 00:08:32.039 --> 00:08:36.709 Freezing rows and columns can be especially helpful when dealing with large spreadsheets, 00:08:36.709 --> 00:08:41.360 so this is a good thing to know how to do. It doesn't change how the spreadsheet looks 00:08:41.360 --> 00:08:46.179 printed, but it does make working with it electronically a lot easier. 00:08:46.179 --> 00:08:51.459 We've gone over a lot, but it really is important to know how to work with worksheets so that 00:08:51.459 --> 00:08:56.300 you can easily navigate your workbook and use it most efficiently. 00:08:56.300 --> 00:08:58.809 Take some time to explore worksheets on your own.