Leading the way in Microsoft Office Development

Using Multiple Windows

It is possible to display two different parts of the same worksheet at the same time.

This can be done by opening a new window on the same workbook.

This can be very useful if you are copying or moving data around on a worksheet or between worksheets in the same workbook.

This is useful if you want to show two different worksheets from the same workbook at the same time.

(Alt + Tab) - (Ctrl + Tab) ??

When your open presentations are in one taskbar window you can switch between them by pressing (Ctrl + F6 + F6)

You can normally only see one presentation at a time if they are maximised - although you can use (Alt + Tab) to switch between them.

(Tools > Options)(View tab, "Windows in taskbar")

You can also use (Alt + Tab) to switch between the open presentations.

Creating New Windows

Select (Window > New Window)

You can arrange multiple worksheet windows in the same way you can arrange multiple workbooks.

Creates an additional window for the active presentation to allow you to view different parts of the same worksheet simultaneously.

This is useful if you want to compare two worksheets in the same workbook.

If you need to work with more than one workbook at a time then use the Arrange dialog box (>>) to display your workbooks with the same size on your screen.

This makes transferring data between workbooks really easy

It is possible to open multiple view of the same workbook.

It is possible to have open multiple windows of the same worksheet. This will allow you to view two different worksheets within the same workbook at the same time.

This can be useful if you want to copy information from one part of a workbook to another part, especially if they are on different worksheets.

To create another window of the same workbook select (Window > New Window).

Moving between multiple windows

Moving between multiple windows is identical to moving between two different workbooks. You use the (Window) drop- down menu.

(Tools > Options)(View tab)(Windows in Taskbar)

Things to Remember

You can’t drag-and-drop across a split screen.

You can easily move a worksheet to another workbook by dragging the tab to the other workbooks window. You must have your workbooks arranged in separate windows. To copy a worksheet, hold down Ctrl while dragging.