Suppressing the top grid line of a cell - 2007 Excel

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
 
B

Bob I

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppressing a cell content, which is the same as the above cell 2
How do I put a "hard space" into text in a excel 2007 cell? 2
Color Cells Based Upon Age of Info 4
Copy the contents of a cell in excel to another cell 2
Count how many instances of an item appear in a range 2
Automated transaction grouping and numbering 1
Generating Excel XML with embedded char(10)s 1
Retrieving the Top 10 of the Average of Two columns, but displaying a third 3

Top