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.

Reply