ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   fill handle question (https://www.excelbanter.com/excel-discussion-misc-queries/62475-fill-handle-question.html)

Arsenio Oloroso

fill handle question
 
I've noticed that if you double click the plus sign on the fill handle,
Excel will automatically fill out a series in an entire column--so that you
don't have to drag. How do you get it to do that for an entire row? Excel
Help doesn't provide any guidance on this.

Thanks for any advice.

OLY



Bob Umlas

fill handle question
 
Something I've requested for years and years. Simply not an implemented
feature.
Bob Umlas

"Arsenio Oloroso" wrote in message
...
I've noticed that if you double click the plus sign on the fill handle,
Excel will automatically fill out a series in an entire column--so that

you
don't have to drag. How do you get it to do that for an entire row?

Excel
Help doesn't provide any guidance on this.

Thanks for any advice.

OLY





Arsenio Oloroso

fill handle question
 
Incredible...and illogical! Anyone circulating a petition?

"Bob Umlas" wrote in message
...
Something I've requested for years and years. Simply not an implemented
feature.
Bob Umlas

"Arsenio Oloroso" wrote in message
...
I've noticed that if you double click the plus sign on the fill handle,
Excel will automatically fill out a series in an entire column--so that

you
don't have to drag. How do you get it to do that for an entire row?

Excel
Help doesn't provide any guidance on this.

Thanks for any advice.

OLY







Jacob_F_Roecker

fill handle question
 
I didn't even know this feature even existed until you guys started talking
about this. Thanks for bringing it up.

Since I just discovered it I'm not too disappointed that it doesn't do rows
yet. Maybe after I get used to it for a bit.

Can you make a 'plugin' for it using VBA?



"Arsenio Oloroso" wrote:

Incredible...and illogical! Anyone circulating a petition?

"Bob Umlas" wrote in message
...
Something I've requested for years and years. Simply not an implemented
feature.
Bob Umlas

"Arsenio Oloroso" wrote in message
...
I've noticed that if you double click the plus sign on the fill handle,
Excel will automatically fill out a series in an entire column--so that

you
don't have to drag. How do you get it to do that for an entire row?

Excel
Help doesn't provide any guidance on this.

Thanks for any advice.

OLY








Dave Peterson

fill handle question
 
If you record a macro when you drag across, you'll see the code.

Jacob_F_Roecker wrote:

I didn't even know this feature even existed until you guys started talking
about this. Thanks for bringing it up.

Since I just discovered it I'm not too disappointed that it doesn't do rows
yet. Maybe after I get used to it for a bit.

Can you make a 'plugin' for it using VBA?



"Arsenio Oloroso" wrote:

Incredible...and illogical! Anyone circulating a petition?

"Bob Umlas" wrote in message
...
Something I've requested for years and years. Simply not an implemented
feature.
Bob Umlas

"Arsenio Oloroso" wrote in message
...
I've noticed that if you double click the plus sign on the fill handle,
Excel will automatically fill out a series in an entire column--so that
you
don't have to drag. How do you get it to do that for an entire row?
Excel
Help doesn't provide any guidance on this.

Thanks for any advice.

OLY








--

Dave Peterson


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com