Copy cell shortcut needed

M

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
 
G

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
Click to expand...

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
 
M

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
 
Top