View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default How do you add or remove gridlines from an individual cell?

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.