Forum Discussion

rshenk3's avatar
rshenk3
Copper Contributor
Nov 17, 2021
Solved

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

Hello,   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
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 17, 2021

    rshenk3 

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Nov 17, 2021

rshenk3 

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.

Resources