How can I fixate the view for the top-x rows? (like Excel - Freeze panes)
I have a file with headers, with 200+ rows of date under that.
How can I fixate the view, so row 1-10 are always visible, even if I scroll down to rownumber 200+?
(Like you can do with Freeze panes in Microsoft Excel)
I have a work-around:
- Clone the view
- Right-click the separator and click rotate right
- Move the separator up (or down) until the upper view only shows the headers
- You can scroll in the lower view, still seeing the header in de top view
Disadvantage: A big gray separator between the header and the data.
Scott Sumner last edited by
That workaround is so nice I wouldn’t call it a workaround, I’d say: “that’s how you do it”!
A small disadvantage is, that it doesn’t work as simple as for example Microsoft Excel. In Excel it’s one step: Select the row, or cell, and activate Frees Panes. The work-around involves 5 steps, I didn’t mention the synchronize horizontal scrolling.
I would like to select a row, right-click and freeze above, or freeze under. (or insert a small narrow separator)
The big disadvantage is that big gray separator. It’s not nice, and it’s sometimes hard to see where a header is pointing to.
(See example: https://postimg.org/image/4wypfpqz5/)