close

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
|______| lt;lt; this is the look of them (3 sided types).. I've tryed several
things but can't clear them.
Can anyone suggest another quot;trickquot;?
TIA,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 quot;sheetquot;
tabquot;) and he is wanting to have the screen not show those gridlines, he could
quot;fillquot; the cell with white and the grey gridlines won't show on the screen
anymore. Hope this helps.

quot;Jim Mayquot; wrote:

gt; My boss has come to me asking how can he get rid on several cells of a report
gt; he's preparing that have small grey grid-lines/borders, not sure which
gt; |______| lt;lt; this is the look of them (3 sided types).. I've tryed several
gt; things but can't clear them.
gt; Can anyone suggest another quot;trickquot;?
gt; TIA,
gt;
gt;
gt;
gt;

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 amp; 2003

quot;Jim Mayquot; gt; wrote in message
...
gt; My boss has come to me asking how can he get rid on several cells of a
gt; report
gt; he's preparing that have small grey grid-lines/borders, not sure which
gt; |______| lt;lt; this is the look of them (3 sided types).. I've tryed several
gt; things but can't clear them.
gt; Can anyone suggest another quot;trickquot;?
gt; TIA,
gt;
gt;
gt;
gt;
Thanks Paul, but this is one of things I tried before writing in...
If I take a quot;goodquot; 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 quot;-quot;
appears in that cell (Again something my boss doesn't want to see)..
Thanks,quot;Paul Bquot; wrote:

gt; Jim, try selecting the cells and format, cells, borders, select none, ok
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Jim Mayquot; gt; wrote in message
gt; ...
gt; gt; My boss has come to me asking how can he get rid on several cells of a
gt; gt; report
gt; gt; he's preparing that have small grey grid-lines/borders, not sure which
gt; gt; |______| lt;lt; this is the look of them (3 sided types).. I've tryed several
gt; gt; things but can't clear them.
gt; gt; Can anyone suggest another quot;trickquot;?
gt; gt; TIA,
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()