There have been multiple accounts created with the sole purpose of posting advertisement posts or replies containing unsolicited advertising.

Accounts which solely post advertisements, or persistently post them may be terminated.

kambusha ,

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 OP ,
@vortexal@sopuli.xyz avatar

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

sergiu ,

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

vortexal OP ,
@vortexal@sopuli.xyz avatar

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 ,

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 ,

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.

vortexal OP ,
@vortexal@sopuli.xyz avatar

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.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • [email protected]
  • random
  • lifeLocal
  • goranko
  • All magazines
    •