Forum Discussion
autofill gaps in download list in excel with information from cells above
Hello I am struggling to remember how to autofill a list. Please see below. This is a dump of information. I am trying to autofill the gaps with the data from the cells above. Is there a quick way t...
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