Objective is to fill all the blank cells in a column with the Data from the above cell. Below images can explain it in a better way:
 |
To solve this problem there can be many ways, hardest and very time consuming being copying and pasting data manually specially when you're dealing with large data. We can write 'n' number of formula's to solve this, but I am going to tell a very simple and quick method of doing it.
Here we go,
- First select all the columns containing your data
- Press Ctrl+G or F5 this will open Go To dialogue box
- Press Special... and a new dialogue box will pop out
- This will select all the blank cell in your data and Type "=" and then hit up arrow for example A4: =A3
- Press Cltr+Enter to input that formula into all currently selected blank cells.
And we are done in a flash.
This appears simple to me, Let me know what do you think.
