00:00Peace be upon you and welcome to a new video from Al Excel.
00:05In which we will learn about cell formats, especially fonts.
00:10We can format the fonts to work professionally in Excel.
00:16For the things we want to differentiate
00:19How do you say this? Let's see together.
00:21If I have cells that I need to have the line itself be under one line or under two lines, or the text is written on it. If I want it to be under the line or above the line, what do we do? Come on, let’s see.
00:36For example, I will specify here, let’s say on this cell, right click and format cells, but my wife will choose the tab called “Font” for it.
00:46Hoda, I tell him that my cover, if he wants it to be under my words, is a line, for example, a single line, and the color of the line under it, as you can see, should appear like this.
00:58Can I tell him no, let the color of the line below it, for example, be red, and it will remain that way
01:02And I tell him, for example, to make the font itself bold, which is what we call bold.
01:08Can I also make size 26?
01:12From here I choose the type of font I want, for example this type of font
01:19And I will tell him, “Okay.” I will write him any word, for example, “The Beginning.”
01:24You see how it looks like when you talk to me?
01:29Ok, let's try something else. If you want the text to have two lines under it instead of one, right click and format the cells.
01:37Also, should I make it the same type of font in front of me or not? I don’t remember, or what.
01:43Let's choose this font and choose a color for it, for example this color
01:48This time I will tell him that the underlining is double, for example.
01:52It will stay like this and make it dark
01:5626 sizes OK
02:01I will write him the end, for example.
02:04Do you see the difference between the fonts? How do I do that? We make a big difference in our design depending on what each person wants to use.
02:14Ok, come here, let's try something new in the fonts. Right click, format cells.
02:19Should we try the italic line, okay? We choose for it, for example, the form of our framing, individual accounting, in this way
02:30And the color is purple, for example, large size, so we can see.
02:36We will also write the beginning for him
02:40Do you see how it looks? Each one has a completely different look than the one before it.
02:46Okay, let's also try to see if there is something else in my line.
02:52Let's try right-clicking on cells together.
02:55This time I will start choosing these things
02:58What are these things that have a line in the middle that looks like it was written on?
03:01You see it will be like this?
03:03We change its color, for example, to green.
03:08Size 26
03:11We try it finally
03:16It doesn't look that strong
03:20But what does it mean?
03:22We have very clear differences.
03:25These are our mechanisms
03:26I have a line, above the line or below the line
03:29What we call subscript and superscript
03:32Click me if you want to format the cells
03:35Under this line, do you know what chemical symbols are?
03:39When I tell him, for example, we symbolize water H2O
03:41Falto or number two remains under the line
03:43I'll tell him it's low
03:45Do you see how it will be?
03:46I'll leave it at 26
03:51The size remains the same.
03:53We choose this color for him, for example.
03:55Let's leave it at the beginning
03:57I don't know if a minority is commenting on this.
03:59You see the difference now?
04:01Between the regular line and the one below the line
04:03Under the line
04:05Come on, we have the same needs
04:07Let's try it above the line
04:09Click me cell formatting
04:11This time we will choose the high one
04:13Who will come above the line
04:15I will choose an example for him
04:17Font color
04:19Okay
04:21Okay
04:23okay
04:25The same goes for the 26th one.
04:27I will tell him I agree
04:29Choose another line for him
04:31Like this
04:33Like this
04:37the end
04:39Do you see the difference between
04:41Above the line and below the line
04:43It is the high, the low, and the regular line.
04:45These are the basic growths.
04:47Which lines do we have?
04:49Excel, we choose any style
04:51We are back
04:53To start with, we are
04:55We write and create our own tables professionally.
04:57We reached the shape we are used to
04:59The Lord is canceled
05:01Thanks
Comments