O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Grouping Multiple Data Lists

Grouping Multiple Data Lists

When you work with Excel for a while, you’ll find that you often work with a number of the same workbooks at a time. For instance, Catherine Turner, the owner of The Garden Company, might always pull up a yearly sales summary workbook and the sales figures for product categories offered by The Garden Company. She can open the workbooks together through the Open dialog box, but she can also group the files so that she has the option of opening them all simultaneously.

If you want to open a set of files simultaneously, you can define them as part of a workspace, which uses a single Excel file name to reference several workbooks ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required