How to freeze multiple panes in excel 365
The Arrange Windows dialog box provides options to let you set up your data on the screen. It takes one click to activate a window and another click to select anything in that window. Once you have arranged the worksheet windows, you can move between different windows simply by clicking the window in which you want to work. For example, Figure 1-5 displays four worksheets from the same workbook at once. 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
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.