Briefly, how to split a spreadsheet view vertically, where the left side stays put and the right side scrolls?
I finally decided on a sheet and data layout that views acceptably, but I want the ability to scroll the entire window height on the right side, about 50 rows on-screen. What I settled with is a graph on the left and 500 rows of inverted graph data series to the right; the data row count will increase as new data is inserted at the top-most row.
The best I’ve come up with is freezing at the graph bottom with about ten rows to scroll below the freeze, but it’s like a gun slit. I created names to jump to, about every 50 rows, but I’d prefer the entire window height at a glance, for context. Efforts to manipulate the view with freeze, split, or graph anchor, have proven fruitless. I feel that manually tiling windows isn’t very integrated with the file.