how to apply the same date to each row of a column?

J

Joe

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
 
R

Ron Coderre

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

Joe

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)
Click to expand...

That did it thanks Ron!
 
G

Gord Dibben

Joe

In addition, look at the optiuons available when you right-click and drag then
release.


Gord Dibben MS Excel MVP
 

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

How To Have A Cell Be Blank If... 2
Returning every 7th row of a column 8
Keyboard shortcut to select a column? 7
how to strip an individual symbol from each row in a column 1
Finding a sum by matching two cells with the same identifier 1
How to... apply the same formula to every cell? 3
Take a column of numbers and automatically make them into a row 1
freeze row AND column simultaneously 3

Top