#HOW DO YOU FREEZE FRAME IN EXCEL WINDOWS#
Once you have more than one copy of your worksheet window open, you can select different worksheets to view from each worksheet window, and then arrange the windows to best suit your needs. You can arrange worksheets on your screen so that you can view them simultaneously. Often, it is useful to view more than one worksheet at a time. Viewing and Arranging Multiple Worksheet Windows From the Window menu, choose Unfreeze Panes.Press Right Arrow until you can see the Dec-95 column.From the Window menu, choose Freeze Panes.Note: When you freeze panes, the Freeze Panes option changes to Unfreeze Panes so that you can unlock frozen rows or columns.Įxercise In the following exercise, you will freeze and unfreeze worksheet panes.Note: If the cell you select is in column A or in row 1, choosing Freeze Panes will result in two panes instead of four.Select the cell below and to the right of the location for the frozen panes.Freezing panes is useful when you are working with large tables because you can hold horizontal and vertical labels stationary while you move through the data.
Drag the vertical split bar to the left edge of the worksheet window.Īnother way to divide your worksheet into panes is by freezing sections of the worksheet.Drag the vertical adjustment to the right of column B.Position the mouse pointer over the vertical split box.Double-click any part of the split bar that divides the panes.From the Windows group on the View tab, choose Split.Select the Enrollment by Seminar worksheet.Double-click any part of the split bar that divides the panes.įigure 1-4: The Split Boxes Exercise In the following exercise, you will apply split bars.When the mouse pointer changes to a split pointer, drag the split box down or left to the desired location.Position the mouse pointer over the horizontal or vertical split box.To apply a horizontal or vertical split bar: Click the cell to the right of the location for a vertical split and below the location for a horizontal split.Because each pane is a view of the same worksheet, a change in one pane means a change to the worksheet.įigure 1-3: Worsheet Split Bars Method To apply horizontal and vertical split bars: You can move between the different panes by simply clicking the pane in which you want to work. For example, if you horizontally scroll in the upper right pane, you simultaneously scroll through the lower right pane while the two left panes remain stationary.Īlthough the Split command can be accessed from the Windows group on the View tab, you can also manipulate split bars with the mouse using the split boxes shown in Figure 1-4. If you apply both horizontal and vertical split bars, in which four panes are created, only two panes remain stationary when you scroll within one pane. If you apply either a horizontal or vertical split bar, you can scroll within one pane while the other pane remains stationary. Split bars are illustrated in Figure 1-3. When you apply split bars to a worksheet, Excel creates identical copies of the worksheet side by side. You do this by applying either split bars or freezing panes.įor live face-to-face Excel training in Los Angeles call us on 888.815.0604. You might, for example, want to keep the labels in row 4 visible while you scroll down to look at information located in row 35. In many cases, you might find it helpful to work with different sections of your worksheet at the same time.
0 kommentar(er)
