Asklemmy @lemmy.ml vortexal @sopuli.xyz 9 mo. ago

In Libreoffice Calc, is it possible to dynamically freeze multiple rows?

For example, if I wanted to always see rows 5, 10 and 15, as far as I can tell, I would have to freeze every row from 1 to 15. But is it possible to only freeze the specified rows so that if I scrolled down, the first four rows could be 5, 10, 15 and 20.

7 comments

My guess is you can't, but you could freeze rows 1-15 and the hide 1-4 etc
- I know about hiding and un-hiding but the problem is that, if I needed to edit them, I would then have to un-hide them, edit them, and then re-hide them.
  
  Why not just arrange rows 5, 10 & 15 to be rows 1, 2 & 3 and freeze the top three rows? If needed, move then back to 5, 10 & 15 after you're done or leave them.
Can you group instead of freeze? Group 1-4, group 6-9 etc. That way, you only see the 3 rows but can always expand to see the others.
- I could but someone else reminded me of a better solution, which was to just move the rows to another sheet.

You've viewed 7 comments.