Join Dennis Taylor for an in-depth discussion in this video Copying, moving, and inserting data on different sheets, part of Excel 2010: Managing Multiple Worksheets and Workbooks.
Copying and moving data from one sheet to another within the same workbook…is often necessary.…You can do this by using standard copy/paste techniques such as right-click or…Ctrl+C, Ctrl+V combination or simply by dragging data across worksheets display.…I think it does make sense to see the sending and receiving areas whenever you…need to copy or move data from one work sheet to another.…There's certainly nothing wrong with this idea of copying by copy-paste.…In other words I might want to copy this information here to a different…worksheet, say Sheet1, and certainly could copy.…
Jump over to Sheet1, right-click and paste, and do it that way. For sure is makes sense.…But I think it's better to actually see both sending and receiving areas here.…I am going to press Ctrl+Z to undo that action.…Go back to the West sheet.…And as a reminder if we would like to see multiple windows here of the same workbook, …we will choose New Window to add one new window.…Then Arrange All. Make sure you check the box for Windows of active workbook. Click OK.…
Released
1/7/2011- Navigating across worksheets and workbooks
- Displaying multiple worksheets or workbooks simultaneously
- Inserting, deleting, moving, and copying sheets
- Changing sheet names and tab colors
- Showing and hiding worksheets
- Creating linkage formulas among workbooks
- Locating and managing links
Share this video
Embed this video
Video: Copying, moving, and inserting data on different sheets