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.
-
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/)
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login