View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Alyssa M[_2_] Alyssa M[_2_] is offline
external usenet poster
 
Posts: 3
Default How to "copy-down" a formula in a Very LONG Column?

Hello,

This is probably a hack way of doing it, but you can just copy that first
cell, then click on the column letter (B for example) and paste it to the
whole column. Now, it'll go past your 14,000 lines, so there's probably a
better way of doing it :)

"Mark246" wrote:

Excel 2007...

I put a formula in cell C1.
I want to copy it down to the end of the column, but the column has
140,00 records.
It takes Several minutes to scroll manually.
Is there a faster way to do it?

Thanks, in advance.

Mark246