Thanks David

Gordon

Apologies for not explaining the process of grabbing the "fill handle" at the
lower right corner of the cell.

Note: you must have ToolsOptionsEdit "Allow cell drag and drop"
enabled(checked) or the handle will not appear.



On Sat, 27 Nov 2004 13:35:44 -0500, "David McRitchie"
wrote:

Hi Gordon,
that little bulge is called the fill handle, read more about
the fill handle and mouse control at
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gordon" wrote in message ...
Gordon wrote:
Gord Dibben wrote:
Enter 2005-001 in A1

Right-click on A1 and drag down column A to A550.

Interesting. In Excel 2002, right-clicking brings up the context menu
and you CAN'T drag down the column.

Ah. You have to right click on the CORNER of the cell, where the cursor
changes to a "+"