View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Fill Cells with same number in three rows then skip to next number

A1: 178
A2: 178
A3: 178
A4: =A1+1
Copy down as needed. Then, if you want these numbers to be actual numbers,
and not formulas anymore, select your column of data, copy it, then paste
special: values over the top of itself.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Tracy" wrote:

I need to fill cells using the same number three times and then the next
number three times and so on: Each time I drag to fill it adds a row and the
numbers change to 178.999303.

178
178
178
179
179
179
--
Tracy