Dragging without incrementing

G

Gianni

I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

Is there some way of doing this?
 
J

Jim Cone

1. Copy the cell, select the destination cells, paste.
-or-
2. Change the number format of the original cell to text.
Drag and fill.
Change the number format, for all cells, to date.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

..
..
..

"Gianni" <[email protected]>
wrote in message
I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10
Is there some way of doing this?
 
C

Claus Busch

Hi Gianni,

Am Sat, 21 Aug 2010 10:45:58 -0400 schrieb Gianni:
08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

press CRTL and drag down.


Regards
Claus Busch
 
G

Gianni

Jim said:
1. Copy the cell, select the destination cells, paste.
-or-
2. Change the number format of the original cell to text.
Drag and fill.
Change the number format, for all cells, to date.

Copy and Paste works.

If I change the column to Text
08/21/10 becomes 40411.

It is already Date format.

I tried creating a column from scratch
that was text and entered

08/21/10

and when I dragged it, it became

08/21/11

Copy and Paste seems to be the only
thing that works.

Thanks for answering.
 
D

Dave Peterson

I rightclick on that autofill button and drag down. Then when I release the
mouse, I get a prompt asking me how I want to fill in the range.

For me, it's easier than remembering what those control-keys do.
 
S

Stan Brown

I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

Is there some way of doing this?

What I usually do is type the value in the first of the destination
cells, so I then have two cells together with the same value. I
highlight both, and click and drag. Excel seems to know that the
increment is zero since the two source cells are identical.

There's probably a more elegant way, but this WFM.
 
Joined
Jan 18, 2017
Messages
1
Reaction score
0
I have a column of cell with the date, e.g.,

08/21/10

I want to be able to drag the cell without
incrementing the date to 08/22/10

Is there some way of doing this?

After reading the answers and having them not work for me too, here is what I did. I entered my date in cell A1, then entered the formula "=A1" for A2. I then double clicked the + in the lower right corner of A2 to clone it for the rest of that column. That way as long as A1 does not get edited, everything under it will be the same with no incrementing.

Hope this helps someone one day.
 
Joined
Jan 19, 2018
Messages
1
Reaction score
0
Thank you, but this does not work for me. I am trying to calculate a running date range by subtracting the dates from two cells. The date for the first part of the calculation should stay the same for the column. =(Date - Constant past date). When I try the $ modification or the F4, the constant date still changes with each cell. Any thoughts?
 

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

Top