…If you're working with a work book like this one,…it's called department data, it's got many different sheets in it,…there certainly are going to be times, when it's handy…to see different portions of different worksheets at the same time.…Now, if you haven't ever used this feature.…And you discover that there is something on the View tab…that seems appropriate, Arrange All is probably the button you're looking for.…Stack your open windows, so you can see all of them at once.…Sounds good.…Let's click it.…And in this Arrange Windows dialog box, you'll see…a box here that says Windows of Active Workbook.…
And that seems to be suggesting that we're…talking about just the current workbook, and it is.…So I click this, and click Okay.…And what happens?…Hardly anything.…The screen blipped a little bit.…What we need to do in these cases, is create a new window.…So let's imagine that we want to see, portions of three different worksheets.…We already have one window, when we always have one window present.…Let's add a new window.…
- 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.