Repetitive Data in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a formula so that I can have excel enter the same number every 10th
cell in a row?
 
Enter say 25 in A1 and K1.

Select A1 to T1.

Click on the fill handle of the selection, and drag along Row1 as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Is there a formula so that I can have excel enter the same number every 10th
cell in a row?
 
You must log in or register to reply here.

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

how do i parse every nth data point from a large data set in exce 1
Conditional Formatting - Draw Line every 10th Row 16
Software for "repetitions" 5
using the =page! feature to transpose a row to column 0
Learning arrays. 13
Cut & Paste in Excel without erasing cell borders? 1
Formula mismatch in Excel 2003 & 2007 2
Formula needed for repetative spreadsheet 3

Back
Top