Vetical Filling blanks in a list

  • Thread starter Thread starter morchard
  • Start date Start date
M

morchard

I have a large table of data (about 30,000 rows) from which I want to
create a pivot table. Before I can do that though I have several
blanks cells which I need to fill in.

E.g. I have a value in cell A1 which should apply to cells A1 down to
A10 (but A2-A10 are currently blank). Then another vaue sits in A11
and needs to be applied vetically down for several rows.

I can fill in the blanks by selecting A1 and double clicking on the
cross hair in the bottom right corner of excel, this fills the value
down to A10.

But how can I do this for the whole 30,000 rows of data without having
to double click on every cell where there is a value in order to fill
down the column - this would take hours!

Thanks!
 
Hi
Select the column which contains your 'missing' values. Hit F5 and select
Special and then Blanks. Then type = a nd hit the up arrow and then hit
Ctrl+Enter. This will fill your blanks for you.

Hope this helps.

Andy.
 
Back
Top