Dave,

It is only happening on my one data sheet that has columns that are setup as
a data validation list and also columns that have no special formatting. Any
other suggestions?
Suzanne

"Dave Peterson" wrote:

I read this slightly differently than Gord.

Any chance you're dragging down a filtered list. If so, do a
data|filter|showall first.

sbrimley wrote:

I am trying to use auto fill and when I drag the fill handle down it does not
give me the Auto fill option box so I can change the options, how do I get it
back?
Using Excel 2002

Thanks Suzane

--

Dave Peterson