|
|
Double-click the Fill Handle to Automatically Fill Data You can double-click the fill handle of a selected cell to fill the contents of the cell down a column for the same number of rows as the adjacent column. For example, if you type data in cells A1:A20, type a formula or text in cell B1, press ENTER, and then double-click the fill handle, Microsoft Excel fills the data down the column from cell B1 to cell B20.
|