copy cells

P

Pass Codes

..I'm trying to copy a cell range in a cell, then copy down that cell without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

Geo
 
R

Rick Rothstein \(MVP - VB\)

.I'm trying to copy a cell range in a cell, then copy down that cell
without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?
Click to expand...

If I understand what you are saying, just add the $ in front of the
column/row letter/numbers for the range after copying it into the cell but
before copying that cell down. That is, if your copied range is this...
C2:D14, just change it to $C$2:$D$14 after copying it into the cell, then
copy the cell downward.

Rick
 
G

Gord Dibben

Yes. It makes sense.

Excel by default will increment as you copy because of Relative referencing.

=A1 + B1 copied will become =A2 + B2

Absolute referencing treats the cells differently.

$A1 will keep the column but change the row.

$A$1 will keep both row and column same.

A$1 will keep row the same but incease the column as you drag across.

To change these around, select the references in the formula bar then cycle
through the options using the F4 key.


Gord Dibben MS Excel MVP
 
Top