From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,300 courses taught by industry experts.
Moving, copying, and grouping sheets - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Moving, copying, and grouping sheets
- [Instructor] Sometimes you want to change the location of a sheet. For example, on the screen we're seeing the East, Midwest, South and West sheets at the bottom of the screen. I might want to move that South sheet just between East and Midwest or move them in any order that I want. And we do this not by long commands or going through a menu system, it's just click and drag. So I'll point to the South sheet, hold down the left mouse button and drag it leftward. And of course I just as easily could have dragged it to the right. Sometimes you want to make a copy of a sheet. I'm thinking of setting up a summary sheet that's going to tabulate data from all four of these regional sheets. So I'll click West and this time I'll hold down the control key and drag that sheet rightward and that tiny little icon you can probably barely see. It has a tiny plus in it. Holding down control, dragging a sheet tab to the right. I let go of the mouse first and I've made a copy of West. So we've got…
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.
