Cell Drag & Drop without Incrementing

P

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
 
J

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
 
Top