6 hours 3 minutes
So let's continue this lesson with the more properties that the cell can have. And if we go again to excel and we again right, click on this cell and do the form it sells,
we can go to the next section off for mating cell's window, which is front and some of these things you have already in the front portion off the ribbon. But here you have it in detail, so you kept the effects off. The
first off you have all the funds and the phone
you can choose.
Then you have fun style, which is the usual regular italic boulder boulder. Delicate can have size. You have the
corner of the text and then you have some other effects, like strike through superscript or sub script, for example. Um, let's just cancel it and say We want this to be a
square plus B square. So it's just the text is not the function
and then be click enter and then we go here
so, like certain
part of this.
So, for example, here and then we go to superscript
and we do that again.
You get all of this again with clicking on this
from setting button on the ribbon
and then you get it to look like a proper mathematic formula, with the square number two being shifted above the regular text and reduced in size.
So this is a superscript. It's hasn't changed. Decide. So it's still 11. But we have changed the properties of that particular number or letter in the
in the cell.
So looks, uh, go on.
And, uh, we have
the options to change. A thing is all about front. It's enough. And then you have borders. So here you have representation of a cell
and you can switch on and off
external borders because this is just one cell, and also you can change the
type off the line so you can change the with. And you can also change the type of the line. So, for example, you wanted to be double line like here. Just this one. Not that one.
We want, for example, this one, Toby, This one
and you can also change the color of the line so it can be,
for example, read.
And then you click on this one. And this one is red.
Um, you have the quick presets none outline. And inside and inside in this case makes no sense because we have one cell.
But here is what happens if we
select multiple cells and then you click on form it sells,
and then we click on outline and glitzy.
The incline is this
and then when inside line to be thinner.
that's pretty much it.
And then, for example, if this is some kind of table and we want here to have a
some kind of total grand total,
then we sell it just these three cells and go to form its cells. And we want this lying to be double. So you click on the line type and click on your line. You want to have these properties and gets like this.
So this is nice to improve the total look off your
actual sheet. So this looks very, very professional.
And now here, for example, this text has gone a little bit to the two
upside of the cell
so we can hear, go to the alignment and say vertical alignment is center,
and now it's going to be fixed and look very, very nice.
except for the borders we have just one more thing
to do, which is Phil. So you can fill the cell. You can make it have some color.
And if you click this, it will be like this.
also, it is a common thing if you have some. If you have a lot of later in your table,
you can click here and do the same thing for example here and then do every second line that color.
so the, uh, the even lines there, for example light
blue and the old lines remained white. And then, for example, this one can be even
more effective. So dark blue
with white text.
So we type something here like 1234
It is really visible because you want to emphasize what is in this line because it represents the some off everything that is, for example, in this stable.
So this is all about formatting text
I have for mating cells and form it in texting those cells.
and this is the end off this lesson
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered