drag down, not by series

[Steve]

Morning all.
I have a worksheet with some merged cells. I am unmerging those cells, and
then entering the individual data in each of the cells.
E.g.
41-140-12
was in the merged cell group, and I now need it in each of the unmerged
cells.

The problem that I'm having is that when I drag the original value down to
fill the next cell, it automatically goes to the next number-- 41-140-13,
etc.... down through the distance I'm dargging it.

What do I need to set in Excel options to stop this?
I.e., when I unmerge, and then drag the first value down, I want it to
remain 41-140-12 through the range that I'm dragging it.

and the cell format is set to general, not numeric.

Yea, I know. we get all hot and bothered over newer and more intuitive tech,
and then when we need the old stuff, we can't find it anymore.....

Thank you.

 

[Bill Kuunders]

drag down holding the <cntrl> button

or as you say the good old copy (highlight the new range) and paste works
to

greetings from New Zealand

 

[Pete_UK]

Why not put a formula in the second cell:

=first_cell

then when you drag this down it will keep the value of the first cell.

Or you could make it:

=$first_cell

(i.e. with absolute address) in case you are copying non-contiguously.

Hope this helps.

Pete

 

[Steve]

Bill,
Thank you.
I've used that for copying new worksheets, but never for copying data down--
works like a charm.
Thanks.
Had some friends from back in the early 80's who were from Christ Church and
a math prof who went there too to teach math about 5 years back.

Best.

 

[Steve]

Hi Pete,
We're seeking to avoid any formulas in our data sets. It works great for
side work, but we've found it causes unwanted troubles into the future, so we
no longer use the formulas in our print fields.
Thank you though.
Best.