Easy way to work with multiple workbooks simultaneously

image_pdf

Excel has an amazing feature of viewing multiple workbooks and saving it as workspace.

You can save current layout of all open and arranged workbooks in workspace file (.xlsw). When you open workspace file again excel opens all workbooks and display in the layout you saved.

To do this, execute following steps.

1. First, open two or more workbooks.

2. On the View tab, click Arrange All.

3. Select the desired arrange setting. For example, click Vertical

4. Click OK.

5. On the View tab, click Save Workspace

6. Save the workspace file (.xlw) to a location on your computer.

7. Close Excel.

8. Open the workspace file.

Result: When you open a workspace file, Excel opens all workbooks and displays them in the layout that you saved.

Explore More, It's Amazing…

Compare different parts of excel worksheet using Split

If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.

1,119 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>