ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Light grey grid-lines (https://www.excelbanter.com/excel-discussion-misc-queries/87634-light-grey-grid-lines.html)

Jim May

Light grey grid-lines
 
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,





Keith

Light grey grid-lines
 
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,





Paul B

Light grey grid-lines
 
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,







Jim May

Light grey grid-lines
 
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,









All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com