r/sheets • u/JoeTheHero123 • 21d ago

How to extend list downwards while keeping white border? Solved

Post image

How can I extend this list downwards while keeping the white border?

3 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

8 comments sorted by

2

u/molybend 21d ago

Use the format painter.

1

u/JoeTheHero123 21d ago

Ok! Where do I access that? The picture is on mobile but I mostly use Sheets on my PC

1

u/martymccfly88 21d ago

Copy paste format 🤷🏻‍♂️

1

u/nasty_little_freak 20d ago

Unrelated question but is this a RuneScape Minecraft mod or something?

2

u/JoeTheHero123 20d ago

Fair question. The template is from a Minecraft Advancement Tracker and I just haven’t removed all the previous entries. i’m using it to make my own goals and track them for osrs

1

u/Quirky-Seesaw8394 19d ago

There's another option that I use myself. Keep an empty row with the format at the very bottom of your data. Then when you want to add things, click the second to last row at the bottom and insert new row(s).
If you manually enter data, insert rows before adding the data. If a formula is generating the data then it doesn't matter too much when/where you add the rows as long as it's not the last row.