From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Moving, copying, and grouping sheets

Moving, copying, and grouping sheets

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Moving, copying, and grouping sheets

- In this file called 09 - 03 - RegionalSales, we're looking at the East sheet. Here's the Midwest sheet, South sheet, Pacific sheet. To be in sync with other data that we keep track of we need to move the South sheet and put in in front of the Midwest or phrase another way, we could move the Midwest sheet, put it after South. Moving a sheet simply means dragging the sheet tab and putting it before or after other sheets, leftward or rightward, wherever we want to put it. I'm dragging the South sheet leftward, putting it in front of Midwest and there it is. Very easy to move a sheet. No commands needed. I might want to make a copy of one of those sheets. Maybe what I'd like to do is to create a sheet that has the same layout as all these, but I'm going to create some summary formulas there. How might I create a copy of one of these sheets? Almost the same way. Now, if you didn't know what I'm about to show you, you'd probably and certainly sensibly right click the sheet tab and choose…

Contents