when you open a new blank workbook cells
are set to a default size however as
seen here you may want to go beyond the
default size depending on the type of
spreadsheet you're working on this
column has been resized for example but
not quite enough a couple addresses are
still getting cut off I'm just going to
increase the column width a little by
positioning my mouse over the line in
the column heading then clicking and
dragging it to the right you can get
even more precise results with the
format command choose column width to
change the column to a specific
measurement the width is measured in
pixels
another option is to autofit the column
which will automatically adjust the
column so it fits the contents of the
cells exactly just go to format autofit
column width now the column is perfectly
sized to the text rows work the same way
you can click and drag the line to
adjust the height manually or use the
format command to auto fit or specify
the height now I need to add another
name to this contact list I'd like to
put it in between rows 3 & 4 to insert a
new row all you have to do is select the
row below where you want the new one to
appear now click the insert command your
row appears along with the insert
options button which lets you choose the
formatting for your new cells I'm going
to keep the default which is the same
formatting as the row above the process
is similar for inserting a new column
just select the column to the right of
where you want the new one to go click
the insert command and the new column
will appear to the left always make sure
you select the entire row or column by
clicking the heading when you're getting
ready to insert a new one otherwise
you'll only insert a cell this is also a
good rule to remember for deleting
columns and rows you'll want to make
your entire selection then click the
delete command
now let's take a look at wrapping text
which is one way of addressing cells
that contain more text than they can
actually display for example I'd like to
resize my column of addresses to about
half its current size but still be able
to see the contents the wrap text
command can help by displaying the text
on multiple lines just click and the
text and the rows adjust automatically
now for the finishing touch
combining the cells in the top row of my
spreadsheet so the title can be centered
in a single large cell to do this select
the cells you want to merge together
then click the merge & Center command
there that's perfect to access more
merge options open the drop down menu
here you can merge your cells across
creating merged rows instead of a single
large cell if you have multiple cells
selected you can also merge without
centering or split your cells up again
the best way to learn about merging
cells wrapping text and inserting and
deleting columns and rows is to practice
so give it a try with your own Excel
spreadsheet and have fun like what you
just saw rate it add a comment subscribe
to our Channel
the freedom to learn
what you want when you want absolutely
free GCF learn free.org