Home

Can you save a workspace on the newer Excel Programs?

%3CLINGO-SUB%20id%3D%22lingo-sub-517357%22%20slang%3D%22en-US%22%3ECan%20you%20save%20a%20workspace%20on%20the%20newer%20Excel%20Programs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-517357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20upgraded%20recently%20and%20am%20having%20a%20hard%20time%20setting%20up%20a%20workspace%20and%20saving%20it%20as%20I%20had%20done%20in%20the%20past%20on%20Excel%202007.%26nbsp%3B%20A%20workspace%20enabled%20me%20to%20have%20two%20Excel%20files%20running%20at%20the%20same%20time%2C%20split%20on%20the%20screen%2C%20and%20able%20to%20be%20saved%20to%20a%20shortcut.%20I%20was%20able%20to%20launch%20the%20whole%20thing%20with%20two%20clicks.%20Is%20there%20a%20way%20to%20still%20accomplish%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-517357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-519896%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20save%20a%20workspace%20on%20the%20newer%20Excel%20Programs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-519896%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332261%22%20target%3D%22_blank%22%3E%40BrandonZ517%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20the%20concept%20of%20workspaces%20exists%20in%20recent%20versions%20of%20Excel.%20Each%20workbook%20now%20runs%20in%20its%20own%20window%20and%20you%20can%20arrange%20windows%20on%20the%20screen.%26nbsp%3B%20You%20can%20open%20the%20two%20files%2C%20then%20select%20one%2C%20hold%20down%20the%20Windows%20key%20on%20the%20keyboard%20and%20press%20the%20Left%20Arrow.%20This%20will%20size%20the%20workbook%20to%20take%20up%20half%20of%20the%20sceen%2C%20aligned%20to%20the%20left.%20You%20can%20then%20select%20which%20window%20should%20take%20up%20the%20right%20half%20of%20the%20screen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524905%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20save%20a%20workspace%20on%20the%20newer%20Excel%20Programs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332261%22%20target%3D%22_blank%22%3E%40BrandonZ517%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20add%20your%20vote%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F17742496-bring-back-save-workspace%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F17742496-bring-back-save-workspace%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
BrandonZ517
Occasional Visitor

I upgraded recently and am having a hard time setting up a workspace and saving it as I had done in the past on Excel 2007.  A workspace enabled me to have two Excel files running at the same time, split on the screen, and able to be saved to a shortcut. I was able to launch the whole thing with two clicks. Is there a way to still accomplish this? 

2 Replies

Hello @BrandonZ517 ,

 

I don't think the concept of workspaces exists in recent versions of Excel. Each workbook now runs in its own window and you can arrange windows on the screen.  You can open the two files, then select one, hold down the Windows key on the keyboard and press the Left Arrow. This will size the workbook to take up half of the sceen, aligned to the left. You can then select which window should take up the right half of the screen.

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies