so far I'm only using one worksheet in
my workbook my inventory is only for one
month and only appears on one sheet but
let's take a look at how you can use the
other sheets to accomplish your goals in
Excel by default three sheets appear
when you create a new workbook if you
want to change this default setting you
can do that in your Excel options I'm
going to leave the default settings set
to 3 for right now I can add new sheets
as I meet them I would like to name this
first sheet January to do this just
right click the sheet tab and from the
menu that appears choose rename
now the worksheets appears highlighted
and you can begin typing the new name if
I want to rename the next sheet I just
select it and do the same thing or if
you prefer to use the ribbon you can
click the format commands in the cells
group on the Home tab and then select
rename sheet the word sheets appears
highlighted and you can begin typing the
new name you can use whichever method
you prefer personally I use the first
way I showed you I think it's a bit
faster for me but you'll learn what
works for you since my default sheet
setting is 3 I need to add more sheets
so that I can list my inventory each
month to add a new sheet left click the
insert worksheet icon and a new sheet
will appear I'll do this several more
times so now we'll have enough sheets if
you'd prefer to use the keyboard
shortcut just press the shift
eeee and the function 11 or f11 key at
the top of your keyboard if you do
decide you want to delete a sheet just
right-click the sheet and select delete
or if you like using the ribbon commands
just select the sheets you want to
remove and click the drop down arrow
next to delete in the cells group on the
Home tab from the menu that appears
select delete sheet ok now you know how
to rename add and delete sheets let's
actually go ahead and rename these two
sheets we can add the rest of the months
later on my January sheets I have all my
inventory information for that month but
all my other sheets are blank I want to
copy all this information to my February
sheets I can do that by selecting it all
selecting the copy command and then left
clicking the February sheet to select it
now I can click the paste command and
select paste from the list and all the
info appears on the sheet this is a lot
easier to do than typing this
information into the sheets but copying
and pasting into multiple sheets can be
time-consuming also this is where
grouping comes in
before I group my sheets I need to copy
the information I want to paste I
actually just want to paste my heading
in categories to the remaining months so
I need to select this information and
click the copy command now we're ready
to group 2 group contiguous sheets or
sheets are all in a row click the first
sheet once a group then press and hold
the shift key on your keyboard now click
the last sheet you want to group you see
how March April and May all change color
and now the sheet tabs are white well
these sheets are now grouped together
select the cell where you want the
information to start now click the paste
command and the information appears but
instead of pasting it to just one sheet
it appears on all three sheets we can
also make formatting changes when sheets
are grouped for example I want to add
2008 to the beginning of my title if we
do it once the change will appear on all
three sheets that are grouped it looks
like I need to change the width of my
columns as well
that looks a lot neater as you can see
the tabs are still white which indicates
they are all grouped to ungroup sheets
just right-click one of the sheets and
select ungroup' from the list before we
finish talking about grouping let me
show you one other way to group what if
I want to make a change only to two or
three sheets and they aren't
side-by-side you can do this using the
control key select the first sheet you
want to group then press and hold the
control key on your keyboard now select
any of the other sheets you want to
group and release the control key you
can see that the sheets you selects it
now appear in white and are grouped
together if I make a change now to one
it will appear in all the grouped sheets
but not the ones that were not grouped
so whatever I changed will only appear
in March and May there is one more thing
about working with worksheets that I
want to show you because I find it
helpful this is the ability to freeze or
lock specific rows or columns in your
spreadsheet Excel causes freezing panes
when you freeze panes you select rows or
columns that will remain visible all the
time even as you are scrolling you see
right now when I scroll down my
spreadsheet I can't see the column
headings that let me know what type of
information each column contains if I
scroll to the right I can't see the
column that tells me what item all this
inventory information refers to to
freeze a row select the row below the
one that you want to freeze since I want
to row one and two to appear at the top
even as I scroll I'll select Row three
now click the View tab in the window
group
click the freeze pain command to view
the list and then choose freeze pain
everything above this line is frozen in
place when I scroll in the worksheet the
first two rows stay pins at the top so I
can always see the column headings to
unfreeze the pain just select the freeze
pain command and select the unfreeze
command now you can do the same thing
with columns let's say we want the first
two columns to always appear on the left
just select the column to the right of
the columns you want frozen and then
click freeze pain and freeze pain again
now as we scroll to the right those
columns stay rates in place freezing
rows and columns can be especially
helpful when dealing with large
spreadsheets so this is a good thing to
know how to do it doesn't change how the
spreadsheet looks printed but it does
make working with it electronically a
lot easier we've gone over a lot but it
really is important to know how to work
with worksheets so that you can easily
navigate your workbook and use it most
efficiently take some time to explore
worksheets on your own