Someone has changed a worksheet I created so that not all of the gridlines
appear. I can use the format painter to copy the gridlines from rows that
are ok to the ones that aren't but can't figure out how this person removed
the gridlines from individual cells. They are not borders, they are actual
gridlines.

On Dec 30, 11:15*am, Kelcifer
wrote:
Someone has changed a worksheet I created so that not all of the gridlines
appear. *I can use the format painter to copy the gridlines from rows that
are ok to the ones that aren't but can't figure out how this person removed
the gridlines from individual cells. *They are not borders, they are actual
gridlines.

You can't. But they probably have either added white borders or used a
white fill on those cells, which block the gridlines from showing.

The person could have given the cells a background color of "white" which
will remove the gridlines.

Select them and format to a BG of "No Color" or "Automatic".


Gord Dibben MS Excel MVP

On Tue, 30 Dec 2008 09:15:01 -0800, Kelcifer
wrote:

Someone has changed a worksheet I created so that not all of the gridlines
appear. I can use the format painter to copy the gridlines from rows that
are ok to the ones that aren't but can't figure out how this person removed
the gridlines from individual cells. They are not borders, they are actual
gridlines.

Hi,

As mentioned you can't have two types of gridlines in a single sheet, can't
be done.

The most likely way was to make the cell's fill color white as indicated.
If you want to remove all of the fill colors click the top left corner of the
sheet to select the whole sheet, then choose Format, Cells, Patterns, No
Color.

However, there are other obscure ways

For example, yyou can put a rectangle directly over the cell and set its
fill color to None and its border to white.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kelcifer" wrote:

Someone has changed a worksheet I created so that not all of the gridlines
appear. I can use the format painter to copy the gridlines from rows that
are ok to the ones that aren't but can't figure out how this person removed
the gridlines from individual cells. They are not borders, they are actual
gridlines.