From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Moving, copying, and grouping sheets
From the course: Excel 2019 Essential Training
Moving, copying, and grouping sheets
- You can change the order of a sheet, bottom of the sheet we can simply move the sheet left to right. We can also make a copy of a sheet when needed, and at different times we can select multiple sheets and make changes to all of them at the same time. We're in the workbook 09 regional sales at the moment the east sheet is visible. As I click the tab for Midwest, keep an eye on column A and row two. They're the same in all of these. The zoom factors a little different so we might want to make that a bit more consistent, and we might eventually want to change the look of all of them so that the row seven data is bumped down into row eight. So, first of all to move a sheet, maybe we decided that the south sheet belongs to the left of Midwest, we'll simply click and drag the south tab to the left. Maybe we change our minds later, we can drag it the other way or we can drag the Midwest to the left. Now, sometimes we want to make a copy. Maybe eventually what we'd like to have is a…
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.