View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 40
Default How to copy into 1000s of cells?

I wrote:
Suppose I put a formula into A1, and I want to "copy down" through
A5000. What is the easiest way to do that?


Thanks for the responses. The NameBox/shift-Enter and GoTo/range
methods work best for me.