6 hours 3 minutes
in this lesson, I will be talking about using styles and creating custom styles and style by definition is set off a cell or group of cells properties
that can be put together a set
and reapplied to any given cell in the worksheet.
So whatever you have
in these cells, for example,
you can say OK, this is a new style and I will apply it to some other cells.
And if you go to the styles portion of the ribbon here,
you have some pretty fine styles. Like, for example, this cell
if you click a normal, all the former king of the border are gone or if you click here and you could come good, it will change the former thing off this sell regardless of what you actually wanted to be
now a ll. These pretty fine styles are usually not used. People want to have them their own way. So let's do the undue off this last one.
Let's elect these cells here
and then let's ah, let's go to some other pretty fine styles.
So, for example,
you have teams, cells styles like you have heading
a similar thing like inward. If you have if you are familiar with these. So if you, for example,
won t cells to have some kind of style that is called Total,
it can be like this. And then you can also,
changed these cells
to have, ah
to be lighter or darker.
that's that's like this. So it will reveal whatever we have done to these cells and remain
and put their the former thing that is defined by this
light blue 20%
besides those predefined styles,
you can also
create the new cell style. So you call it, Let's go, it's I bury
and let's get conform it.
And for example, we want to use the form that we use here
in Siberia a lot, which is called Assistant,
and we wanted
from size to be 12
and we want the color to be very dark blue,
and we want Phil to be white.
And if you click here,
so what styles can include or you can say we don't want it. Included is the
let's say number type or data type in the cell. It can be alignment. It can be fun size and everything about the front than the border. Then feel of the the cell and protection.
Let's say protection. We don't want it there.
And let's do some other things about this.
Let's Ah, let's changed, Theologian Mint And we want a horizontal Toby left and we're vertical, Toby centered.
And we won't text to be wrapped. And, uh,
we have cyber style
on dhe. Uh,
So if you select these cells
So if you feel like the cells and we clicked here
include Kansai Berry, we get their style here. So you see, the front is now assistant the cholera if we die. If something is this,
this is a number. But if it I'd text,
it will do the automatic text wrapping because we set that in style. And if you click here and you go to cyber, it will automatically change
the appearance of this cell. You see that all the sub scripts off the squares have been removed because this is not the part off style. So you have to be careful about these things, or you have to just do it and then manually change things for example,
again like this.
So to sum separate script
superscript and you just look okay and it's back to work this
so it's no longer when you look into this cell,
it's no longer fully compliant to cyber restyle,
but it's working. So this is how you create styles, and this is how you apply styles to cells.
So if we want everything to change back to what it was before, we just click a normal style, which is a basic one, and everything goes back.