Forum Discussion
autofill gaps in download list in excel with information from cells above
Select the entire range.
Press F5 to display the Go To dialog.
Click Special...
Select Blanks, then click OK.
Look at the name/address box on the left hand side of the formula bar and note the address of the active cell.
Let's say that it is A2.
Enter the following formula, and confirm it by pressing Ctrl+Enter to populate all selected cells.
=A1
(A1 is the cell above the active cell)
HansVogelaar thank you for your reply. It’s very helpful. I have been able to select all the blanks very quickly however after selecting the cell above the active cell, and then hit control and enter, the gaps are not filled. How do I overcome this please?
thanks in advance
1) After selecting the range.
2) After F5, Special..., Blanks, OK. Note the cell address.
3) After entering the formula =A1 and pressing Ctrl+Enter:
- Excellent thank you 😊
Much appreciated. J