Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove border line of a few cells
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 ToolsOptions, 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. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove border line of a few cells
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) "Raymond" wrote in message ... 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 ToolsOptions, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove border lines around cells; I want to clean up the | New Users to Excel | |||
how do I remove line breaks from several cells? | Excel Discussion (Misc queries) | |||
How can I change the width of the single border line for cells? | Excel Discussion (Misc queries) | |||
remove flashing border after copying cells, how? | Excel Discussion (Misc queries) | |||
10 000 Line, every 2 Lines need a border and a open line inbet. e. | Excel Discussion (Misc queries) |