1
00:00:02,240 --> 00:00:07,920
To move a worksheet all you have to do is click with your mouse on the worksheet name and then drag.

2
00:00:08,220 --> 00:00:09,560
You see that paper icon?

3
00:00:09,570 --> 00:00:13,540
You see that fat arrow? That indicates where it's going to drop

4
00:00:13,650 --> 00:00:21,630
once you let go of your mouse. So click, drag, let go. To make a copy of this worksheet hold down the control

5
00:00:21,630 --> 00:00:28,410
key before you start dragging. Notice this time we get a plus sign inside that paper icon.

6
00:00:28,410 --> 00:00:34,110
Now let go of your mouse while you still hold down the control key and you get a copy of your worksheet.

7
00:00:34,560 --> 00:00:40,290
To delete the copy, right mouse click and select delete. Excel wants to check with you if you're sure

8
00:00:40,290 --> 00:00:44,010
you want to delete. Just press enter or click on delete.

9
00:00:44,130 --> 00:00:50,670
What if you want to move this sheet to another workbook? Right mouse click on the sheet, select move or

10
00:00:50,670 --> 00:00:57,000
copy, from here you can select the other workbook. If you have another workbook open you're going to

11
00:00:57,000 --> 00:00:58,690
see its name pop up here.

12
00:00:58,710 --> 00:01:04,680
You can select it, if you want to move it to a new workbook select new book.

13
00:01:04,680 --> 00:01:10,620
If you click on okay it's going to remove it from this workbook and add it to that new book.

14
00:01:10,620 --> 00:01:16,380
If you want a copy of it make sure you put a checkmark for create a copy and then click on OK.

15
00:01:16,520 --> 00:01:23,040
That's going to make a copy of it and add that copy to this new workbook. So this workbook is a new

16
00:01:23,040 --> 00:01:24,510
one called Book 1.

17
00:01:24,600 --> 00:01:31,610
If I use a shortcut key control+tab I get back to my previous file. To hide a sheet,

18
00:01:31,620 --> 00:01:34,460
you just have to right mouse click and select hide.

19
00:01:34,950 --> 00:01:38,890
So hiding is not deleting the worksheet, it's still there.

20
00:01:38,910 --> 00:01:42,330
It's just hidden from view. To unhide it

21
00:01:42,330 --> 00:01:45,930
you have to right mouse click and select unhide.

22
00:01:45,960 --> 00:01:49,050
You get a list of sheets here that are hidden.

23
00:01:49,080 --> 00:01:53,630
You have to select them one by one and then click on OK to unhide them.

24
00:01:53,790 --> 00:01:56,560
If you want to hide a bunch of sheets hold down

25
00:01:56,570 --> 00:02:04,110
The control key before you select the sheets, right mouse click and hide. You can select many sheets

26
00:02:04,140 --> 00:02:06,360
and do other operations in them as well.

27
00:02:06,360 --> 00:02:12,490
You can select them and move them to another workbook or make a copy of them for another workbook.

28
00:02:12,540 --> 00:02:19,740
You can also adjust the tab color of the sheets by selecting a color from here. To de-select the sheets

29
00:02:19,860 --> 00:02:22,420
just click on another worksheet.

30
00:02:22,470 --> 00:02:28,580
You can also hide and unhide by going to the format tab here. Under visibility

31
00:02:28,620 --> 00:02:35,520
you can hide sheets and unhide. If you see that unhide is not clickable it means you don't have any

32
00:02:35,520 --> 00:02:37,820
sheets here that are hidden.

33
00:02:37,820 --> 00:02:42,250
Another tip for worksheet navigation is to use the arrows here.

34
00:02:42,270 --> 00:02:48,990
But if you have a workbook that includes a lot of worksheets it might be a pain to always navigate using

35
00:02:48,990 --> 00:02:50,460
the arrow keys.

36
00:02:50,460 --> 00:02:55,180
What you can do here is to right click to see all the sheets.

37
00:02:55,210 --> 00:03:00,800
So with a right click you get this pop up, you can select the sheet name, click on OK

38
00:03:00,810 --> 00:03:03,240
and it's going to jump to that sheet.

39
00:03:03,420 --> 00:03:03,800
Okay.

40
00:03:03,810 --> 00:03:10,440
So these are the different ways you can copy, move, hide, and unhide worksheets and also navigate to different

41
00:03:10,440 --> 00:03:11,880
sheets in your workbook.