You state you want row 6 and below to have the same formulas as row 5 but
then you want to enter data in row 6 and below.

You cannot have formulas in cells then enter data in those same cells
without erasing the formulas.

Please re-describe what you need.


Gord Dibben MS Excel MVP


On Wed, 20 May 2009 05:51:02 -0700, Ra wrote:

The problem:

I have set up a work sheet with formulae in the following row:

Cells E5 to Z5 are populated with formulae,
(F5, G5, I5, L5, Q5, V5, Y5, Z5 have Conditional Formatting). The formulae,
in some cases, are dependent on the preceding cell.

I would like to apply all these formulae to all the rows from row 5 and
below. Also, I would like all the formulae to be hidden. So that when new
data is entered in rows 6 to X, all you see is the data being entered with
the formulaes being hidden.

Please can you help, I am new to excel so simplicity is key.

Many thanks,