Join Dennis Taylor for an in-depth discussion in this video Copying, moving, and inserting data on different sheets, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Narrator] In this workbook called Four State Sales,…there are four sheet tabs, one for each of this four states,…same layout that's not exactly a prerequisite…for what we might want to do.…Imagine a scenario where we might want to consider…copying this information on to a summary type sheet.…So clicking on sheet one,…I'll simply double click that and change it to summary.…If we wanted to copy data,…let's say, from the Colorado sheet to summary…it's fairly easy to.…For example, highlight some data,…press control-C or right click and copy.…
Go over to the summary sheet,…right click somewhere, paste that way or press control-V.…That's certainly one of a number of different techniques…and not that bad, but I want to undo this…and open the door to the idea that sometimes…copying and pasting might be easier when we can see…both the sending and receiving areas at the same time.…And we might be doing this ultimately…with many sheets not just two sheets.…So how do we get to multiple sheets of the same workbook?…View tab, with add a new window…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with different worksheets together
- Copying and moving worksheets within a workbook
- Linking formulas across multiple workbooks
- Changing tab colors and renaming sheets
- Copying, moving, and inserting data on different sheets
- Working with multiple workbooks
- Navigating workbooks
- Getting data from other sheets with 3D formulas