Excel what is the option called WorkSpace

Asked By qadeer23 150 points N/A Posted on - 11/04/2013

Excel what is the option called WorkSpace

I have Excel 2007, what's the option in the View Tab > Save Workspace

Can i have why we need it and how to use it

• Status: Open
• Question Views: 878
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Aron Hank 0 points N/A #162246

Excel what is the option called WorkSpace

WorkSpace is a great tool provided by Excel to help working at multiple worksheets at a time. You can open all the worksheets and adjust the window size of each worksheet on your screen. Then save as a workspace(*.xlw). Now, whenever you will open this file, all the worksheets will open at once, in the same manner you had saved. Workspace only provides a screenshots of your worksheets. Therefore, in case you have to backup your data, you need to save the worksheets individually and not the workspace file. You need to exit your workspace by clicking on "close all" in File menu.

About Aron Hank

Questions
0

Answers
100

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 11/04/2013
• Question Category: MS Excel