How to Split the Excel 2013 Worksheet into Windows For Dummies

You can compare data from two separate sections of an Excel 2013 worksheet on your screen. Just split the worksheet into panes, it's so much easier than scrolling through a bit worksheet!

---

Closed Caption:

although zooming in and out on the
worksheet can help you get your bearings
it can't bring together two separate
sections so that you can compare their
data on the screen to manage this split
the worksheet area into separate pains
and then scroll the worksheet in each
pain so that they display the parts you
want to compare splitting the window is
easy to split a worksheet into pains you
simply position the cell pointer at the
place in the worksheet where you want to
split the worksheet and then click the
split button on the ribbons View tab the
key to creating the pain you want with
the split button is positioning the
pointer in the correct cell before you
click this command button to split the
window into horizontal pains position
the cell pointer in column a of the row
where you want to split the worksheet
to split the window into two vertical
pains position the cell pointer in Row
one of the column where you want to
split the worksheet to split the window
into four panes to horizontal and two
vertical position the cell . or
somewhere in the center of the worksheet
excel split the page along the top and
left edge of the cell after you split
the worksheet window Excel displays a
thin light gray bar along the row or
column where the windows split occurs if
you position the mouse or touch . or
anywhere on the split bar the pointer
changes from a white cross to a split
pointer shape you can increase or
decrease the size of the current window
panes by dragging the split bar up or
down or left or right with a split
pointer you can make the pains and a
workbook window disappear by double
clicking anywhere on the split bar you
can do the same thing by selecting view
and split again