Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????

On Sun, 17 Jul 2005 07:59:03 -0700, "JERRY"
wrote:
Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????

If you do not want dates to copy progressively, put the date in 2 or 3
fields (I think three are required) and then drag using the all three
as a selection.

As for the latter, it worked fine for me. Insert "Book 1" and then
"Book 2", select both, drag or fill.

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

Are you pressing the Ctrl key as you drag? That could cause the
behaviour that you described.

JERRY wrote:
Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

WOW!!! WHOOD OF THUNK IT!!! --Thank you VERY much. Works just as I want it .
Guess I missed THAT memo.--I don't care what anyone say's Debra,---You're
OK.---
Jerry

"Debra Dalgleish" wrote:

Are you pressing the Ctrl key as you drag? That could cause the
behaviour that you described.

JERRY wrote:
Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi M.P. thanks for the help, however Debra D. hit the nail perfectly...
Jerry

"Mangus Pyke" wrote:

On Sun, 17 Jul 2005 07:59:03 -0700, "JERRY"
wrote:
Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????

If you do not want dates to copy progressively, put the date in 2 or 3
fields (I think three are required) and then drag using the all three
as a selection.

As for the latter, it worked fine for me. Insert "Book 1" and then
"Book 2", select both, drag or fill.

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

You're welcome! And who has time to read all the memos?

JERRY wrote:
WOW!!! WHOOD OF THUNK IT!!! --Thank you VERY much. Works just as I want it .
Guess I missed THAT memo.--I don't care what anyone say's Debra,---You're
OK.---
Jerry

"Debra Dalgleish" wrote:


Are you pressing the Ctrl key as you drag? That could cause the
behaviour that you described.

JERRY wrote:

Dates in 2003 Excel copy progressively using click/drag (which I don't like)
and numbers (ie. book 1-book 2--copy /drag = book 3, 4,5 etc. ) DOES NOT
(which I would like). ---
What to do what to do??--
Excel 97 copied words w/ numbers the progressive way -- why not 2003????????


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html