47
submitted 2 years ago by vortexal@sopuli.xyz to c/asklemmy@lemmy.ml

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.

you are viewing a single comment's thread
view the rest of the comments
[-] sergiu@lemmy.one 4 points 2 years ago

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

[-] vortexal@sopuli.xyz 2 points 2 years ago

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 2 years ago

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.

[-] rbn@feddit.ch 2 points 2 years 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.

load more comments (1 replies)
load more comments (1 replies)
load more comments (1 replies)
this post was submitted on 03 Oct 2023
47 points (91.2% liked)

Asklemmy

47155 readers
922 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!

  1. Open-ended question
  2. 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.
  3. Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
  4. Not ad nauseam inducing: please make sure it is a question that would be new to most members
  5. An actual topic of discussion

Looking for support?

Looking for a community?

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

founded 6 years ago
MODERATORS