Copy cell value down until next non-blank cell

Use the following steps to copy a cell value down until the next non-blank cell.

  1. Highlight column you want to fill
  2. Click Home tab -> Find & Select -> Go To Special -> Blanks -> Ok
  3. Enter = in cell
  4. Click arrow key up
  5. Press Ctrl Enter
  6. Value will fill in blank cells until next value and then switch

1.Highlight column you want to fill

2. Click Home tab -> Find & Select -> Go To Special -> Blanks -> Ok

3. Click arrow key up

4. Press Ctrl Enter

Copy cell value down until next non-blank cell

Copy cell value down until next non-blank cell

Interested in learning new skills?