"Joe" wrote in message
...
On Jan 6, 10:28 am, "Ron Coderre"
wrote:
To retain the same value:
Hold down the CTRL key as you drag the fill handle.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Joe" wrote in message

...

I would like a date in a certain cell to stay static as I drag it down
a column, right now as I drag it the dates move up sequentially and I
don't know how to keep the date the same aside from the tedious task
of cutting and pasting in each cell. Thanks

That did it thanks Ron!

--------------------------

I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)