How do I make the "series" option available under the Fill Menu?

  • Thread starter Thread starter chris j
  • Start date Start date
C

chris j

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
fill series option not available 5
How to put series of number in excel when the filter is applied? 3
Fill Series Grayed out and does not Work? 3
Alternating Fill Series 5
filter and autofill series number 1
auto fill options (copy cell, not create series) 4
Fill Series Not Functioning 1

Back
Top