Do you have the sheet protected by any chance?

Have you tried entering the first value in the series and the drag-filling
the rest?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"chris j" <chris wrote in message
...
I used the series option to autofill a column with numbers using Excel
2003.
However, I am not able to duplicate this process using Excel 2007. One of
the problems is that the "Series" option is grayed out when I select the
Fill
Menu. If I could ever select it, I am sure I could compete this process.
Do
I need to set something somewhere in order to make it available to me? I
tried highlighting the entire row that needs to be numbered in a range and
I
also tried highlighting just the cells numbered 1 and 2. None of these
options makes the series option available. I need to know the steps to
make
sure the series option is not grayed out.