Always open the same workbooks to do a task in Excel? Consider creating a Workspace

by on
in Excel Training,Office Technology

If you always open the same workbooks to do a task in Excel, consider creating a Workspace. First, save each open file. Then, with all workbooks open and arranged how you want them (tiled, horizontal/vertical windows, arranged in various window sizes), click the Save Workspace button in the Windows group of the view tab. Save the Workspace with a name you’ll associate with the task. A Workspace icon has a slightly different appearance than an Excel workbook. Keep in mind when you’re creating your Workspace that if you move the files, the Workspace won’t work correctly.

Leave a Comment