Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
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
00:13
that can be put together a set
00:17
and reapplied to any given cell in the worksheet.
00:23
So whatever you have
00:26
in these cells, for example,
00:28
you can say OK, this is a new style and I will apply it to some other cells.
00:34
And if you go to the styles portion of the ribbon here,
00:38
you have some pretty fine styles. Like, for example, this cell
00:43
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
00:57
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.
01:10
Let's elect these cells here
01:11
and then let's ah, let's go to some other pretty fine styles.
01:18
So, for example,
01:19
you have teams, cells styles like you have heading
01:23
a similar thing like inward. If you have if you are familiar with these. So if you, for example,
01:30
won t cells to have some kind of style that is called Total,
01:34
it can be like this. And then you can also,
01:40
ah,
01:42
changed these cells
01:46
to have, ah
01:49
to be lighter or darker.
01:51
And
01:53
that's that's like this. So it will reveal whatever we have done to these cells and remain
02:00
and put their the former thing that is defined by this
02:06
light blue 20%
02:08
accent style.
02:10
So, uh,
02:14
besides those predefined styles,
02:17
you can also
02:19
create the new cell style. So you call it, Let's go, it's I bury
02:25
and let's get conform it.
02:30
And for example, we want to use the form that we use here
02:35
in Siberia a lot, which is called Assistant,
02:42
and we wanted
02:44
from size to be 12
02:46
and we want the color to be very dark blue,
02:51
and we want Phil to be white.
02:55
And if you click here,
02:59
so what styles can include or you can say we don't want it. Included is the
03:06
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.
03:19
Let's say protection. We don't want it there.
03:22
And let's do some other things about this.
03:25
Let's Ah, let's changed, Theologian Mint And we want a horizontal Toby left and we're vertical, Toby centered.
03:36
And we won't text to be wrapped. And, uh,
03:39
we have cyber style
03:43
on dhe. Uh,
03:45
it's no.
03:51
So if you select these cells
04:01
So if you feel like the cells and we clicked here
04:05
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,
04:15
this is a number. But if it I'd text,
04:18
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
04:30
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,
04:49
again like this.
04:54
So to sum separate script
04:58
superscript and you just look okay and it's back to work this
05:01
so it's no longer when you look into this cell,
05:06
it's Ah,
05:09
it's no longer fully compliant to cyber restyle,
05:12
but it's working. So this is how you create styles, and this is how you apply styles to cells.
05:21
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.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor