Autofill
 

I have some data that I would like to copy down and want to click the black
box in the lower right corner to do so. The problem is the data is a number
and when I do it Excel assumes that I want the next row to be that number
plus 1. Is there anyway that you can turn that off so that it copies the
same number the entire way?

Autofill
 

Greg,

That thing is called the Fill Handle. If you hold Ctrl, it will stop
incrementing the numbers. Be sure you're still holding Ctrl when you
release the mouse button.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Greg" wrote in message
...
I have some data that I would like to copy down and want to click the black
box in the lower right corner to do so. The problem is the data is a
number
and when I do it Excel assumes that I want the next row to be that number
plus 1. Is there anyway that you can turn that off so that it copies the
same number the entire way?

Autofill
 

Right-click and drag.

Release the button and select "copy cells".


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 14:40:02 -0800, Greg wrote:

I have some data that I would like to copy down and want to click the black
box in the lower right corner to do so. The problem is the data is a number
and when I do it Excel assumes that I want the next row to be that number
plus 1. Is there anyway that you can turn that off so that it copies the
same number the entire way?