1 00:00:00,05 --> 00:00:03,05 - [Isn't] This Excel workbook has six sheets. 2 00:00:03,05 --> 00:00:05,02 I can go through all of these sheets 3 00:00:05,02 --> 00:00:08,09 and navigate through the tabs by clicking on each one. 4 00:00:08,09 --> 00:00:12,00 The currently selected sheet will always be boldfaced 5 00:00:12,00 --> 00:00:14,05 and highlighted in white. 6 00:00:14,05 --> 00:00:16,06 There's a few things that we can do with sheets. 7 00:00:16,06 --> 00:00:18,09 The first thing you might want to do is add a new one, 8 00:00:18,09 --> 00:00:21,09 and you can do that by right-clicking on any sheet 9 00:00:21,09 --> 00:00:24,05 and choosing Insert all the way at the top 10 00:00:24,05 --> 00:00:27,09 or clicking the plus sign all the way at the end. 11 00:00:27,09 --> 00:00:29,07 It's going to pop a new sheet in 12 00:00:29,07 --> 00:00:32,02 and now I can rename it the same way. 13 00:00:32,02 --> 00:00:34,08 I can either right-click and choose Rename, 14 00:00:34,08 --> 00:00:38,08 or I can double-click right inside the sheet title. 15 00:00:38,08 --> 00:00:41,01 From here, I can just start typing. 16 00:00:41,01 --> 00:00:43,01 Maybe now it's a six-year review, 17 00:00:43,01 --> 00:00:46,06 so we'll call this one 2018. 18 00:00:46,06 --> 00:00:48,01 Something else that we might want to do 19 00:00:48,01 --> 00:00:49,09 with our sheets is delete them. 20 00:00:49,09 --> 00:00:51,02 Well, let's say I've decided 21 00:00:51,02 --> 00:00:53,07 I don't need a six-year review after all, 22 00:00:53,07 --> 00:00:55,08 so I don't need this one. 23 00:00:55,08 --> 00:00:59,01 I'll right-click on it and choose Delete. 24 00:00:59,01 --> 00:01:02,01 Because that sheet was empty, there was no data in it. 25 00:01:02,01 --> 00:01:04,01 I didn't get prompted with that usual, 26 00:01:04,01 --> 00:01:05,07 are you sure you want to delete this? 27 00:01:05,07 --> 00:01:07,08 So it just went away. 28 00:01:07,08 --> 00:01:09,03 If I'm a visual person, 29 00:01:09,03 --> 00:01:12,01 I might want to change the color of these tabs. 30 00:01:12,01 --> 00:01:14,02 I can right-click on each sheet, 31 00:01:14,02 --> 00:01:23,06 hover my mouse over tab color, and choose a color for them. 32 00:01:23,06 --> 00:01:26,07 It's important to note that even when I change the color, 33 00:01:26,07 --> 00:01:28,01 the currently selected sheet 34 00:01:28,01 --> 00:01:31,02 will still be boldfaced and whitish. 35 00:01:31,02 --> 00:01:32,06 The last thing that I might want to do 36 00:01:32,06 --> 00:01:34,06 with a sheet is hide it. 37 00:01:34,06 --> 00:01:38,00 Let's say I don't want this five-year review tab. 38 00:01:38,00 --> 00:01:40,09 I'll right-click on it and choose Hide. 39 00:01:40,09 --> 00:01:42,08 It instantly vanishes. 40 00:01:42,08 --> 00:01:46,05 It's not deleted, it's not gone, it's just hidden. 41 00:01:46,05 --> 00:01:47,06 To bring it back, 42 00:01:47,06 --> 00:01:50,06 all I have to do is right-click on any tab. 43 00:01:50,06 --> 00:01:53,07 And from here, I can choose Unhide. 44 00:01:53,07 --> 00:01:56,02 In fact, if there are no hidden tabs, 45 00:01:56,02 --> 00:01:58,04 then Unhide is going to be grayed out 46 00:01:58,04 --> 00:02:00,05 and I wouldn't even be able to click on it. 47 00:02:00,05 --> 00:02:02,09 So if you do see this option available, 48 00:02:02,09 --> 00:02:04,09 that's a good visual cue for you 49 00:02:04,09 --> 00:02:07,09 that there is a hidden sheet or tab in there somewhere. 50 00:02:07,09 --> 00:02:09,06 I'll click Unhide. 51 00:02:09,06 --> 00:02:12,00 And if I have multiple tabs hidden in, 52 00:02:12,00 --> 00:02:14,07 which I certainly can, they would all be listed here. 53 00:02:14,07 --> 00:02:18,01 .I can choose which one I want to unhide. 54 00:02:18,01 --> 00:02:23,00 So I'll select it, click OK, and it's back just like that.