Changin number when adding rows
 

When adding rows the automatic number colunm doesn't change automatically
why? Please help.

Changin number when adding rows
 

Yvonne,

Because the formula in that column isn't written to allow rows to be
inserted?

It would help if you would post the formula: the simplest formula that will
change automatically is

=ROW()

HTH,
Bernie
MS Excel MVP

"Yvonne" wrote in message
...
When adding rows the automatic number colunm doesn't change automatically
why? Please help.