Remove border line of a few cells

R

Raymond

how do I remove the border around a cell? I did it by right-click the cell,
then click Format Cells.

click the Border tab and I remove the borders by clicking on them. or to
remove all of them, click the preset None. However after i got back to the
spreadsheet, the border line still there. I also choosing Tools>Options,
and on the View tab, remove the check
mark from Gridlines. But this option remove all the gridlines not of a few
cells line which is what I want. any help?

thank you.
 
B

Bob Phillips

You cannot remove gridlines from individual cells.

What you could do to fake it is to select the cells, and then set the
background colour to white. Oddly (IMO), this seems to overlap the
gridlines.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top