1 00:00:00,05 --> 00:00:02,04 - [Instructor] I'm looking at all the tabs or sheets 2 00:00:02,04 --> 00:00:05,03 in my workbook and I can see that they're out of order. 3 00:00:05,03 --> 00:00:10,07 Here's 2018 and it definitely should be to the left of 2019. 4 00:00:10,07 --> 00:00:14,01 All I have to do is click and hold and drag it 5 00:00:14,01 --> 00:00:16,05 and it's going to rearrange that tab. 6 00:00:16,05 --> 00:00:19,01 In fact, I can do that with any tab. 7 00:00:19,01 --> 00:00:20,05 I can slide them around 8 00:00:20,05 --> 00:00:23,06 and rearrange them to my heart's content. 9 00:00:23,06 --> 00:00:26,06 What I could also do is duplicate a sheet. 10 00:00:26,06 --> 00:00:29,05 Let's say we want a copy of 2021. 11 00:00:29,05 --> 00:00:33,09 I can right-click and choose Move or Copy. 12 00:00:33,09 --> 00:00:35,02 Now, we know how to move it. 13 00:00:35,02 --> 00:00:39,08 It's easier just to drag it around, so let's copy it. 14 00:00:39,08 --> 00:00:42,06 It's important to note that I could even copy this 15 00:00:42,06 --> 00:00:45,00 to a completely new workbook. 16 00:00:45,00 --> 00:00:46,09 It doesn't have to be this one, 17 00:00:46,09 --> 00:00:49,08 but it defaults to keeping it in the same workbook. 18 00:00:49,08 --> 00:00:53,05 It assumes that you want to copy, that is duplicate this tab, 19 00:00:53,05 --> 00:00:55,01 to the same workbook. 20 00:00:55,01 --> 00:00:58,00 And here it is asking me where I want to put it. 21 00:00:58,00 --> 00:00:59,08 I can put it before a certain sheet 22 00:00:59,08 --> 00:01:02,06 or move it to the end if I wanted to. 23 00:01:02,06 --> 00:01:08,00 I'll place a check mark next to Create a copy and click OK. 24 00:01:08,00 --> 00:01:11,08 And here is my identical copy of that tab. 25 00:01:11,08 --> 00:01:15,08 I can give it a new name by double clicking on it. 26 00:01:15,08 --> 00:01:17,02 Now that I have my new tab, 27 00:01:17,02 --> 00:01:20,08 I can erase these values and put my new ones in. 28 00:01:20,08 --> 00:01:24,03 Let's say you want to make a change to every sheet at once. 29 00:01:24,03 --> 00:01:25,07 Why would you want to do that? 30 00:01:25,07 --> 00:01:29,08 Well, the most common use is to make a formatting change. 31 00:01:29,08 --> 00:01:31,08 I can group these sheets. 32 00:01:31,08 --> 00:01:35,03 To do that, click the first sheet, hold down the shift key, 33 00:01:35,03 --> 00:01:39,03 and select the very last sheet that you want to group. 34 00:01:39,03 --> 00:01:42,03 I can now see that they're all the same color. 35 00:01:42,03 --> 00:01:44,01 It looks like they're all selected, 36 00:01:44,01 --> 00:01:46,08 and if I go to the very top of the screen, 37 00:01:46,08 --> 00:01:51,01 I can see that Group is in brackets next to the title. 38 00:01:51,01 --> 00:01:53,00 That's a good visual cue for me 39 00:01:53,00 --> 00:01:55,00 that these sheets are grouped. 40 00:01:55,00 --> 00:01:59,05 Now any change that I make is going to affect every sheet. 41 00:01:59,05 --> 00:02:03,01 I can change anything. I can even change the data. 42 00:02:03,01 --> 00:02:05,05 For example, in this data type, 43 00:02:05,05 --> 00:02:08,04 I might want to add some decimal places. 44 00:02:08,04 --> 00:02:11,08 I'll select the data, add my decimal places, 45 00:02:11,08 --> 00:02:13,07 and if I do that and navigate 46 00:02:13,07 --> 00:02:16,00 through the rest of my balance sheet, 47 00:02:16,00 --> 00:02:18,05 you'll notice that these balances are changing 48 00:02:18,05 --> 00:02:20,07 because I'm moving through different years, 49 00:02:20,07 --> 00:02:23,02 but the formatting is the same. 50 00:02:23,02 --> 00:02:27,01 That change has taken into effect for everything. 51 00:02:27,01 --> 00:02:28,04 Something else that I might want to do 52 00:02:28,04 --> 00:02:30,04 is change the way text looks. 53 00:02:30,04 --> 00:02:32,07 I can click and drag through these columns. 54 00:02:32,07 --> 00:02:36,02 Maybe I want to change the color or italicize them. 55 00:02:36,02 --> 00:02:42,08 Again, every single tab has that formatting. 56 00:02:42,08 --> 00:02:45,02 I can insert rows, I can delete rows. 57 00:02:45,02 --> 00:02:48,05 Whatever I do, it's going to do to all of them. 58 00:02:48,05 --> 00:02:51,05 When I'm all done, the easiest way to ungroup 59 00:02:51,05 --> 00:02:56,08 is to right-click on any tab and choose Ungroup Sheets. 60 00:02:56,08 --> 00:02:59,02 Now I can go back to working with them 61 00:02:59,02 --> 00:03:01,00 on an individual basis.