Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)?

I have tried copying and pasting, the Format > Cells > Border Style, and deleting the contents, but the black border always remains (and actually spreads if I copy and paste the contents elsewhere).

share|improve this question
up vote 1 down vote accepted

The only thing you can do is to copy a cell without borders over the one that has. If you type the info in first at least you don't have to remember it.

share|improve this answer
You may have to copy the cells around your cell depending on which one is registerd as having the border – Mark Sep 4 '12 at 0:11
Thanks guys! The border was set to the bottom in Excel so I only tried copying over the cell above the border. When I copied over the cells above and below, it cleared the line. – dlanod Sep 4 '12 at 0:59

Make a copy of the Excel sheet so you can start over if needed. In the menu bar, View > Show Format Bar (it may already be shown). Highlight the cells in question. Look for these popdowns:

enter image description here

Make sure the border box is set to "none". If this doesn't work, let us know if you are getting warnings when opening the file in Numbers.

share|improve this answer
Ifound that I also had to play with the color setting - next to "none". So my new scientific answer is to muck around with these three controls. Remember to keep making sure that the cells are highlighted before changing, and you have to click outside of the table to see if the changes were effected. – David DelMonte Sep 2 '12 at 13:54
I don't appear to have those controls - are they from the Mac version? As mentioned above, I am using the iOS version. – dlanod Sep 2 '12 at 20:55

It's not iOS but this is how they've done it on OSX: Under the "Table" tab, uncheck "Grid Lines"

Screenshot removing gridlines from numbers

You might also set "Table Outline" to "None" and play with the 3 buttons to the right to add/remove grid lines from the headers.

share|improve this answer
saved my day! Thanks – hashbrown Oct 25 '14 at 17:33

Tap on the cell or table who's border you are aiming to remove. With the cell selected, tap on the paintbrush icon on the toolbar. Select the table menu and then table options at the bottom of the table window. Slide the Table Border on/off button to off. Viola! You've done it.

share|improve this answer

I know this is an old thread but just had this problem and was looking everywhere for an answer including here and ended up figuring it out on my own.

If you tap the paint brush then cell and border style the last one at the bottom says set default border when you hit that it removes the borders that are in place.

This threw me for a long time because of the wording I thought it was to set the selected cell as the default not to revert to default as in no border

Hope this helps someone else.

share|improve this answer

Right click the cell and click on Reapply Table Style.

share|improve this answer
It's not possible to right click in iOS so I suspect you're talking about an incorrect version. – dlanod Nov 6 '13 at 6:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.