Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,272
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove border lines around cells; I want to clean up the marils New Users to Excel 1 February 9th 10 09:18 PM
how do I remove line breaks from several cells? JR Excel Discussion (Misc queries) 3 May 15th 09 03:20 AM
How can I change the width of the single border line for cells? Tracy Excel Discussion (Misc queries) 2 October 29th 06 04:36 PM
remove flashing border after copying cells, how? cjpuckett Excel Discussion (Misc queries) 3 April 23rd 06 04:43 AM
10 000 Line, every 2 Lines need a border and a open line inbet. e. annalie Excel Discussion (Misc queries) 2 January 30th 06 03:15 PM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"