In any workbook you need to have the sense that you're completely in control…over the sheet layout in a workbook.…You want to be able to move one or more sheets around at will and easily copy…sheets whenever you need to copy worksheets.…One at a time or multiple sheets.…Let's talk about a number of different ways to get to these issues quickly and easily.…I'm looking at the budget sheet, Budget2011, in this workbook called Sample.…I like the way it looks, but I want an alternate version of it and there are…number of different techniques for doing this.…
One approach is and a common one is simply to make a copy of the worksheet.…Now, I never am going to say that right-clicking is not a good idea.…I use it all the time and it certainly would be a good idea here if you want to…move, in this case copy, a sheet.…It's certainly not the fastest way, but it does have an advantage in that you…can control where you want this to go based on the name of a sheet.…Of course, if it were a copy and click Create a copy here. But I do want to show…
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 and moving sheets within a workbook