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

  • Thread starter Thread starter Joe
  • Start date Start date
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
 
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)
 
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!
 
Joe said:
That did it thanks Ron!
Click to expand...

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

I'm glad I could help.

Regards,

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

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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
Remove date format? 3
Sorting Data Advice please 2
Returning every 7th row of a column 8
Conditional Formating based on start and end dates 1
copy formulas over merged cells 2
Duplicate a set of rows for each item (subdatasheet?) 0
Finding a sum by matching two cells with the same identifier 1

Back
Top