Split a Worksheet Into Multiple Panes
You can split a worksheet area into vertical and/or horizontal panes so that you can click inside any one pane and scroll to locate information in that pane while the other panes remain in place.
Drag a split box (the small box at the top of the vertical scroll bar, or at the right end of the horizontal scroll bar) in the direction you want the split to appear. To remove the split, move the pointer over the split until the pointer changes to a double-headed arrow, then double-click the split.
quiero dividir la pantalla del monitor con dos hojas de excel diferentes. para pasar datos de una a la otra y tenerlos siempre a la vista.