Fill Cells with same number in three rows then skip to next number

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross referencing 5
Excel formula for summing using figures from adjoining rows 3
Need Help filtering data 6
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row 5
Why Excel Does not increment by 2 or 3, odd/even numbers? 6
Using MAX is not pulling the maximum value when seperated by seconds 2
Math formulas possible with overstrike characters? 2
Return column header as solution to lookup 3

Back
Top