- [Instructor] I'm looking at all the tabs or sheets
in my workbook and I can see that they're out of order.
Here's 2018 and it definitely should be to the left of 2019.
All I have to do is click and hold and drag it
and it's going to rearrange that tab.
In fact, I can do that with any tab.
I can slide them around
and rearrange them to my heart's content.
What I could also do is duplicate a sheet.
Let's say we want a copy of 2021.
I can right-click and choose Move or Copy.
Now, we know how to move it.
It's easier just to drag it around, so let's copy it.
It's important to note that I could even copy this
to a completely new workbook.
It doesn't have to be this one,
but it defaults to keeping it in the same workbook.
It assumes that you want to copy, that is duplicate this tab,
to the same workbook.
And here it is asking me where I want to put it.
I can put it before a certain sheet
or move it to the end if I wanted to.
I'll place a check mark next to Create a copy and click OK.
And here is my identical copy of that tab.
I can give it a new name by double clicking on it.
Now that I have my new tab,
I can erase these values and put my new ones in.
Let's say you want to make a change to every sheet at once.
Why would you want to do that?
Well, the most common use is to make a formatting change.
I can group these sheets.
To do that, click the first sheet, hold down the shift key,
and select the very last sheet that you want to group.
I can now see that they're all the same color.
It looks like they're all selected,
and if I go to the very top of the screen,
I can see that Group is in brackets next to the title.
That's a good visual cue for me
that these sheets are grouped.
Now any change that I make is going to affect every sheet.
I can change anything. I can even change the data.
For example, in this data type,
I might want to add some decimal places.
I'll select the data, add my decimal places,
and if I do that and navigate
through the rest of my balance sheet,
you'll notice that these balances are changing
because I'm moving through different years,
but the formatting is the same.
That change has taken into effect for everything.
Something else that I might want to do
is change the way text looks.
I can click and drag through these columns.
Maybe I want to change the color or italicize them.
Again, every single tab has that formatting.
I can insert rows, I can delete rows.
Whatever I do, it's going to do to all of them.
When I'm all done, the easiest way to ungroup
is to right-click on any tab and choose Ungroup Sheets.
Now I can go back to working with them
on an individual basis.