Goodwill Community Foundation creating
opportunities for a better life
by default when you create a new
workbook in Excel it contains one
worksheet called sheet one sometimes
that's all you need but if you want you
can create additional worksheets and
even customize them so you can store
large amounts of data all in the same
workbook as you can see I've already
made some progress creating worksheets
for each month in the year
I still need one final sheet for the
month of December to quickly insert a
new sheet just click the new sheet
button always found to the far right of
your tabs alternatively you can copy one
of your existing worksheets this will
create a new worksheet and duplicate the
contents perfect for keeping track of my
budget using the same table each month
all you have to do is right-click the
worksheet you want then choose move or
copy from the menu next check the box
that says create a copy and identify
where you want the worksheet to go I
want mine to go to the very end of the
list click OK and a copy will appear
with the same name as the original plus
a version number remember this is the
worksheet I needed for the month of
December so I'm going to rename it by
right-clicking the tab then choosing
rename when you're done click anywhere
outside the tab to deselect it or press
ENTER on your keyboard I'm also going to
update the worksheet itself next I'd
like to review the rest of my worksheets
and make sure everything is in order it
looks like some of them need to be moved
to do this just drag and drop the
worksheet tabs into place you can even
color
your worksheets to make them easier to
reference just right-click the tab then
go to tab color the color is less
noticeable when the worksheet is
selected if you select another worksheet
you'll see the color the way it was
intended finally if you have a worksheet
you don't need anymore
you can easily remove it from your
workbook all you have to do is
right-click the tab then choose delete
now it looks like we're all set when you
have multiple worksheets you can work
with each one individually or you can
edit several at the same time this can
be useful if you're working with lots of
data that's closely related let's take a
look for example I'm planning to move in
the month of September my rent is going
to go up and I'm canceling my gym
membership too that means I need to
update not only this worksheet but also
the sheets for the rest of the year we
can edit them all at once just by
grouping them start by selecting the
first sheet you want a group then press
and hold ctrl on your keyboard while you
select the rest release the ctrl key and
you'll be able to navigate and make
changes to the data changes that will
apply to all the worksheets in the group
for example if I change the rent to
seven seventy five in one worksheet the
rest of the group gets updated to the
same rule applies if I clear the row
that contains my gym membership to
ungroup just right-click one of the
worksheets then click ungroup sheets
alternatively you can click any
worksheet outside the group just be
careful not to do that by accident
worksheets are a great option for
storing lots of data in the same
workbook and with the ability to group
them you can easily add or edit data
anytime whether you have hundreds of
worksheets or just a few