Formula for checking for blank cells and if blank copying from cell above

New Contributor



I need a formula or process that checks the entire sheet for blank cells and if the cell is blank then it copies the information from the cell above it.  Please help! Thanks

1 Reply
best response confirmed by rshenk3 (New Contributor)


Select the range you want to apply this to.

Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

Select the option button Blanks.

Click OK.

Note the address of the active cell in the selection in the name box on the left hand side of the formula bar.

Let's say the active cell is C5.

Enter the formula =C4 (this refers to the cell above it) and press Ctrl+Enter to apply the formula to all selected cells.