hello and welcome to our new video
in this video we are going to learn
how to apply themes in excel
now what is themes
we have seen this option
in mobile phone many times
when we apply a theme
then what it does
font in mobile phone
or styles
or size of icon
it changes everything
so we are going to see
same thing in mobile
we are going to see same thing in excel
that does themes work in excel
like in mobile phone
and where we get to see this option
in which tab
we get to see
so first of all
we open excel
when we open excel
I have some data here
don't confuse it with one thing
don't confuse it with table
it looks like table
but I can't call this data table
because when we did table
in that lecture we saw
that we get many features with table
many useful features
I should say this
but with normal data
those features are not available
so I have some data
on this data
can I apply themes directly
let's see
for themes where I have to go
page layout
so I select it
from here
I select it
and then I go to themes option
on themes
if I go to any theme
I can't see
any change
background color of sociology
is yellow
red of science
is red
it means that themes are not applying
exactly
themes are not applying
what is the reason of not applying themes
themes are not working on selection
styles are working on selection
what does it mean
let's see
if I select
from here to mouse
then it is called
selection
if I try to apply theme on this selection
then it won't work
styles can be applied on this
like I go to
home
if I select
then it is
styles can be applied on this
but when I saw theme
then it was not working
now what will theme work on
so before this I want to tell you
one thing we did formatting
what is formatting
formatting is that I have this cell
in this cell if I do any changes
like I change background color
or change text color
or change font
then this whole thing is called
formatting
formatting and theme are two different things
formatting is that
I am doing on a particular cell
if I want to do formatting
in other cell then
I can do two different things
in first cell I changed background color
like in 56
if I want to change background color
then I do this
green
in 53
this blue
but it is not happening
that I am doing things on a particular cell
that I am doing formatting
on whole data
this is happening on whole data
it is not happening
but in themes
whatever things are available on my sheet
like if we convert this in table
then we will see
our theme works on table
so for table
we have to convert this in table
table
when we did lecture
then we saw how to convert in table
so first of all
we convert this in table
so I will select whole
and here in insert
I will get table option
when we click on this option
then it shows me cells
from here to first cell
it will tell me name and last cell
that from here to here
in this range
even if you want to convert everything in table
I said yes
so I did ok
after doing ok
it shows me like this
now theme is applied
because we were trying
we selected some theme
but it was not working on selection
but as soon as we converted in table
then it started working
so for themes we go again to pale layout
go to themes option
if I click here
blue color
if I click here
then color changed
so all these things
can be changed on whole table
so theme applied
is on whole table
even I want to say
that it is on whole sheet
but it does not work on selection
now if I put some
other things on sheet
for example I put some shapes
go to insert
go to insert option
I selected this shape
color of this shape
can be changed
like I made it green
apart from this I selected
another shape
color of this shape
can be changed
I changed color of this shape
now in sheet 1
I have many things
one is rectangular shape
one is circle shape and one is table
so now
if I want to apply theme
then theme will be applied on table
or all these things
one is circle shape
and one is rectangular shape
will be applied on these three things
so theme will be applied on these three things
so I have to go again
to pale layout and
after going to themes option
if I try then you will see
color of these two shapes is also changing
along with table content
if I click here
you can see
font, color,
color of rectangle
color of circle
color of rectangle
color of circle
so it is clear that
theme will be applied on
all these elements
all these things
will be applied on table
shape
but theme will not be applied on selection
selection means
I have written normal data
I have selected that normal data
and after that it will be applied on that
let's do this
it will be more clear
what I do here
2, 4, no
it will take table
we don't want to take table
we take it here
2
and here 4
I write table of 2
table of 2
I have written table of 2
now here
the way color is changing in table
if I apply theme
then it should be changed
but it will not be changed
because it is just selection
like I
select this
and now I am trying to apply theme
so you will see
theme is applied on other things
but theme is not applied on this
color is not changing
why it is not changing?
because it is not working on theme selection
so this thing is clear
ok
apart from this
we can see some options
like colors, fonts, effects
now what is this
if you go to colors
some color sets are given
combinations of colors
I have given name of color set
like I go to this
you will see change
I go to this
in both shapes
and in table
you will see color change
so this is work of color set
apart from this
you can customize colors
we have seen
customization in other things
so you can try this
apart from this font is given
if I want to change font
so to change font
to change font
first I select
I select all
and now I go to font
and now I try to change
so here you can see
change
so
as I change this
so you can see
font is changed
apart from this
I have given effect option
if I go to effect
you can see
in both shapes
you can see
border of both shapes
you can see
movement
you can do this
you can see
change in outline
you can see
change in outline
you can see
change in outline
or you can
browse for themes
you can download
any theme
you can browse
and apply in current worksheet
so we have seen themes
color set
font
to change font
first you have to select
effect
you can apply effect
so this is clear
one thing we should never forget
theme is different
style is different
and formatting is different
Themes work on all the tables and shapes in my worksheet.
I don't need to convert my style into table.
Style works on selection, themes don't work on selection.
And when it comes to formatting, I can change things in
that particular cell.
I can change its background color, text color, etc.
So I think it will be clear to you how themes are applied
in Excel.
So I think that's all for today's video.
I will meet you in the next video.
Till then you keep practicing.