Insert Line maintaining formatting and formulas from preceding line

M

mangled_us

Hi,

I use an Excel 2003 spreadsheet for my company accounts and in order to
maintain data order of entries I need to insert lines between existing
lines in the spreadsheet, 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
 
M

mangled_us

insert row it will automatically take the format of the row above it

Nope.

David
 
B

Beege

Hi,

I use an Excel 2003 spreadsheet for my company accounts and in order to
maintain data order of entries I need to insert lines between existing
lines in the spreadsheet, 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,
Click to expand...

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
 
M

mangled_us

I use an Excel 2003 spreadsheet for my company accounts and
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)
Click to expand...

Well, that;s what I've been doing, but it's an almighty nuisance and
then you have to clear the pasted data from the new cells afterwards...

I'm sorry to moan, but this seems like such obviously necessary
functionality that I really cannot understand why it's not more simply
available in the interface?

Thanks,

David
 
D

Dana DeLouis

...I need to insert lines
between existing lines in the spreadsheet, maintaining the
formulas and formats of the preceding lines
Click to expand...

Don't know if these keyboard shortcuts will work for you, but these I use
often enough...
Shift + Spacebar ...select entire row.
Ctrl+Shift "+" to Insert Row
Ctrl + "D" to copy the row above, down to present row

Hope these help.
 
M

mangled_us

Thanks to all for the answers, the macro worked for me.

If anyone from the Microsoft Excel team is listening then I hope you
don't mind me giving my opinion that I really think this issue needs to
be addressed in the "Insert Line" menu somehow.

Thanks again,

David
 
Top