Working with 3D Ranges

A 3D range is a range selected on multiple worksheets. This is a powerful concept because it means that you can select a range on two or more sheets and then enter data, apply formatting, or give a command, and the operation will affect all the ranges at once.

To create a 3D range, you first need to group the worksheets you want to work with. To select multiple sheets, use any of the following techniques: