If you need to work with several workbooks at once, you can take advantage of Excel's workspace feature. A workspace is a way of saving the layout of open workbooks so you can open them the same way next time.
To save a workspace, follow these steps:
Save Layoutto display the Save: Microsoft Excel dialog box.
To use a workspace you've saved, open it as you would any other file: