Is at hand a path to split columns surrounded by Excel so that you can scroll them independently of respectively other? I want to be capable of compare notes contained by two columns at equal time but my columns are long so I hold to keep hold of scrolling up and down to compare them.
Answers: Do this from the Menu at the top of the eyeshade:
Window >> New Window
Window >> Arrange
You could "freeze" one of them so it stays fixed..
I give attention to you click the square at the top of the column, goto Window, afterwards Freeze (and Unfreeze will be within matching place after you do this)
Try that
I don't know a opening of splitting columns so you can scroll them individually, but how do you stingy compare? It is possible to use a formula to compare to sets of notes and this can accentuate cell if to be precise of any use consent to me know.
Good luck
"L" is right in the order of New Window and Arrange.
The other means of access to do it is next to Window - Split
- this will allow you to look at rows 10-30, for example, in the top pane, and 100-120 in the bottom pane.
If you stipulation more info, make the addition of more details or e-mail.
Cheers.
.