Sorry, Micky - my goof! I had manual formula set.

Thanks for your help!

Carole O

"מיכאל (מיקי) אבידן" wrote:

In A1 type: =MOD(ROW()-1,27)+1 and copy down.
This will enable deletion of row(s) without producing an Error.
Micky


"Carole O" wrote:

Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O