G
Guest
I have a number of cases where I need to copy the same information to several
cells either across a row or down a column.
The easiest way to do it seems to be to just grab the square in the lower
right corner of the source cell and drag it across as far as needed.
This works fine when copying a single cell and the source cell contents are
either pure digits as in a Zip code or pure text as in a person's name
However if the source cell is text containing numbers as in a street address
Excel increments the number part of the cell for each new cell that is
filled. The same thing happens if there is a date in the source cell. Excel
increments every cell by 1 day.
Even worse, the action for a cell with pure numbers changes if you combine
it with other cells containing text or mixed text/numbers. In that case, even
pure numbers get incremented.
As a result, copying something like the following ( ! indicates cell
divisions)
Joe Blow!123 Some St.!Some city!Some state!123456!10 Feb/05
gives the following result in the next row
Joe Blow!124 Some St.!Some city!Some state!123457!11 Feb/05
The name which in my case always changes gets copied as is while the
address, Zip code, and the date registered which are often the same for many
rows get changed by Excel.
How can I stop Excel from changing data I don't want changed during a copy?
I know that I can select the cells I want copied then select the target
cells and do a copy, however that is not as quick and I also find myself
getting in trouble because Excel changes what happens when drag copying
depending on the cell contents. Since plain text or plain numbers can easily
be drag copied, it is very easy to forget about the cell contents and drag
copy a mixed number/text cell and that results in errors.
cells either across a row or down a column.
The easiest way to do it seems to be to just grab the square in the lower
right corner of the source cell and drag it across as far as needed.
This works fine when copying a single cell and the source cell contents are
either pure digits as in a Zip code or pure text as in a person's name
However if the source cell is text containing numbers as in a street address
Excel increments the number part of the cell for each new cell that is
filled. The same thing happens if there is a date in the source cell. Excel
increments every cell by 1 day.
Even worse, the action for a cell with pure numbers changes if you combine
it with other cells containing text or mixed text/numbers. In that case, even
pure numbers get incremented.
As a result, copying something like the following ( ! indicates cell
divisions)
Joe Blow!123 Some St.!Some city!Some state!123456!10 Feb/05
gives the following result in the next row
Joe Blow!124 Some St.!Some city!Some state!123457!11 Feb/05
The name which in my case always changes gets copied as is while the
address, Zip code, and the date registered which are often the same for many
rows get changed by Excel.
How can I stop Excel from changing data I don't want changed during a copy?
I know that I can select the cells I want copied then select the target
cells and do a copy, however that is not as quick and I also find myself
getting in trouble because Excel changes what happens when drag copying
depending on the cell contents. Since plain text or plain numbers can easily
be drag copied, it is very easy to forget about the cell contents and drag
copy a mixed number/text cell and that results in errors.