Cell Drag & Drop without Incrementing

[Paul]

Hi,

Simple question really. Is it possibe to drag a cell
without it incrementing automatically. Eg if cell a1
contains TR321 I want to be able to drag it down to fill
cells a2:a10 without any change, ie A10 is also TR321.

Cheers, thanks for your help.

Paul

 

[Frank Kabel]

Hi Paul
use an absolute reference. change the cell reference
TR321
to $T$321
also have a look at
http://www.cpearson.com/excel/relative.htm

 

[Bernie Deitrick]

Paul,

Hold donw the Ctrl key while you drag.

HTH,
Bernie
MS Excel MVP

 

[Jim Rech]

Another option is to drag with the right mouse button. When you release the
button you get a context menu where you can pick the result you want.

--
Jim Rech
Excel MVP
| Hi,
|
| Simple question really. Is it possibe to drag a cell
| without it incrementing automatically. Eg if cell a1
| contains TR321 I want to be able to drag it down to fill
| cells a2:a10 without any change, ie A10 is also TR321.
|
| Cheers, thanks for your help.
|
| Paul