Copy cell shortcut needed

[magmike]

If I type a formula into A1, what is the quickest way to copy it to the following 45,000 rows below it? Or in this case, the following rows that have data (which is about 45,000)?

Thanks in advance for your help,
magmike

 

[GS]

If I type a formula into A1, what is the quickest way to copy it to

the following 45,000 rows below it? Or in this case, the following
rows that have data (which is about 45,000)?

Thanks in advance for your help,
magmike

Select all target cells;
Type formula;
Ctrl+Enter.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[magmike]

On Tuesday, July 30, 2013 7:57:10 PM UTC-5, GS wrote: > > If I type a formula into A1, what is the quickest way to copy it to > the following 45,000 rows below it? Or in this case, the following > rows that have data (which is about 45,000)? > > Thanks in advance for your help, > magmike Select all target cells; Type formula; Ctrl+Enter. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.g

Thanks