hello and welcome friends in this video we are going to
work on two things first we are going to see format painter
let's see what it is and second is clipboard what is
clipboard let me open excel we know how to open excel from
windows plus s
I opened it here what I have to do you can see an option ok
we know that in home tab there is a group which is called
clipboard group in clipboard group there is a feature
format painter apart from this clipboard we will see what
is clipboard sometime you have copied and pasted things so
you know when you copied it once and then where you have to
paste it in between that it will be stored somewhere it
will be saved that place is called clipboard so on
clipboard you can see all those things
I will show you before that we know that cut and copy we
generally use ok let's see format painter option how it is
used so what we do in this cell I increase its size and
from here also I increase ok what I put here
I put here name when I put my name it is very small what I
have to do
I have to increase its name so what I do in clipboard group
there is a font group ok in font group what we do in font
group I click here and this menu will be down and I will
see all things these are fonts
I can select any font you can see these changes right I
increase its size
I zoom it ok now
now it will be more visible
I select it again
what happened
Algerian what we do I select this font
I increase its size like I increase its size ok from here
also this this we can increase its size directly and
decrease as I show you keep clicking it will increase ok if
I want to bold
I click on bold if I want italic
I click on italic if I want to underline
I click on underline it will be underline can you see this
bucket by clicking on this bucket its background will
change to background color like we click on it ok or I
don't want yellow color
I want some other color you can select this color is good
yellow is good select yellow after this this is looking
good this is in black
I want to change its font color I can do it from here ok I
do it
I make it green it is not looking good but it will work
after doing this now my friend saw this he said I want this
his name is Deepak
Deepak wants this color in background now what I can do
I can go again and again this size then bold who will do
like this no one will do like this let's see what is the
use of format painter so what I did
I put my friend's name
I put
Deepak now I want to apply color or font on this so what I
will do
I will click on format painter can you see it is selected
this is called active cell which I was talking about
I selected this cell here you can see with plus sign it is
going like a brush you can leave this brush on any cell it
will be same
I will click on this can you see
Deepak is same but Deepak is out of this cell we know how
to increase cell we will go between D and E and here we can
see arrow sign we can click on left button and here we can
see how format painter works after format painter we have
clipboard when we copy and paste clipboard works in between
if I expand clipboard we can see clipboard but here we
can't see anything first of all clipboard feature is
neither Microsoft Excel nor Word it is Windows feature
I will show you for example let's open chrome
I will open
Microsoft Wikipedia page
I have opened Wikipedia page now I have to copy this first
paragraph
I have copied it with ctrl plus c
I have copied it now I come to excel can you see can you
see here I have copied it now I have to paste it here it is
too much it will not come in this cell you have to increase
size for example increase size from here from row
I have increased size and after selecting
I have clicked on it you can see it is still going out now
we can increase size
I will tell you shortcut to increase size if you do ctrl
plus z it will undo what happens if you write something and
you want to remove it you can use ctrl plus z for example
we have used clipboard we can see this we can see it is
going out we have to increase size of d cell
after increasing size of d cell it is enough we have
understood how to copy remove it from ctrl plus z now let's
copy something for example
I will write a name again for example neeraj after writing
neeraj
I have copied it from ctrl plus c
I will select it from mouse after selecting
I have copied it from ctrl plus c you can see
I have not pasted it but before pasting
I have copied it from clipboard now how much it can do it
can keep 24 items by copying for example
I have option to paste by right clicking from mouse now it
is pasted now suppose
I don't want to paste
I go to this cell
I have clipboard now how much ever I click on it neeraj
will come now we have understood what is clipboard now I
will show you in word
I will show you in clipboard you can see these two things
let's close it
I don't want to save it ok so I will close it and to open
word is also simple press windows plus s and I have opened
word lets see inside word by opening clipboard
that does it work or not
this is wordpad open we have to open winword do not open
wordpad we have to open winword and to open winword we will
put winword ok and my is opened now lets open it so lets go
to clipboard and see here niraj is written we clicked on
niraj niraj is shown ok so you will do it again and again
ok so we understand this feature is windows feature lets
see here ok here I have put niraj
ok I have copied this ctrl c copy now here also copy is
done now lets go to excel and see here no we have opened
excel we went inside excel we found niraj we clicked on it
we increased the size of cell ok now we understand how
format painter works and how clipboard works so that's it
for today's video till next video what we have to do keep
on revising ok