Hi,

This section describes the following:

A. Fill formulas into adjacent cells
B. Sort a Range

A. Fill formulas into adjacent cells

1. Select the cell that contains the formula that you want to fill into
adjacent cells.
2. Drag the fill handle across the cells that you want to fill.
3. You can use the Auto Fill Options button , which appears after you drag
the fill handle, to choose how to fill the selection. For example, you can
choose Fill Formatting Only or Fill Without Formatting.

Note:

You can also fill the active cell with the contents of the cell above it.
Point to Fill on the Edit menu, and then click Down (or press CTRL+D). To
fill the active cell with the contents of the cell to the left, point to Fill
on the Edit menu, and then click Right (or press CTRL+R).

Tip You can automatically fill a formula downward, for all adjacent cells
that it applies to, by double-clicking the fill handle of the first cell that
contains the formula. For example, you have numbers in cells A1:A15 and
B1:B15, and you type the formula =A1+B1 into cell C1. To copy that formula
into cells C2:C15, select cell C1 and double-click the fill handle.

################################################## ##

B. Sort a Range

Sort rows by four criteria (columns)

1. Click a cell in the range you want to sort.
2. On the Data menu, click Sort.
3. In the first Sort by box click the column of least importance.
4. Click OK.
5. On the Data menu, click Sort.
6. In the Sort by and Then by boxes, click the other three columns you want
to sort, starting with the most important.
7. Select any other sort options you want, and then click OK.

Challa Prabhu


"Alex" wrote:

I have a report that looks like this:

Part # Order # Qty

123 5678 7
5346 3
9988 10
6665 6
7524 2297 3
6685 4
8963 4444 66
3425 44

And I need it to look like this so I can sort and use the data:

Part # Order # Qty

123 5678 7
123 5346 3
123 9988 10
123 6665 6
7524 2297 3
7524 6685 4
8963 4444 66
8963 3425 44

Is there a way to fill cells with the value from the closest cell containing
data above it?