Insert row with formatting from row below instead of row above?

  • Thread starter Clueless in Seattle
  • Start date
C

Clueless in Seattle

My default Excel template has the top row formatted as a header, with
bold text and a dark bottom border to distinguish it from the rows
below.

So if I insert a row at row 2, the new row is formatted like the
header. Then I have to select the new row and remove the bold font,
remove the dark border, select the header row and reapply the bottom
border.

Is there a way I can change the insert default so that it takes it's
formatting from the row below instead of the row above. Or better
yet, so that it has no formatting at all?
 
R

RagDyer

Right click in any empty row (click in Row Number),
Choose "Copy",
THEN, right click in row2,
And Choose "InsertCopiedCells".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


My default Excel template has the top row formatted as a header, with
bold text and a dark bottom border to distinguish it from the rows
below.

So if I insert a row at row 2, the new row is formatted like the
header. Then I have to select the new row and remove the bold font,
remove the dark border, select the header row and reapply the bottom
border.

Is there a way I can change the insert default so that it takes it's
formatting from the row below instead of the row above. Or better
yet, so that it has no formatting at all?
 
E

Earl Kiosterud

Rag,

This may confound formulas that start with the first data row, like
=SUM(A2:A100).

A technique I've had luck with is to put an extra row under the heading, and
format it like the other detail rows, but put no data in it, and hide it.
That way, you're not working at the edge of the range, so to speak. Same
for the bottom.
 
R

RagDyer

I like your idea Earl, but what I suggested will do no worse then what the
OP is now doing, while helping with his formatting.
His simple insert will *also* not be picked up by the formula you mentioned.

Let's hope he picks up on your suggestion.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Rag,

This may confound formulas that start with the first data row, like
=SUM(A2:A100).

A technique I've had luck with is to put an extra row under the heading, and
format it like the other detail rows, but put no data in it, and hide it.
That way, you're not working at the edge of the range, so to speak. Same
for the bottom.
 
Top