Jump to content
xisto Community
Sign in to follow this  

How To Group Multiple Sets Of Data In Microsoft Excel 2007

Recommended Posts

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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.