Why not just copy the last formatted row and Paste/insert it below the that
row. It should maintain formatting. However, your Totals at the bottom may
not update correctly. In the checkbook type worksheet that I use, I have my
totals at the top instead of the bottom. That way you can total as far down
as you want and not have to change the formulas each time you add a new row.
When the totals are at the top, you can freeze the panes so that they'll
always be visible when scrolling.

Just a thought.
Paul

"Namras" wrote in
message ...

Hi everyone. :)

I'm sure this is something very simple that I'm overlooking, but I
can't come up with a good solution after hours of playing around. I'm
hoping someone with more skill than I can help me out. :)

I'm trying to create sort of an ongoing checkbook register type of
sheet. I have about 8 columns per row, some columns are plain text,
some numbers, and 3 or 4 of them are calculated/forumla columns based
on other columns in the row.

What I want to be able to do is insert a new record (row) below the
existing records every so often. Catch is that I want the new rows to
be formatted like all the previous rows (borders, patterns, etc) and
carry the same formulas as the previous rows.

I know I could just have like a thousand pre-formatted rows from the
beginning that I just fill in, but I'd rather not do that because I
only want Excel to print/show the neccessary amount of pages and not a
bunch of blank formatted rows that I've not yet filled in. And I don't
want my totals row (the row at the very end that sums up some of my
columns) to be like on page 12 when my records only go up to page 3.
;)

I hope that makes sense; if not, please ask and I'll try to explain
better.

Thanks in advance to anyone who could help me out. :)


--
Namras
------------------------------------------------------------------------
Namras's Profile:
http://www.excelforum.com/member.php...o&userid=29873
View this thread: http://www.excelforum.com/showthread...hreadid=495769