Hi it's me again,

This is exactly my problem. I some times excell does copy format and
formulas from the row above/below automatically. but other times it doesn't
and I need to just insert a row and when I insert my values my formulas will
automatically show it's outcome.

I did the following step but still it's like it's turn off.
please help me I Desperate :(

step explain by HELP:
Extend formats and formulas to additional rows
By default, Microsoft Excel automatically formats new data that you type at
the end of a range to match the preceding rows. Excel also automatically
copies formulas that have been repeated in the preceding rows and extends
them to additional rows.

Note In order to be extended to new rows in the range, the formats and
formulas must appear in at least three of the five preceding rows.

You can turn this option off (or back on again) at any time:

On the Tools menu, click Options.
On the Edit tab, clear the Extend data range formats and formulas check box
to turn automatic formatting off.
To turn automatic formatting back on again, select the Extend data range
formats and formulas check box.



"JP" wrote:

Hello,

You can protect the worksheet and still allow others to insert rows.
If you are in Outlook 2003:

1. Unlock and unprotect all cells (Ctrl-A, then Ctrl-1, Protection
tab, uncheck 'Locked' and 'Hidden')
2. Select the formula cells you want to protect, hit Ctrl-1,
Protection tab, check 'Locked' and 'Hidden')
3. When protecting your worksheet, under 'Allow all users of this
worksheet to", select 'Insert rows'

HTH,
JP

On Oct 5, 1:54 pm, susy wrote:
Hi my name is susy,

I'm working on a finacial structure that should be used for entry of data by
many person. I thought about locking the worksheet, but some else shoul be
able to insert a row a keep working withou messing with my formulas.

What should I do to automatically insert a row with the same formula at
least with the same formats?

susy