Hi, everyone, and welcome again.
Today, we are going to discuss sheet options, the objectives of this picture is knowing sheet options
there to sheet protect sheet and the color sheets.
Oh, the story begins with right, click on the sheet, lets let's get practically do Microsoft Excel
sheet in your desktop.
Right click new.
Microsoft Excel work sheet, when you open Microsoft Excel work book, you will find only one sheet
and this is by default.
OK, right, click on this sheet.
The first thing you can do is to rename the sheet like that.
I want to rename the sheet by Haithem.
OK, OK.
Right, click on the sheet again, you can insert you can insert new worksheet.
OK, and this is our new worksheet.
Also, you can rename this worksheet, right, click rename.
I will call this shit El Musallam, OK, OK, right, click insert, you can also insert chart like
this chart and we will explain chart in detail in the next lecture's.
Also, you can insert macros of macro and we will discuss macro and visual basic programming in details
in the advanced stage of discourse.
Also, you can insert Microsoft Excel dialogue.
Also, we will discuss this dialog in detail in the advanced stage of discourse.
Moreover, you can delete these sheets if you select dialogue, control macro, pressing control chart
and right click, you can delete all these sheets by one click.
Just select delete it, ok?
OK.
And here is our workbook again.
Consists of only two sheets.
I've mentioned before we have discussed that Workbook X and workbook consists of several or only one
worksheet, and the worksheet consists of a group of cells.
OK, workbook, then worksheets, then silts.
OK, let's get back to our sheet operations.
Right.
Click on the sheet.
You can move and cubie the sheet.
If I make any indentation on this like this color and I want to cover this sheet right click right click
move or cubie and select create a copy.
So Haythem two, this is a copy of this sheet.
Haythem two is a cubby of Haythem Let's rename it by Haythem Cubie.
OK also if you want to move the sheet to another workbook, I open another workbook called Smarter Excel.
If I want to move this sheet Haithem cubie to another workbook just select the destination workbook
smarter Excel and press.
OK.
So the sheep have been moved to the destination workbook.
OK, this is Hisam Cubie.
Let's get back to our original sheet.
Also, if you want to move the sheet with a cubby, just select right click move, create a cubie and
select a destination.
OK.
Haithem have been moved and the original cubie.
Also have a cubie or original copy of the Haythem sheet.
OK, this is a difference between chick here or not create a cubie or not.
OK, ok, right.
Click on Cheat.
You can view CWD of this sheet and we will discuss coding and visualizing programming and the advanced
stage of this course.
So stay tuned.
Also, if you have multiple sheets in this case and you want to move the position of sheet to right
or left, just click and drag and drop like that, I can move all the sheet here.
I can move the sheet, I can move the sheet to lift, I can move this sheet to the right.
OK.
OK, also you have this Ara's to.
Right and to black left, OK?
This is about moving or shifting sheets.
Also, you can protect the sheet, right, click protect sheet.
You can check for you can check for the whole user and the level of this sheet, if you want to protect
formula, columns, roads, check whatever you want, just enter a password for your sheet.
We will enter one, OK, and re-enter the password here.
OK, well, our sheet now is protected and you can't quantify anything about what you have selected
and checked without permission.
Now you should have been protected and the user can't modify anything about.
You have checked in the list without password.
OK, so let's try.
If I want to write anything, there is a message.
The cell or chart you are trying to change is unprotected sheet to make a change and protected the sheet.
You might to be requested to enter a password.
So you must enter a password to change and to make changes in this sheet.
So let's right click and unprotected and enter password one.
So now I can modify and make changes and write and make any operation in our sheet.
This is about protecting the sheet.
OK, also right click.
You can change the theme and the color of sheet app.
If this is an important step, I will.
Change its color to red, and if this and shit, I can color this shit to blue.
So this is colourised sheet.
OK, you can colourised the tapes also, you can hide the sheet.
This sheet have been hidden and if I want to unhide the sheet right, click and hide.
OK, the she'd have been on unhidden again, right, click select all sheets if you want to select all
sheets and they want to delete old sheets.
There is a message any workbook must have only one, at least only one work sheet so you can't delete
all sheets.
Let's summarize this lecture.
We have discussed workbook operations and all operation starts with right.
Click on that work sheet.
You can insert worksheet chart macro dialog, OK?
Also you can delete the worksheet, you can rename the work sheet, you can move or copy the work sheet.
You can create a copy or not.
You can send this work sheet to another destination, to another workbook.
OK, also you can view the code that Microsoft code and visual basic could also you can protect the
sheet.
Just select the features you want to protect and set a password.
OK, and the user can modify anything without this password.
Also.
You can change that color from here and sit whatever color you want, you can hide the sheet and then
hide the sheet.
You can select old sheets.
Today's quote by Steve Jobs.
The court is your time is limited, so don't waste it living someone else's life, so set your goal,
set your own goal, set your own business, set your own work and don't listen for any one.
Just respect yourself, your mind, your thought, and work hard to achieve your goals and your objectives.
Just do it, just practice, just make effort to muster the skills you want to have, and this is our
communication channels, please contact us if you have any question.
If you want any help or assistance, please contact us about this is communication channel.
I'm happy share and thank you and see you in the next lecture.
Good bye.