Locked lesson.
About this lesson
In this lesson, you'll learn how to duplicate worksheets.
Exercise files
Download this lesson’s related exercise files.
27 - Duplicating Worksheets.docx60.4 KB 27 - Duplicating Worksheets SOLUTION.docx
56 KB
Quick reference
Duplicating Worksheets
In this lesson, you'll learn how to duplicate worksheets.
When to use
Use this technique whenever you have a current worksheet that you'l like to duplicate to make additional changes on (without destroying the look and feel of the original worksheet).
Instructions
Hover your mouse over the worksheet tab that you'd like to duplicate. Right Click your mouse and choose "Duplicate".
Rename the newly duplicated worksheet something more appropriate than the default.
Hints & tips
- Hover over the Worksheet tab you'd like to duplicate
- Right Click
- Choose "Duplicate"
- 00:02 Okay, in this video, I want to talk about duplicating worksheets.
- 00:07 Now we've already talked about creating additional worksheets, we've already
- 00:12 created one way back in a previous video, in fact, it's empty it looks like.
- 00:16 But to do that we just came over here to this little icon down here.
- 00:21 If we hover over there, it says new worksheet.
- 00:23 That's how we create a new worksheet, right?
- 00:26 But let me just delete that one.
- 00:28 What if we want to duplicate a current worksheet?
- 00:32 Now why would we want to do that?
- 00:33 Well, let's say for instance, this one from the last video,
- 00:36 we've got this visualization set up, got the animations, we like this a lot.
- 00:40 But we want to add something to it, but we're not sure.
- 00:43 Or we want to keep this for later, but
- 00:45 we also want a different visualization that does this and a little bit more.
- 00:50 Well, we could just create a new one like this, come over here,
- 00:53 click this tab, create a new one, and then drag this stuff,
- 00:56 the same stuff over into the new one.
- 00:58 But that's sort of a hassle, and you run the risk of maybe forgetting to
- 01:02 drag something in the exact same way that you dragged and dropped everything for
- 01:06 this visualization.
- 01:07 So what you can do is just come down here and right-click and click Duplicate.
- 01:12 And when you do, you can see it says Dog Breeds (2).
- 01:17 So this is the exact same visualization as this one,
- 01:20 it's just a different visualization.
- 01:23 So we can right-click on here and change this.
- 01:25 So let's rename, instead of Dog Breeds (2),
- 01:30 let's say Dog Breeds with license type, right?
- 01:35 So we don't just want the Dog Breed, we want to break it down to whether they're
- 01:39 spayed or neutered, male or female.
- 01:41 So, in this second one, this duplicated one,
- 01:44 we can then grab our license type, bring it up here.
- 01:48 And let's come up here and click All, so we get all the data.
- 01:52 Now let's create a filter in here, and
- 01:55 let's say we want dog individual spayed female, and
- 02:00 dog individual neutered male, we just want those two things.
- 02:05 So let's click Apply, okay?
- 02:08 This will work, we can still sort of cycle through here.
- 02:11 But what I really want to do is break this down by color.
- 02:15 So I'm going to grab this and drag it down into color.
- 02:19 And then, we don't really need that there, and there we go.
- 02:21 So now it's broken down into color and we could filter this,
- 02:26 again, we have to refilter it because we moved it, so let's get none.
- 02:31 And let's just we want dog individual neutered male and
- 02:34 dog individual spayed female, we just want those two, we can apply.
- 02:39 Now just those two are listed, you can see down here at the bottom,
- 02:43 there's our little legend.
- 02:44 So this orangish peach color is neutered males, the green is spayed females.
- 02:52 And now as we cycle through here, we can get a breakdown.
- 02:57 That's very cool.
- 02:57 So we may not want this information also,
- 03:00 so now we can just toggle back to the old one.
- 03:04 And it doesn't have that information on there, so very cool and very easy.
- 03:08 If we do, then in the future, hey, what was the spayed neutered stuff?
- 03:11 We just click on this one that we made, and there it is.
- 03:15 So that's why you might want to duplicate your worksheets and
- 03:18 that's how you do it very easy and a great level of control, just by right-clicking,
- 03:22 clicking Duplicate.
- 03:24 And then just doing whatever you want in the duplicated worksheet.
- 03:27 So that's all for this video, in the next video, we're going to look at saving and
- 03:30 publishing our worksheets.
Lesson notes are only available for subscribers.