Goodwill Community Foundation creating
opportunities for a better life the look
and feel of your workbook has a lot to
do with the formatting choices you make
for example let's add some formatting to
this fitness chart that'll make it
easier to read and more visually
appealing
we'll start by selecting the cell that
contains Fitness progress chart and
making the text bigger in the font group
on the Home tab locate the font size box
you can either type in the exact font
size you want or click the drop down
arrow to select a size and you'll see a
preview of the results as you go down
the list
I think 24 looks good maybe we could go
a little bigger though increase and
decrease our two other options for
quickly changing the size of your text
all you have to do is click the command
and there we go to change the actual
font click the drop down arrow here then
make your way down the list you'll get
that live preview again
I think I'll go with this one it's
different but it's still very easy to
read which makes it a good choice for a
title so how about some color to view
your options click the arrow next to the
font color command you can choose one of
the theme colors here or if you don't
see anything you like go ahead and
select more colors this bright pink
should look pretty good with the color
scheme I have in mind another way to
make your text stand out is to use bold
italic and underline bold should be a
good choice in this example now the text
really stands out and it's much easier
to read I think I'm ready to add some
formatting to the rest of the worksheet
at a glance it's kind of hard to tell
the header row from the rest of the
chart because it just isn't very
distinct we can easily fix that by
giving the cells a unique fill color all
you have to do is open the menu next the
fill color command and make your choice
dark grey should be a nice contrast to
the think we already used now we just
need to change the color of this text to
something lighter you can also use cell
styles to quickly apply different
formatting in your workbook let's give
it a try on the rest of our data here
when you're ready click the cell Styles
command then mouse there were the styles
for preview and click the one you want
at this point you probably notice that
adding a fill color to a cell range
causes the line in between the cells to
disappear I'd like to change that by
adding in some cell borders click the
drop down arrow next to the border
commands and you'll find a lot of
different options for example you can
add a top and bottom border a thick
outside border and even different line
colors and styles for a border that goes
all the way outside and in between the
cells
choose all borders ok one last thing I'd
like to show you is how to change the
placement or alignment of your text
using the options in the alignment group
in addition to left center and right
text can also be aligned to the bottom
middle or top of the cell aligning the
text the middle Center should make this
data really nice and easy to read there
we go see what a big difference
formatting can make not only does my
spreadsheet look better than it did
before it's also easier to review the
data