Asklemmy

43810 readers

1229 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

Open-ended question
Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
!lemmy411@lemmy.ca: a community for finding communities

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago

MODERATORS

In Libreoffice Calc, is it possible to dynamically freeze multiple rows? (sopuli.xyz)

submitted 1 year ago by vortexal@sopuli.xyz to c/asklemmy@lemmy.ml

7 comments fedilink hide all child comments

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.

top 7 comments

sorted by: hot top controversial new old

[–] sergiu@lemmy.one 4 points 1 year ago (1 children)

My guess is you can't, but you could freeze rows 1-15 and the hide 1-4 etc

[–] vortexal@sopuli.xyz 2 points 1 year ago (1 children)

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.

[–] Concave1142@lemmy.world 2 points 1 year ago (2 children)

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.

[–] vortexal@sopuli.xyz 2 points 1 year ago

I thought about that as well but I found a better solution, which is to just move the rows to a different sheet. I don't need the rows to be on the main sheet, I just need them to be visually next to each other without breaking the structure of the spreadsheet, which moving them to a second sheet would do.

[–] rbn@feddit.ch 2 points 1 year ago

You could also just duplicate the lines. Have the maintainable content in lines 1-3 and add additional lines in lines 5, 10 and 15 which refer to the others via formula (or vice versa If you prefer to edit 5/10/15). To avoid that you change the wrong lines by mistake, you can protect the cells with sheet protection.

[–] kambusha@feddit.ch 3 points 1 year ago (1 children)

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.

[–] vortexal@sopuli.xyz 1 points 1 year ago

I could but someone else reminded me of a better solution, which was to just move the rows to another sheet.