Thread: Range of values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Range of values

Hi,

Enter 100 in cell A5. In cell A6, type =A5+5 and copy down

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"David" wrote in message
...

Excel 2007
How do I make a range of cells values from 100 to 500 with increments of
5,
i.e., 100+5...(100 105 110 115 120...500)