1 00:00:13,960 --> 00:00:15,460 Hi, everyone, and welcome again. 2 00:00:16,630 --> 00:00:25,510 Today, we are going to discuss sheet options, the objectives of this picture is knowing sheet options 3 00:00:25,860 --> 00:00:30,100 there to sheet protect sheet and the color sheets. 4 00:00:32,090 --> 00:00:38,690 Oh, the story begins with right, click on the sheet, lets let's get practically do Microsoft Excel 5 00:00:38,690 --> 00:00:41,630 sheet in your desktop. 6 00:00:42,200 --> 00:00:43,910 Right click new. 7 00:00:45,240 --> 00:00:57,900 Microsoft Excel work sheet, when you open Microsoft Excel work book, you will find only one sheet 8 00:00:58,650 --> 00:01:00,060 and this is by default. 9 00:01:00,840 --> 00:01:04,500 OK, right, click on this sheet. 10 00:01:05,240 --> 00:01:10,920 The first thing you can do is to rename the sheet like that. 11 00:01:11,580 --> 00:01:15,540 I want to rename the sheet by Haithem. 12 00:01:18,020 --> 00:01:19,220 OK, OK. 13 00:01:20,860 --> 00:01:29,860 Right, click on the sheet again, you can insert you can insert new worksheet. 14 00:01:30,670 --> 00:01:35,530 OK, and this is our new worksheet. 15 00:01:37,120 --> 00:01:44,020 Also, you can rename this worksheet, right, click rename. 16 00:01:45,970 --> 00:02:00,280 I will call this shit El Musallam, OK, OK, right, click insert, you can also insert chart like 17 00:02:00,280 --> 00:02:05,410 this chart and we will explain chart in detail in the next lecture's. 18 00:02:05,980 --> 00:02:17,140 Also, you can insert macros of macro and we will discuss macro and visual basic programming in details 19 00:02:17,170 --> 00:02:19,040 in the advanced stage of discourse. 20 00:02:19,630 --> 00:02:25,330 Also, you can insert Microsoft Excel dialogue. 21 00:02:26,140 --> 00:02:31,390 Also, we will discuss this dialog in detail in the advanced stage of discourse. 22 00:02:34,400 --> 00:02:48,620 Moreover, you can delete these sheets if you select dialogue, control macro, pressing control chart 23 00:02:48,830 --> 00:02:55,100 and right click, you can delete all these sheets by one click. 24 00:02:55,460 --> 00:02:59,770 Just select delete it, ok? 25 00:03:00,010 --> 00:03:00,410 OK. 26 00:03:01,610 --> 00:03:04,550 And here is our workbook again. 27 00:03:04,550 --> 00:03:07,190 Consists of only two sheets. 28 00:03:09,700 --> 00:03:18,400 I've mentioned before we have discussed that Workbook X and workbook consists of several or only one 29 00:03:18,910 --> 00:03:24,730 worksheet, and the worksheet consists of a group of cells. 30 00:03:24,940 --> 00:03:30,280 OK, workbook, then worksheets, then silts. 31 00:03:30,470 --> 00:03:35,560 OK, let's get back to our sheet operations. 32 00:03:35,740 --> 00:03:35,980 Right. 33 00:03:35,980 --> 00:03:36,820 Click on the sheet. 34 00:03:38,350 --> 00:03:40,480 You can move and cubie the sheet. 35 00:03:40,930 --> 00:03:52,240 If I make any indentation on this like this color and I want to cover this sheet right click right click 36 00:03:52,510 --> 00:03:55,870 move or cubie and select create a copy. 37 00:03:57,460 --> 00:04:00,910 So Haythem two, this is a copy of this sheet. 38 00:04:02,860 --> 00:04:08,860 Haythem two is a cubby of Haythem Let's rename it by Haythem Cubie. 39 00:04:09,500 --> 00:04:22,510 OK also if you want to move the sheet to another workbook, I open another workbook called Smarter Excel. 40 00:04:22,840 --> 00:04:32,740 If I want to move this sheet Haithem cubie to another workbook just select the destination workbook 41 00:04:32,950 --> 00:04:35,560 smarter Excel and press. 42 00:04:35,560 --> 00:04:35,950 OK. 43 00:04:37,680 --> 00:04:44,580 So the sheep have been moved to the destination workbook. 44 00:04:44,790 --> 00:04:48,030 OK, this is Hisam Cubie. 45 00:04:49,050 --> 00:04:51,070 Let's get back to our original sheet. 46 00:04:52,270 --> 00:05:01,870 Also, if you want to move the sheet with a cubby, just select right click move, create a cubie and 47 00:05:01,870 --> 00:05:03,160 select a destination. 48 00:05:03,670 --> 00:05:04,180 OK. 49 00:05:05,250 --> 00:05:08,040 Haithem have been moved and the original cubie. 50 00:05:09,320 --> 00:05:14,060 Also have a cubie or original copy of the Haythem sheet. 51 00:05:14,100 --> 00:05:19,880 OK, this is a difference between chick here or not create a cubie or not. 52 00:05:19,960 --> 00:05:24,020 OK, ok, right. 53 00:05:24,020 --> 00:05:25,030 Click on Cheat. 54 00:05:25,850 --> 00:05:34,130 You can view CWD of this sheet and we will discuss coding and visualizing programming and the advanced 55 00:05:34,280 --> 00:05:35,550 stage of this course. 56 00:05:35,780 --> 00:05:37,250 So stay tuned. 57 00:05:40,020 --> 00:05:50,070 Also, if you have multiple sheets in this case and you want to move the position of sheet to right 58 00:05:50,070 --> 00:05:57,480 or left, just click and drag and drop like that, I can move all the sheet here. 59 00:05:59,840 --> 00:06:10,130 I can move the sheet, I can move the sheet to lift, I can move this sheet to the right. 60 00:06:10,470 --> 00:06:10,950 OK. 61 00:06:11,630 --> 00:06:14,390 OK, also you have this Ara's to. 62 00:06:16,400 --> 00:06:19,090 Right and to black left, OK? 63 00:06:19,670 --> 00:06:22,910 This is about moving or shifting sheets. 64 00:06:24,320 --> 00:06:31,340 Also, you can protect the sheet, right, click protect sheet. 65 00:06:34,050 --> 00:06:41,940 You can check for you can check for the whole user and the level of this sheet, if you want to protect 66 00:06:41,940 --> 00:06:50,120 formula, columns, roads, check whatever you want, just enter a password for your sheet. 67 00:06:50,340 --> 00:06:55,970 We will enter one, OK, and re-enter the password here. 68 00:06:56,250 --> 00:07:03,600 OK, well, our sheet now is protected and you can't quantify anything about what you have selected 69 00:07:03,600 --> 00:07:07,350 and checked without permission. 70 00:07:08,190 --> 00:07:15,260 Now you should have been protected and the user can't modify anything about. 71 00:07:15,330 --> 00:07:19,500 You have checked in the list without password. 72 00:07:19,590 --> 00:07:22,110 OK, so let's try. 73 00:07:23,370 --> 00:07:25,860 If I want to write anything, there is a message. 74 00:07:26,160 --> 00:07:31,830 The cell or chart you are trying to change is unprotected sheet to make a change and protected the sheet. 75 00:07:31,830 --> 00:07:34,610 You might to be requested to enter a password. 76 00:07:34,740 --> 00:07:41,790 So you must enter a password to change and to make changes in this sheet. 77 00:07:41,820 --> 00:07:49,230 So let's right click and unprotected and enter password one. 78 00:07:50,430 --> 00:07:57,780 So now I can modify and make changes and write and make any operation in our sheet. 79 00:07:57,840 --> 00:07:59,970 This is about protecting the sheet. 80 00:07:59,980 --> 00:08:02,400 OK, also right click. 81 00:08:02,940 --> 00:08:06,740 You can change the theme and the color of sheet app. 82 00:08:07,890 --> 00:08:10,260 If this is an important step, I will. 83 00:08:11,460 --> 00:08:23,430 Change its color to red, and if this and shit, I can color this shit to blue. 84 00:08:24,710 --> 00:08:27,720 So this is colourised sheet. 85 00:08:27,740 --> 00:08:33,920 OK, you can colourised the tapes also, you can hide the sheet. 86 00:08:35,390 --> 00:08:42,860 This sheet have been hidden and if I want to unhide the sheet right, click and hide. 87 00:08:43,890 --> 00:08:54,120 OK, the she'd have been on unhidden again, right, click select all sheets if you want to select all 88 00:08:54,120 --> 00:08:55,890 sheets and they want to delete old sheets. 89 00:08:58,530 --> 00:09:07,260 There is a message any workbook must have only one, at least only one work sheet so you can't delete 90 00:09:07,260 --> 00:09:08,080 all sheets. 91 00:09:09,810 --> 00:09:12,140 Let's summarize this lecture. 92 00:09:12,540 --> 00:09:19,980 We have discussed workbook operations and all operation starts with right. 93 00:09:19,980 --> 00:09:21,930 Click on that work sheet. 94 00:09:22,410 --> 00:09:28,440 You can insert worksheet chart macro dialog, OK? 95 00:09:29,520 --> 00:09:38,520 Also you can delete the worksheet, you can rename the work sheet, you can move or copy the work sheet. 96 00:09:38,520 --> 00:09:40,530 You can create a copy or not. 97 00:09:40,710 --> 00:09:47,520 You can send this work sheet to another destination, to another workbook. 98 00:09:47,670 --> 00:09:58,950 OK, also you can view the code that Microsoft code and visual basic could also you can protect the 99 00:09:58,950 --> 00:09:59,340 sheet. 100 00:10:02,870 --> 00:10:09,650 Just select the features you want to protect and set a password. 101 00:10:10,040 --> 00:10:15,050 OK, and the user can modify anything without this password. 102 00:10:17,000 --> 00:10:17,540 Also. 103 00:10:19,570 --> 00:10:27,280 You can change that color from here and sit whatever color you want, you can hide the sheet and then 104 00:10:27,280 --> 00:10:28,240 hide the sheet. 105 00:10:28,390 --> 00:10:30,250 You can select old sheets. 106 00:10:32,080 --> 00:10:34,840 Today's quote by Steve Jobs. 107 00:10:35,940 --> 00:10:44,220 The court is your time is limited, so don't waste it living someone else's life, so set your goal, 108 00:10:44,460 --> 00:10:51,570 set your own goal, set your own business, set your own work and don't listen for any one. 109 00:10:51,720 --> 00:11:00,720 Just respect yourself, your mind, your thought, and work hard to achieve your goals and your objectives. 110 00:11:03,890 --> 00:11:12,980 Just do it, just practice, just make effort to muster the skills you want to have, and this is our 111 00:11:12,980 --> 00:11:16,940 communication channels, please contact us if you have any question. 112 00:11:17,150 --> 00:11:22,820 If you want any help or assistance, please contact us about this is communication channel. 113 00:11:23,420 --> 00:11:27,340 I'm happy share and thank you and see you in the next lecture. 114 00:11:27,650 --> 00:11:28,550 Good bye.