OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

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:A15, type a formula or text in cell B1, press Enter, and then double-click the fill handle, Excel fills the data down the column from cell B1 to cell B15.

 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.