Suppressing the top grid line of a cell - 2007 Excel

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi folks,
I have a question regarding group formatting for 2007 Excel. The
sample is as below:
column A column B
John Doe 1 apple
John Doe 1 orange
John Doe 2 apple
John Doe 2 orange
John Doe 2 banaba
John Doe 3 apple
John Doe 3 orange
John Doe 3 banaba
John Doe 3 pine apple
John Doe 3 pears
If I want to suppress the top grid line of a cell, whose contents are
the same as the above cell, is there is a way to achieve it for an
unexperienced Excel user. Thanks.
Peter Kao
 
There are Gridlines, and Borders. Gridlines will not show if the Cell is
colored, Borders may be configured by the user. So, to do as you wish
you would need to use Conditional formatting, and write the formula to
set a color(white)in the cell to hide the gridlines and then set an open
top border on the cell when the cell contents matched the cell above it.
 
Back
Top