Recently for reasons I don’t know Excel started an annoying habit.
I want to look at two windows, showing different parts of the same sheet. I arrange the windows horizontally. Let’s say I want the top window to show rows 1-20, and the bottom to show rows 50-70. Before this was no problem. But now, when I try to do this, Excel forces me to view exactly the same rows in each window. On the title bar of the windows it states the file name, the window number, and “[Vsync]”. It behaves somewhat as though I’ve hit the “View windows side by side” option, even though I haven’t. I can’t seem to turn this Vsync option off, or even find any mention of it under Help. Any ideas? I’d be grateful for any help.
(By the way, I know that if I only want to see two non-contiguous parts of the same sheet I can simply use 1 window, splitting the screen. I actually want to see three parts of the same sheet, using two windows, one of them split.)
