Window Menu

These commands help you manage your spreadsheet windows.

Minimize Window, Zoom Window, Bring All to Front

These commands behave exactly the same way as they do in Entourage (see Out of Office).

New Window

Opens a new window on the same file that’s currently open—a duplicate view of the same spreadsheet. This arrangement lets you view two (or more) places in the same file at the same time, scrolled to different spots and zoomed independently.

Arrange

Arranges all open windows so that at least a portion of each is visible—which makes switching or dragging data between open files much easier. An Arrange Windows dialog box opens, where you can set how those windows are arranged (Tiled, Horizontal, Vertical, or Cascade).

Hide

Hides the frontmost workbook window without closing it.

Unhide

Displays a list of windows that have been hidden with the Hide command, which you can then Unhide.

Split

Splits the active window horizontally and vertically into four, independently scrolling panes. If the currently active window has been split, this menu command changes to Remove Split.

Freeze Panes

If your sheet has been split into two or four panes, this command freezes the top pane, the left pane, or both. That way, those panes stay in place while you scroll the lower right panes—it keeps column and row titles visible while you scroll through your worksheet. (None of this affects how the sheet prints.) This command changes to Unfreeze Panes if you have already frozen the panes on the sheet.