• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Combining Data from Multiple Sources > 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 instead of one. To define a workspace, you open the files you want to include and then open the Save Workspace dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint