Using AutoFill

USING AUTOFILL TO FILL DOWN OR FILL RIGHT... 

AutoFill provides an additional feature you can use it to create a series. 

Figure 1-21. Some examples of the use of AutoFill to produce a series. (Above) cells selected for, and (Below) series produced by AutoFill.

In the same column as the experimental x values, create a suitable range of X values (the best way is to use AutoFill) to calculate the theoretical curve. The x values can be appended either at the end or the beginning of the experimental x values. 

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. 

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

First, create a range of cells containing the list to be displayed. Fill the range A1 A12 (use a different worksheet than the one where you re going to install the list box) with the text January, February, etc. You can use AutoFill to do this. 

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. 

CONTROL W When using AutoFill, copy a cell or range rather than create a series When using AutoFill, display the shortcut menu... 

AutoFill provides an additional feature you can use it to create a series. There are three ways to create a series. For example, to create the series 1,2,3,... in column A, you can either ... 

If you use the names TA1,...( TA4, TB1,...( TB4, etc., you ll find that (i) the nomenclature is expandable to systems requiring more than one set of Runge-Kutta terms, (ii) the names are accepted by Excel, whereas T1 is not a valid name, and (iii) you can use AutoFill to generate the column labels TA1TA4. 

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

Fill Right, using AutoFill to 27 FillDown method 259 filters, data, using multiple 138 FIND (worksheetfunction) 79 finding... 

---