Quickly Filling a Column

When creating a many-row worksheet, it is often necessary to type a formula in one of the top rows and fill the column with that same formula. A convenient way to find the bottom of the column is to go there once (when you are first working with the worksheet) and place a character in each cell of the last row.

Now, when you place your formula at the top of the column, you can simply do this:

  1. Select the cell that has your formula in it. (The one you just entered.)
  2. Press Ctrl+Shift+Down Arrow. This selects all the cells from the formula through the “bottom marker” in the column.
  3. Press Ctrl+D. The selected cells are filled with the formula.