in Google sheets every project is
different that means you may want to
modify certain things including the size
and layout of your cells to better fit
the data you're working with for example
this column has already been resized but
not quite enough a couple of the
addresses are still getting cut off I'm
going to increase the width a little bit
more by positioning my mouse over the
line in the column heading then clicking
and dragging it to the right another
option is to auto size the column this
will automatically adjust the width so
it fits the contents of the cells
exactly just double click the line
instead of dragging it now the column is
perfectly sized to the text rows work
very much the same way they start out
auto size to fit your text but you can
easily adjust their height by clicking
and dragging the lines sometimes it's
useful to be able to resize all of your
cells at once for example in this
spreadsheet I'd like to make all of my
rows the exact same height to do this
click the Select All button
just below the formula bar then resize a
row it doesn't matter which one and the
change will be applied to the entire
spreadsheet next I need to add another
row to this list I'd like to put it in
between row 6 and row 7 to add a new row
all you have to do is right-click then
choose from the menu the process is
similar for adding a new column again
just right-click then make your
selection
deleting columns and rows is easy first
select the column or row you want to
delete then right-click and choose
delete column from the menu if you need
to move a column or row start by
selecting it then drag and drop it into
place
let's fast forward to the finished
spreadsheet next I'd like to take a look
at wrapping text which is one of the
ways 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 we can do this by using the
wrap text button on the toolbar now the
text is on multiple lines another useful
feature for spreadsheets with lots of
data is the ability to freeze certain
rows or columns it works just like it
sounds the cells become frozen or fixed
in place allowing you to scroll through
your spreadsheet and still see important
information like your header row to get
started open the View menu select freeze
then choose the option you want in this
example I want to freeze the first two
rows the title and the header so I'm
going to choose two rows now the top two
rows will stay in place when I scroll
through the rest of my spreadsheet a
thin gray line indicates where the cells
are frozen now for the finishing touch
combining the cells in the top row so
the title of my spreadsheet can be
centered in single large cell to do this
select the cells you want to merge then
click merge cells on the toolbar there
that's perfect the best way to learn
about modifying cells freezing rows and
columns and wrapping text is to practice
so the next time you're working on
something look for ways that you can use
these techniques to improve the look of
your spreadsheet
GCF global creating opportunities for a
better life