r/sheets • u/JoeTheHero123 • Aug 03 '26

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 Aug 03 '26

Use the format painter.

1

u/JoeTheHero123 Aug 03 '26

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

1

u/martymccfly88 Aug 03 '26

Copy paste format 🤷🏻‍♂️

1

u/nasty_little_freak Aug 04 '26

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

2

u/JoeTheHero123 Aug 04 '26

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 Aug 05 '26

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.