View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Changing the incrementation when "puliing" cell values down a colu

in cell A2, type 12. Highlight A1 AND A2, drag down.

"Matt G" wrote:

I have a column formatted as text. In cell A1 i type "2". When I grab the
corner of the cell and "pull" down the cells below are populated increasing
by 1. Can I change the increment? I'd like it increase by a value of 10
each cell.