Cell borders in Numbers

Question

Cell borders in Numbers

I inherited a Numbers spreadsheet with borders that I need to maintain. Adding a row copies some formatting that I don't want (two rows together should have top and bottom borders, not borders on each row). How do I fix this? I spent years using Excel; no flamewars please, but it is easy to do what I want in Excel. Looking for help has not been useful; Google searches turn up answers for 15 year old versions of Numbers, but not for the current (13) version.

Tell me there's an easy way to do this.

MacBook Air 13″, macOS 14.2

Posted on Feb 8, 2024 4:23 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,532 points

Feb 9, 2024 8:36 AM in response to excel_is_easier

I think I see what you mean.

Start with this:

And if you add two rows you get this:

One way to remove the "extra" border is to select the cells in the two new rows and do this:

Copy-pasting the original two rows onto the new rows also works.

SG

Reply

Answer 2

6x6

Level 6

19,257 points

Feb 8, 2024 4:39 PM in response to excel_is_easier

In Numbers, select the cells, display the Format tool (in the toolbar, to the right), click the "Cell" tab and you'll see the same border arrangement functionality as in Excel.

Reply

Answer 3

Feb 9, 2024 2:49 PM in response to excel_is_easier

See if this works for you...

Jerry

Reply

Answer 4

Feb 10, 2024 6:50 AM in response to SGIII

Yes!!! Thank you so much!

Reply

Answer 5

Feb 10, 2024 6:51 AM in response to Jerrold Green1

I will give it a try! Thank you so much for responding!

Reply

Cell borders in Numbers

Similar questions