Good day
I created a spreadsheet with all my columns. When I print the document, all the cells in the table (see picture).
My columns or cells have black borders which I created. The rest I want blank.
How do I do that?
Thank you.
Numbers-OTHER, iOS 7.1.2
Hi jay,
Do you want to hide the blank rows?
That will make the table smaller.
Do you want to delete the blank rows?
That will also make the table smaller.
Do you want to remove the cell borders around the blank cells?
My guess is that they are not cell borders, but gridlines.
Select the table (click on a cell, then click on the 'bullseye').
Format Panel > Table > Gridlines > click on the blue rectangles.
Before:
After:
Regards,
Ian.
Hi jay,
Do you want to hide the blank rows?
That will make the table smaller.
Do you want to delete the blank rows?
That will also make the table smaller.
Do you want to remove the cell borders around the blank cells?
My guess is that they are not cell borders, but gridlines.
Select the table (click on a cell, then click on the 'bullseye').
Format Panel > Table > Gridlines > click on the blue rectangles.
Before:
After:
Regards,
Ian.
Thank you so much. This is exactly what I wanted to do.
Hi jay,
Thanks for gold star and your feedback.
It took me a while to discover that Numbers 3 has both Gridlines (table property) and Cell Borders (cell property).
By default, a new table has gridlines.
BTW, I was wrong about having to select the whole table by the bullseye. Just click anywhere in the table to add/remove gridlines in Format Panel > Table.
I have a table in My Templates (New From Template Chooser) as my default, formatted with cell borders but no gridlines.
Regards,
Ian.
Hide blank rows in Numbers
