Re: Insert Line maintaining formatting and formulas from preceding line

<mangled_us@xxxxxxxxx> wrote in message
news:1133179326.487954.219310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I use an Excel 2003 spread*** for my company accounts and in order to
> maintain data order of entries I need to insert lines between existing
> lines in the spread***, maintaining the formulas and formats of the
> preceding lines but leaving the data fields of the new line blank in
> readiness for the new data.
>
> Can anyone tell me how to do this ?
>
> Thanks,
>

David

If inserting a line doesn't carry formats from the previous line, then
insert lines as needed, select the line to be copied, copy, paste special to
the inserted rows. Select "fomulas and number formats". Does this work for
you, or too long a process? (I'm using Excel 2002)

beege

> David
>


.