From the course: Excel 2013 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Moving, copying, and grouping sheets - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Moving, copying, and grouping sheets
You can easily move a worksheet to a different location within the same workbook or you can copy of a worksheet within the same workbook. And at times you might even want to change multiple sheets of the same workbook at the same time. In this workbook 09-03-RegionalSales we want to move the Midwest sheet to the right of South, we simply Click that Tab and drag it rightward. Sometimes we want to make a copy, maybe this data here is questionable, we might want to work with this separately, if we want to copy a worksheet, there are two ways to do this, we can Right-Click the sheet tab and choose Move or Copy and then create a copy and then Click OK. We also can position it while we are doing this if we wish before a certain sheet, the example here if I do nothing special, it will put this before the East sheet, copy of Midwest. A much, much faster way is that if I want a copy of Midwest, I will start to drag it and hold down the Ctrl key, as I do, there is a plus that appears within…
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.