Dragging without incrementing

  • Thread starter Thread starter Gianni
  • Start date Start date
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?
 
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?
 
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
Click to expand...

press CRTL and drag down.


Regards
Claus Busch
 
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.
Click to expand...

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

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.
 
Gianni said:
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?
Click to expand...

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.
 
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?
 
Back
Top