Split Microsoft Excel spreadsheet
It
can be difficult working with long Microsoft Excel spreadsheet documents and
knowing what row or
column you're working in when scrolled past
the top row or far left column. To keep a row or column locked in place split
the spreadsheet by moving the mouse cursor over the icon above the right
scrollbar or to the right of the bottom
scrollbar. Once positioned correctly your mouse cursor will turn into a
double-arrowed cursor as shown in the picture to the right. Hold down your mouse
and drag down or to the right until the document is split where needed.
How do I unsplit?
If you wish to remove this click-and-drag the split line back up to the top or far right of the spreadsheet until it vanishes and let go of the mouse button.
Computer tips home - Excel tips