Join Dennis Taylor for an in-depth discussion in this video Moving, copying, and grouping sheets, part of Excel Essential Training (Office 365).
- [Narrator] You can move a worksheet left to right just by dragging it or in this workbook 09 Regional Sales I want the South sheet to be to the left of Midwest I'll simply click and drag the South sheet and put it to the left of Midwest. At other times you might want to make a copy of a sheet. I want to take the data in the West sheet make a copy of it, maybe I want to experiment with a variation on these numbers. I've got the Control key held down now I'll drag this right or left, let go of the mouse first and we made a copy of a sheet. You can do that easily. If I were to right click on the West sheet choose Move or Copy, this might take a little longer if I do what I just did here but I might want to create a copy of that sheet and put it in a new workbook.
I choose new workbook, click okay, we have a new workbook I'm not going to go there right now, but that's easily done. There might be other workbooks open too. I could copy it into those as well too. Now I've got four sheets here, East, South, Midwest, West. They've got identical layouts. In other words they're headings are in row two, and column A are all the same. I might want to make a change to all of them. I might want to change the zoom factor on all of them too. Whenever you want to make changes to multiple sheets you can group them. Now if they're consecutive as they are here, we can click on the East or West sheet, it makes no difference.
In other words the one at either end, I just click the East sheet. Now I've got the Shift key held down, and I'll click on that West sheet tab. Those sheets are grouped. It certainly has a different appearance and at the top of your screen following the file name you see the word Group. When these are grouped a change we make here even though we're only viewing one of the sheets is going to be happening on all four of these sheets. I want a new row between row six and seven. I right click row seven and insert. We've got a new row. And if I look at the Midwest sheet, West sheet, South sheet, that's happened on all of them.
I'm going to click on cell A1, that's happening on all of them. In the lower right hand corner, there's that zoom slider bar, I'm going to slide that back and forth a little bit I'm changing the zoom factor on all of these sheets at the same time. And it's up to you to remember that they are grouped. Not that long ago I remember changing a cell in a situation like this and I realized only later that I'd made that change on multiple sheets because they were still grouped. So you learn to keep an eye on the word Group up in the title bar, and of course the display does look different. So on these different sheets here, notice how that sometimes we still want to do scrolling and I did click on that cell and it happened on all of them, nothing truly wrong with that.
At some point we want to ungroup, so if I right click, Ungroup, that's certainly one way, or I could have Grouped on one of the sheets that's not part of the group, for example, sheet two, Ungroup. It's unlikely that in this particular layout of worksheets that I would want to make a change to two sheets that are not adjacent but if I wanted to make a change to the Midwest sheet and the East sheet but not the other two, Midwest is selected, I'll hold down the Control key and click East. Once again, the word Group appears in the title bar at the top. If I make a change now and I'll just do a simple one here.
I'll click here and make this Italic, that happened on the East sheet. It happened on the Midwest sheet, and as I click South they will Ungroup. It didn't happen on the South sheet. It didn't happen on the West sheet. So we've seen the technique for grouping sheets. Usually it's consecutive. Click, Shift, Click at either end of a list of sheets. We saw earlier how to move a sheet and copy a sheet. Different techniques that you'll use as you work with multi sheet workbooks.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.