Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My boss has come to me asking how can he get rid on several cells of a report
he's preparing that have small grey grid-lines/borders, not sure which |______| << this is the look of them (3 sided types).. I've tryed several things but can't clear them. Can anyone suggest another "trick"? TIA, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the small grey grid lines show up on the screen only and not on the
printed version (with gridlines unchecked in the page setup under "sheet" tab") and he is wanting to have the screen not show those gridlines, he could "fill" the cell with white and the grey gridlines won't show on the screen anymore. Hope this helps. "Jim May" wrote: My boss has come to me asking how can he get rid on several cells of a report he's preparing that have small grey grid-lines/borders, not sure which |______| << this is the look of them (3 sided types).. I've tryed several things but can't clear them. Can anyone suggest another "trick"? TIA, |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jim, try selecting the cells and format, cells, borders, select none, ok
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jim May" wrote in message ... My boss has come to me asking how can he get rid on several cells of a report he's preparing that have small grey grid-lines/borders, not sure which |______| << this is the look of them (3 sided types).. I've tryed several things but can't clear them. Can anyone suggest another "trick"? TIA, |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Paul, but this is one of things I tried before writing in...
If I take a "good" cell (without the lines) click on it , use the Format painter, and paint over such cells |____| WITH Values in it - the lines disappear. !!!, but if I do the same with a cell whose value (by formula) is 0, the lines disappear, but a "-" appears in that cell (Again something my boss doesn't want to see).. Thanks, "Paul B" wrote: Jim, try selecting the cells and format, cells, borders, select none, ok -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jim May" wrote in message ... My boss has come to me asking how can he get rid on several cells of a report he's preparing that have small grey grid-lines/borders, not sure which |______| << this is the look of them (3 sided types).. I've tryed several things but can't clear them. Can anyone suggest another "trick"? TIA, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grid lines | Excel Discussion (Misc queries) | |||
Partial Grid Lines | Excel Discussion (Misc queries) | |||
printing grid lines | Excel Discussion (Misc queries) | |||
Save as Web Page with grid lines | Excel Discussion (Misc queries) | |||
Bold Grid Lines | Excel Discussion (Misc queries) |