REMOVE ALL THE BORDERS AROUND A CELL

[Raymond]

how do I remove the border around a cell?

thank you.

 

[Stefano]

right-click the cell, then click Format Cells.

click the Border tab and you can remove the borders by clicking on them. or to remove all of them, click the preset None.

 

[Raymond]

Thank you stefno. You are pointing me to the right place and direction.
However, I could not remove the border after selected the preset none. I
chose the none for the light too from the list of lines on the right but
after clicked ok and got back to the spreadsheet, the cell border still
there. I wonder what is going on?

Thank You

right-click the cell, then click Format Cells.

click the Border tab and you can remove the borders by clicking on them.

or to remove all of them, click the preset None.

 

[Debra Dalgleish]

A worksheet also has gridlines, that outline the cells. You can hide
these by choosing Tools>Options, and on the View tab, remove the check
mark from Gridlines.

 

[Raymond]

Thank you Debra. However, I only want to make a couple of gridlines of
only several cells disappear, not the entire spreadsheet which was what you
was pointing me to. Thank you for any more help.

 

[Tushar Mehta]

The solution to hiding gridlines for some cells is to simulate the
effect but not actually removing the gridlines.

*Create* a border for those cells. Use a border color that is the same
as the cells background (default is white).


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Or fill the cell with white, and the gridlines get painted over.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______