If you prefer not to clutter your screen with additional windows, Excel provides another option for viewing multiple parts of the same worksheet. Choosing View?Window?Split splits the active worksheet into two or four separate panes. The split occurs at the location of the cell pointer. If the cell pointer is in row 1 or column A, this command results in a two-pane split. Otherwise, it gives you four panes. You can use the mouse to drag the individual panes to resize them.

Figure 14-7 shows a worksheet split into two panes. Notice that row numbers aren’t continuous. In other words, splitting panes enables you to display in a single window widely separated areas of a worksheet. To remove the split panes, choose View?Window?Split again or just double-click on the split bar you want removed.

FIGURE 14-7
You can split the worksheet window into two or four panes to view different areas of the worksheet at the same time.

• Baby Development Stages in Week 3 Fertilization occurs at what is perceived as the third week of pregnancy, and this is when the baby development stages...
• Human Integrity Choice is both very simple (perhaps one of the most simple things in life), and honestly also one of the...
• Florida Gators Flag Are you looking for a way to show your Florida Gators pride, and a little bit of team spirit? Whether...
• How to Convert a Dynamic Disk to Basic Disk in Windows 7 Firstly, Do Not Dance with the Devil! I made the mistake (again!) of trying dynamic disks with my new Windows...