formatting cells is all about changing
the look and feel of your spreadsheet
even a few adjustments can make it
easier to read and more visually
appealing in this video we'll go over
the most common options at the top of
the screen you will find all of your
formatting commands on the toolbar the
commands on the Left allow you to format
numbers insert dollar signs for currency
percentage signs and many other options
like date and time to the right you'll
see all of your options for changing
text let's start with adjusting the font
start by selecting the text then click
the drop down menu to view the options I
like the way this one looks
I want the title of this chart to be
very easy to read so let's change the
size of the text by clicking the font
size command I can select one I think
will be big enough another way to make
text stand out is to make it bold which
I can do by selecting the cells I want
to change and clicking the command here
there's also the italic command and
strikethrough which will make text
appear crossed out I'm going to stick
with bold for this black and white is a
little boring and I also want to draw
attention to different parts of this
chart so let's add some colors to change
the background or fill color I'll select
the cells and then click the fill color
command this will show you all of your
color options just to select the one you
like this dark color makes the black
text a little hard to read so I'm going
to change the color of the text this
works the same way is fill color just
click the text color command and make a
selection
I think I'll add some color to these
rows also to break up the different
sections
there's an even wider variety of color
options you can view by clicking custom
this blue will look nice
when it comes to formatting consider the
purpose of your spreadsheet and your
audience for example if you are creating
something for work a hot pink fill color
may be too informal
similarly putting white text on top of a
yellow cell will make it hard to read
you may have noticed that when you added
color the lines between the cells became
a little bit harder to see we can fix
that by adding borders select the area
you want to apply borders to and click
the borders command if you'd like you
can change the color of your borders
here you'll also see several options for
border lines try a few and see which one
looks best for your spreadsheet
changing the text alignment allows you
to adjust the position of text within
the cell horizontal alignment allows you
to move text to the left center or right
of the cell while vertical alignment
moves text to the top middle or bottom
of the cell let's give this chart a
really clean organized look by using
both commands to Center the text in each
cell there just a few changes have made
a big difference
next time you're creating a spreadsheet
get creative and experiment with
different colors and fonts to find a
look that works for your project
GCF global creating opportunities for a
better life