every Excel workbook contains one or
more worksheets kind of like a book
contains many sheets of paper new
workbooks contain three sheets by
default sheet 1 sheet 2 and sheet 3
but imagine what it would look like if
you were working with an even larger
amount of data creating and customizing
a range of worksheets could really help
you stay organized and get the most out
of Excel I've already made some progress
color coding and renaming most of my
worksheets but where did they all come
from there are two ways to add
worksheets to your workbook either by
copying or inserting a new one I do need
to add one final sheet for the month of
December so this is a good place for us
to start to quickly insert a new sheet
just click the insert worksheet icon
always found at the end of your list of
tabs a new blank worksheet will appear
ready for your content to copy one of
your existing worksheets right-click the
tab and select move or copy from the
menu this will create a new worksheet
and duplicate the contents perfect for
tracking my budget from month to month
using the same table just check the box
next to create a copy and identify where
you want the worksheet to go I want mine
to go to the end of the list click OK
and your copy appears 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 go ahead and rename it by
right-clicking the tab and then choosing
rename now type the name click anywhere
outside the tab or press ENTER on your
keyboard and you're all set
as you can see the table from the
November worksheet has been copied over
so I'm just going to change this to
December to match now we can take a look
at this extra blank worksheet that I no
longer need to delete a worksheet all
you have to do is right-click the tab
and choose delete finally I'd like to
show you how to color code and move
worksheet tabs
by going all the way back to my original
sheet sheet one first I'm going to
rename it then give it its own unique
color like I've done for the rest by
right-clicking and going to tab color
the tab still appears white because the
worksheet is selected select any other
tab and you'll see the color change now
I'd like to move this first worksheet
being that it's for the previous year to
the very end of the list to do this just
click and drag the tab where you want it
to go there now everything is in order
using worksheets and taking the time to
customize them is a great way to
organize your data and make it easier to
navigate like what you just saw radix
add a comment subscribe to our Channel
the freedom to learn
what you want when you want absolutely
free GCF learn free.org