From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Moving, copying, and grouping sheets
From the course: Excel Essential Training (Microsoft 365)
Moving, copying, and grouping sheets
- [Instructor] The order of the worksheets that we see at the bottom of the screen here is something you have complete control over. I'm rethinking this, and I think South should be to the left of Midwest. We can move a worksheet simply by clicking and dragging as I'm doing here, moving that sheet leftward or rightward as needed. And there could be times too when we want to make a copy of a sheet. What I'd like to be able to do, and notice is I click on the East sheet, the South sheet, the Midwest and the West. They all have the exact same layout. I'd like to set up a Summary sheet here. We won't really set up those formulas in this movie, but I do want to demonstrate the idea that rather than retyping and putting in headings on a new sheet, I'm simply going to copy this sheet. Now instead of a simple drag left or right, hold down the Control key. You see that tiny little plus inside the sheet tab. I'm dragging this to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.