Copy cell shortcut needed

  • Thread starter Thread starter magmike
  • Start date Start date
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
 
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
 
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
 
Back
Top