…If a workbook has multiple sheets, it's not uncommon to want…to move a sheet around or possibly make a copy of it.…And we can do this by a way of commands or simple dragging techniques.…In this workbook here, called sample, notice in…the lower left hand corner, if we happen to…right click, near the arrows, we do see…there are quite a few sheets in this workbook.…If we'd like to see more at the bottom of the…screen, a quick reminder, you can put the mouse pointer on…the three vertical arrows and move that to the right, shrinking…the scroll bar, but thereby seeing a lot more sheet names.…
So, for whatever reason, maybe just a question…of how we have our data lined up here,…it's going to be more efficient if we…move this city's sales worksheet off to the right.…Put it behind AutoSum.…So, it's just a simple, you now, click the Worksheet then click and drag.…Drag it to the right or drag it to the left, as needed here.…So, we're going to put it after Profits and in front of AutoSum.…There it is right there.…So, it could hardly be easier.…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.