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?