Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
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,
00:15
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
00:30
first off you have all the funds and the phone
00:34
you can choose.
00:35
Then you have fun style, which is the usual regular italic boulder boulder. Delicate can have size. You have the
00:42
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
00:57
square plus B square. So it's just the text is not the function
01:03
and then be click enter and then we go here
01:10
and, uh
01:11
so, like certain
01:17
part of this.
01:18
So, for example, here and then we go to superscript
01:23
and we do that again.
01:27
You get all of this again with clicking on this
01:30
from setting button on the ribbon
01:34
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.
01:49
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
02:04
in the cell.
02:06
So looks, uh, go on.
02:08
And, uh, we have
02:12
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
02:23
and you can switch on and off
02:28
external borders because this is just one cell, and also you can change the
02:35
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.
02:46
We want, for example, this one, Toby, This one
02:51
and you can also change the color of the line so it can be,
02:57
for example, read.
02:59
And then you click on this one. And this one is red.
03:01
Um, you have the quick presets none outline. And inside and inside in this case makes no sense because we have one cell.
03:09
But here is what happens if we
03:14
select multiple cells and then you click on form it sells,
03:19
and then we click on outline and glitzy.
03:22
The incline is this
03:23
and then when inside line to be thinner.
03:28
And, uh,
03:30
that's pretty much it.
03:31
And then, for example, if this is some kind of table and we want here to have a
03:37
some kind of total grand total,
03:39
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.
03:53
So this is nice to improve the total look off your
04:00
actual sheet. So this looks very, very professional.
04:04
And now here, for example, this text has gone a little bit to the two
04:11
to do
04:13
upside of the cell
04:15
so we can hear, go to the alignment and say vertical alignment is center,
04:20
and now it's going to be fixed and look very, very nice.
04:26
So
04:27
except for the borders we have just one more thing
04:31
to do, which is Phil. So you can fill the cell. You can make it have some color.
04:38
And if you click this, it will be like this.
04:41
And here
04:42
also, it is a common thing if you have some. If you have a lot of later in your table,
04:47
you can click here and do the same thing for example here and then do every second line that color.
04:58
And uh
05:00
so the, uh, the even lines there, for example light
05:03
blue and the old lines remained white. And then, for example, this one can be even
05:13
more effective. So dark blue
05:15
with white text.
05:17
So we type something here like 1234
05:21
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.
05:31
So this is all about formatting text
05:35
I have for mating cells and form it in texting those cells.
05:41
Um,
05:42
and this is the end off this lesson

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