…If you have work sheets within a work book,…that have the exact same layout, there are going…to be times when you want to make a change to all of them at the same time.…In this work book here, called regional data, we've got four…separate sheets, containing data from…different states, the layouts are identical.…Now, what if we want to make a format change?…Rather than doing this four times, we can do it all at once.…The first step is simply to Right-click, on the current sheet.…For example Colorado.…
And choose, the lowest option you see in the list there, Select All Sheets.…We see the word Group at the top of the screen.…We've selected all the sheets.…Now we have also selected by the way, sheet one, two and three.…They're currently empty so, if we make formatting…changes here it's not going to make much difference.…However, we could be making content changes as well.…So, you should think out whether you want to select all…the sheets, but certainly sometimes that's going to make some sense.…So, suppose for example here we want a new row between…
- 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.