How To Group Multiple Sets Of Data In Microsoft Excel 2007

[soleimanian 0]

How to Group Multiple Sets of Data in Microsoft Excel 2007

 

Sometimes you may open several workbooks and work with a number of the same workbooks at a time. You can open this group of files with Microsoft Excel 2007 simultaneously. But you have to define them as part of a workspace, and save them in a single Excel 2007 file.

 

To do this, follow below steps:

1- Click On the View tab and then in the Window group click Save Workspace. The Save Workspace dialog box appears.

2- In the File name field, type your work name and then Click Save.

3- At the top-left of window, Click the Microsoft Office logo and then click Close to close workbooks.

4- Click the Microsoft Office logo and then click Open. The Open dialog box appears.

5- Open saved Workspace. Microsoft Excel 2007 opens all workbooks simultaneously.