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

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

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

Sure, I can help you with that! What you need to do is to use an absolute reference for the cell containing the date. Here's how you can do it:

1. Select the cell containing the date that you want to keep static.
2. Press the F4 key on your keyboard. This will add dollar signs ($) to the cell reference, making it an absolute reference. For example, if your date is in cell A1, it will change from "A1" to "$A$1".
3. Now, when you drag the formula down the column, the date in the absolute reference cell will stay the same.

Alternatively, you can also manually add the dollar signs to the cell reference by typing them in. For example, if your date is in cell A1, you can change the formula from "" to "".

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

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

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

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!

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

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

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

Joe

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


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 07:43:30 -0800 (PST), Joe wrote:

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!