drag down, not by series

  • Thread starter Thread starter Steve
  • Start date Start date
S

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