Create a Workspace in Excel

You may find yourself needing to compare two worksheets in the same workbook simultaneously or needing to work on two worksheets at the same time. With Excel, you can view multiple worksheets in your workbook in the same window by using the New Window and Arrange All commands on the View Ribbon. This is referred to as Creating a Workspace. You will first need to open a second window and then position the worksheets in the desired arrangement (tiled, horizontal, vertical or cascade). Once you have attained the desired window arrangement, you can save your workspace or window arrangement for the next time you open the workbook.

To Create a Workspace

1. Open the workbook file(s) you for which you want to create a workspace.
2. Click the View Tab on the Ribbon.
3. Click the New Window button on the Window group to add a second window.
4. Click the Arrange All button on the Window group.
5. Click the check box next to Windows of Active Workbook.
6. Click the radio button next to the window arrangement you want.
7. Click the desired worksheet tabs in each window.

To Save a Workspace

1. Click the View Tab on the Ribbon.
2. Click the Save Workspace button on the Window group.
3. Navigate to the folder where you want to save your workspace.
4. Type the name for your workspace in the File name text box.
5. Click the Save button.

Similar Posts:

• Sorting the Contents of a Folder in Leopard
• Editing an Excel 2007 Template
• Color Code Finder Items
• Password Protect a Document in Word
• Create a New Template in Excel 2007
• Using Multiple Outlook Windows
• Viewing Documents Side by Side in Word 2007

Tagged as: Excel Tips, Microsoft Office Tips