Monday, April 24, 2017

Excel Tricks - Fill blank cells with Content from Cell Above



This is SUPER Helpful!

1. Select the range that contains blank cells you need to fill.

2. Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option. See screenshot:

doc-fill-blank-cells-with-value-above2

3. Click OK, and all of the blank cells have been selected. Then input the formula "=A2 " into active cell A3 without changing the selection. This cell reference can be changed as you need. See screenshot:

doc-fill-blank-cells-with-value-above3

4. Press Ctrl + Enter, Excel will copy the respective formula to all blank cells. See screenshot:

doc-fill-blank-cells-with-value-above4

OPTIONAL: 5. At this point, the filled contents are formulas, and we need to convert the formals to values. Then select the whole range, copy it, and then press Ctrl + Alt + V to active the Paste Special… dialog box. Then select Values option from Paste, and select None option from Operation. See screenshot:

doc-fill-blank-cells-with-value-above5

6. Then click OK. And all of the formulas have been converted to values.

Link:

Sunday, April 16, 2017

Is Trump at Mar-a-Lago?