this post was submitted on 03 Oct 2023
47 points (91.2% liked)
Asklemmy
43328 readers
1455 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.
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.
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.