now that our table is formatted let's
take a look at some of our text
alignment options before we do that
let's turn off filtering and Excel every
column in the table has filtering
enabled in the header row so that you
can filter or sort your table data
without having to go through a lot of
extra steps to do this we can just go
back to the Home tab and click the sort
and filter command and select filter
from the list now over in the alignment
group we have some alignment commands
that we can use to format our text so
our table really looks professional I
think I want to insert another row with
the title of our table and a one we'll
call this
scoops shop inventory you know that's
the name of my ice cream shop
I want this title to appear centered
over my entire table so I'll just select
a1 through g1 and then in the alignment
group I'll select the merge & Center
command now my title appears centered
across the table as you can see the
column markers don't appear anymore in
Row 1 which indicates those cells have
been merged into one if you change your
minds you can always click the drop down
arrow next to the command and choose
unmerge cells now that our title is
centered I'd like to Center my column
headings first I just need to select
those cells and then click the center
alignments command if I wanted to I
could align the text to the left or
align it to the right but I think it
looks best centered now I do think the
package size would look best right
aligned
so I'll just left-click the column
heading to select column E and then
click the align text right command
another set of alignment commands in the
group are the top align middle align and
bottom align commands to see how these
work let's increase the heights of row 1
and I'll just go ahead and make our
title bigger and bold it now if I click
the top align command the title will
align to the top of the cell the bottom
align command moves the text to the
bottom of the cell and the middle align
command centers it in the middle a
really useful alignment command is the
wrap text command to show you how this
works
let me start a new column in h1 as I
move down to the next cell Excel
realizes that I am adding to the table
and automatically formats it for me now
in h2 I want to type a reminder to
myself this is a bestseller order and
more as you can see the text is
overflowing to the next cell if I want
to format this so I can view all the
text I can select the cell and click the
wrap text command all the text is
wrapped and appears in the cell if you
don't want to format each cell
individually you can select multiple
cells and then click the wrap text
command now when I enter text into the
cell it will automatically wrap so that
it all appears you can still adjust the
column width and the text will wrap to
fit the new column size the final
command I want to show you is the
orientation command this one allows you
to format text in a variety of ways such
as clockwise vertical and rotate
it I think I'll insert another column
and add more information here along the
left after inserting the column I need
to type in the information then select a
couple of cells here on the side and
click merge and center now if I click
the orientation command and click rotate
text up the text will be formatted here
on the side I need to increase my text
size so it will line up at the top of my
spreadsheet there that looks pretty good
whether we are moving rotating or
wrapping text Excel 2007 makes aligning
text easy