Gord, unfortunately this didn't solve the problem I have with the borders
when I am inserting a new row. The problem occurs when the row above which I
insert a new row contains borders that are different to the row above it,
then as soon as I insert a new row the borders of the new row and the row
above which it was inserted become all messed up: in each row only part of it.

"Gord Dibben" wrote:

ToolsOptionsEdit

Uncheck "extend data range formats and formulas".


Gord Dibben MS Excel MVP

On Wed, 25 Jun 2008 02:14:00 -0700, Josh W
wrote:

Thanks Ross. I know how to insert rows but what you say is incorrect, let me
explain. Row 28 has a top border line all the way across (say to cell H). Now
when I insert a new row above row 28, the newly inserted row (now 28) gets a
partial top border (up to cell C) and row 28 which is now row 29 is missing
some of the top border. Greatly appreciate anyones help.