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. Hold down your mouse and drag down or to the right until the document is split where needed.
How do I unsplit?
If you want 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.
No comments:
Post a Comment