Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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

5 Answers 5

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
1  
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

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

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

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

Your Answer

 
discard

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.