View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

You must select a range of cells first.
Type 1 in A1; select A1:A20, use Edit|Fill|Down
or
Type 1 in A1; select A1:A20, use Edit|Fill|Series and type 20 in Stop Value
or
type 5 in B1 and 10 in B2; select B1:B2 and move mouse point over 'fill
handle' - solid square in lower right corner of B2; pull this down to B10
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeffry" wrote in message
...
Excel 2002 help on filling a series of numbers refers to "Use the Series
command on the shortcut menu". Nowhere are the series command nor shorcut
menu defined. Further, all I can do is copy a number instead of doing a
series. Only copy cells is not grayed out on the popup menu from a right
click or on the Edit, Fill menu from the toolbar.

I have 1 in the first cell, 2 in the second, grab the handle and drag, and
cannot fill a series regardless of any key is used or not. This worked on
Friday and the previous year.