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!


--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383305

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.


"morchard" wrote in
message ...

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!


--
morchard
------------------------------------------------------------------------
morchard's Profile:
http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383305

Try this, morchard:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"morchard" wrote in
message ...

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!


--
morchard
------------------------------------------------------------------------
morchard's Profile:
http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383305

Debra Dalgleish has a couple of techniques (manual and vba code) at:
http://www.contextures.com/xlDataEntry02.html



morchard wrote:

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!

--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383305

--

Dave Peterson