When you are working in a very large Excel worksheet, sometimes you may want to view different areas of the worksheet at same time. If the worksheet is very large, it is not possible to view different areas of the worksheet at same time by zooming out the worksheet. There is a feature in Excel, which allows you to split the active worksheet into Split Panes horizontally or vertically. Each Split Pane has separate scrollbar, so that you can scroll them separately. Once the active worksheet is split into different panes, you can compare different areas of worksheet by scrolling horizontally or vertically.
To split an Excel worksheet vertically at a Column, follow below steps.
Step 1 - Select the Column (or top-most Cell of the Column) where you want to split the worksheet by clicking on its Column letter. In this example, I had selected Column F, as shown in below image.
Step 2 - Click "Split" button from Excel Ribbon > "View" Tab > "Window" Group to split Excel worksheet vertically, as shown in below image.
Step 3 - Excel splits its worksheet window vertically at the left-side of selected Column and displays a Split Pane bar at the left-side of selected Column vertically. After splitting the worksheet window vertically into two different Panes, each pane has its own horizontal scroll bar as shown in below image. Both Split Panes spans the entire worksheet so that you can scroll, view and compare different areas of the Excel worksheet at the same time.
If you keep the mouse pointer over the Split Pane bar, the pointer changes to a double headed arrow, as shown in below image. You can change the size of a pane by clicking, dragging and releasing the mouse pointer on Split Pane bar, after its shape changed into double headed arrow.
To remove the Split Panes, simply click the "Split" button again or double click on the Split Pane bar.
An animation about how to split panes vertically of an Excel worksheet at a Column is copied below.