Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.
up vote 0 down vote favorite

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

3 Answers

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
up vote 0 down vote

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
up vote 0 down vote

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

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.