Here is "Our Take" on the situation described by user Oday-Dolphin.
This request reveals a fundamental limitation of traditional spreadsheet architecture, and our opinion is clear: users should not have to fight the tool to keep their data in sight. What Oday-Dolphin describes, wanting to view a lower portion of one column while working higher in a different column, is not a niche need. It is a daily friction point for anyone managing reference lists, lookup tables, or cross-referenced data. The fact that Excel's "Split" function locks the panes to scroll vertically together is a design choice that assumes your data lives in a single, linear flow. That assumption is outdated.
Think about what this means in practice. You have a product list in rows 200-250, and you are entering data in row 15. Every time you need to check a product code, you scroll down, memorize it, scroll back up, and type. Repeat that fifty times a day, and you have lost not just time but cognitive flow. The user's suggestion of a "static peek" window is a workaround born of frustration, but it points to a deeper truth: the spreadsheet itself should be smarter. It should understand that you need two views of the same data, not two copies of it. A modern tool should let you pin a floating reference pane that follows your cursor or sits in a corner, updating independently as you move through the sheet.
This is where AI-native thinking changes the equation. Instead of asking the user to invent a workaround, the tool should offer a simple command: "Watch this range." Then it creates a live, scrollable thumbnail that stays on screen while you work elsewhere. It is not a "revolutionary" feature; it is a practical one. It respects the way people actually use spreadsheets, jumping between contexts, not linear rows. We believe the future of data work is not about making the grid bigger or the formulas faster. It is about removing the cognitive overhead of keeping your place. A floating reference pane is a small feature with a large impact on productivity.
For Oday-Dolphin, and for anyone who has felt that familiar drag of scrolling up and down a thousand times, the solution should not be a third-party hack or a complex macro. It should be a native capability. The message to spreadsheet developers is straightforward: stop treating the worksheet as a single, locked view. Give users the ability to see two parts of their data at once, independently, without breaking their workflow. That is not a luxury. It is a baseline expectation for a tool that claims to empower productivity.