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.
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.
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.
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.
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.
I doubt it.
I don’t know exactly why you want that, but it seems like it should be solvable in other ways.
Let’s say you have some definitions in rows 1-15 and a table of data from 16-onwards where you’d like to see row 5,10&15 while you scroll down. In that case I’d move the definitions to a separate sheet. In the data sheet I’d use rows 1-3 to refer to the fields in rows 5,10&15 in the definition sheet and freeze (or use a table) after row 3.
If it needs to be even more dynamic than that example, say you want to change exactly what lines are visible on the fly, I’d put everything in a table or filter and add a column labeled “visible” and use that to filter the visible rows by Yes/No or whatever type of selection choice you put there. I use this approach a lot to convert data and calculations spanning several rows into one line csv exports. F.i. having a row called “export filter” I can easily filter to the lines that I need to export.
I’m not gonna lie, I mostly just use Calc as a dynamic text editor, so I have no idea what a lot of that means but I think I’m just going to move some of the rows to a separate sheet. I think this would be the best solution because it would do something similar to what it want, it just for some reason didn’t cross my mind until I read your comment.
