Fill Down, using AutoFill

FALSE (worksheetfunction), use with array formulas 99 Fill Down, using AutoFill to 27 fill handle 27... 

The fourth method uses an array formula that can be entered into a single row of cells (here T5 U5) and then copied into the complete range of cells using either Fill Down or AutoFill ... 

USING AUTOFILL TO FILL DOWN OR FILL RIGHT... 

If you have imported a data file with a large number of data records (e.g., 8000 data points) you may wish to work with a reduced data set, say, every fiftieth point. The following sections describe three ways you can create such a list by using AutoFill to Fill Down a pattern, by using Excel s Sampling tool, or by using a worksheet formula. 

As you saw in Chapter 1, you can use AutoFill to Fill Down a pattern of selected cells. You can use this feature to select every Nth value in a range. 

Use AutoFill to fill this pattern down to the end of the data, in row 236. This will return every 10th line of x,y values. 

To plot the theoretical binding curve, generate Scale for a range of [U], as follows. In cell A20 type 0.000, in A21 type 0.001, then use AutoFill to generate values from 0.000 to 0.100 in steps of 0.001. Copy the expression for [U] and Paste in cell C20. Fill Down to end of table. Transfer the expression for Scale from any cell in row D to cell F20 (Copy to D20, Cut and Paste to F20 to transfer correctly). Fill Down to end of table. 

---