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).
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.
It's not iOS but this is how they've done it on OSX: Under the "Table" tab, uncheck "Grid Lines"
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.
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.
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:
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.
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.
By far the best answer was posted by Stephan Côte back on Dec 22, 2015. Like Stephan it took me a while using trial and error method as the meaning of the term "Set Default Border" was not intuitively obvious.
Just be aware that this is how to remove a border of a specific cell or a range of cells. If you want to remove all of the outlines in a table then you should use some of the options using the table option. If this is the case try using the methods outlined in some of the other posts.
Here's Spephan's post repeated below. Remember though, you must select the particular cell or range of cells that you want to remove the "border" from before proceeding.
"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."
Tap on the table, tap paint brush, tap Table, tap Table Options, Grid Options, switch off 'Horizontal Lines and Vertical Lines'
Right click the cell and click on Reapply Table Style.
