|  | Faster way to fill down, when blanks in rows exist | | |
| | | Mike C |  |
|  Posted: Tue Sep 02, 2008 9:09 pm Post subject: Faster way to fill down, when blanks in rows exist |  |
Is there possibly a faster way to fill down (e.g., drag a formula from
row 1 to fill all the way through row 33,000) , when there are blanks
in the rows throughout the data.
It takes forever to drag it down to the bottom of row 33,000.
Is there a better way to accomplish this?
Thanks for any suggestions. |
| |
| | | Rick Rothstein | |
| | Posted: Tue Sep 02, 2008 9:09 pm Post subject: Re: Faster way to fill down, when blanks in rows exist | |
You are dragging your formula down *over your data* thus replacing it?
--
Rick (MVP - Excel)
"Mike C" <js2k111@yahoo.com> wrote in message
news:fe37ae9f-44d4-48bd-899e-56f7ae6c638b@m36g2000hse.googlegroups.com...
| Quote: | Is there possibly a faster way to fill down (e.g., drag a formula from
row 1 to fill all the way through row 33,000) , when there are blanks
in the rows throughout the data.
It takes forever to drag it down to the bottom of row 33,000.
Is there a better way to accomplish this?
Thanks for any suggestions. |
|
| |
| | | Gord Dibben | |
| | Posted: Tue Sep 02, 2008 9:09 pm Post subject: Re: Faster way to fill down, when blanks in rows exist | |
Enter your formula in a cell, say B1
In namebox enter B1:B33000 and ENTER
CTRL + d to fill down
Gord Dibben MS Excel MVP
On Tue, 2 Sep 2008 14:09:14 -0700 (PDT), Mike C <js2k111@yahoo.com> wrote:
| Quote: | Is there possibly a faster way to fill down (e.g., drag a formula from
row 1 to fill all the way through row 33,000) , when there are blanks
in the rows throughout the data.
It takes forever to drag it down to the bottom of row 33,000.
Is there a better way to accomplish this?
Thanks for any suggestions. |
|
| |
|
|
