i have a large spreadsheet with missing data. Not all cells are fully
populated but the info is the same as the column above. how can i populate
the missing cells by copying the previous cell (where there is info) without
doing it manually. sample of data hereunder

Date
01.02.2006



20.03.2006



06.04.2006


07.04.2006



15.04.2006

please help. thanks in advance