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.

    • vortexal@sopuli.xyzOP
      link
      fedilink
      arrow-up
      2
      ·
      1 year 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
        link
        fedilink
        arrow-up
        2
        ·
        1 year 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.

        • vortexal@sopuli.xyzOP
          link
          fedilink
          arrow-up
          2
          ·
          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
          link
          fedilink
          arrow-up
          2
          ·
          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
    link
    fedilink
    arrow-up
    3
    ·
    1 year ago

    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.xyzOP
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

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