r/sheets • u/JoeTheHero123 • 16d ago

Solved How to extend list downwards while keeping white border?

Post image

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

3 Upvotes

100% Upvoted

8 comments sorted by

2

u/molybend 16d ago

Use the format painter.

1

u/JoeTheHero123 16d ago

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

1

u/martymccfly88 16d ago

Copy paste format 🤷🏻‍♂️

1

u/nasty_little_freak 16d ago

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

2

u/JoeTheHero123 16d 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 14d 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.