close

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
Something I've requested for years and years. Simply not an implemented
feature.
Bob Umlas

quot;Arsenio Olorosoquot; gt; wrote in message
...
gt; I've noticed that if you double click the plus sign on the fill handle,
gt; Excel will automatically fill out a series in an entire column--so that
you
gt; don't have to drag. How do you get it to do that for an entire row?
Excel
gt; Help doesn't provide any guidance on this.
gt;
gt; Thanks for any advice.
gt;
gt; OLY
gt;
gt;
Incredible...and illogical! Anyone circulating a petition?

quot;Bob Umlasquot; gt; wrote in message
...
gt; Something I've requested for years and years. Simply not an implemented
gt; feature.
gt; Bob Umlas
gt;
gt; quot;Arsenio Olorosoquot; gt; wrote in message
gt; ...
gt;gt; I've noticed that if you double click the plus sign on the fill handle,
gt;gt; Excel will automatically fill out a series in an entire column--so that
gt; you
gt;gt; don't have to drag. How do you get it to do that for an entire row?
gt; Excel
gt;gt; Help doesn't provide any guidance on this.
gt;gt;
gt;gt; Thanks for any advice.
gt;gt;
gt;gt; OLY
gt;gt;
gt;gt;
gt;
gt;
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?
quot;Arsenio Olorosoquot; wrote:

gt; Incredible...and illogical! Anyone circulating a petition?
gt;
gt; quot;Bob Umlasquot; gt; wrote in message
gt; ...
gt; gt; Something I've requested for years and years. Simply not an implemented
gt; gt; feature.
gt; gt; Bob Umlas
gt; gt;
gt; gt; quot;Arsenio Olorosoquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; I've noticed that if you double click the plus sign on the fill handle,
gt; gt;gt; Excel will automatically fill out a series in an entire column--so that
gt; gt; you
gt; gt;gt; don't have to drag. How do you get it to do that for an entire row?
gt; gt; Excel
gt; gt;gt; Help doesn't provide any guidance on this.
gt; gt;gt;
gt; gt;gt; Thanks for any advice.
gt; gt;gt;
gt; gt;gt; OLY
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

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

Jacob_F_Roecker wrote:
gt;
gt; I didn't even know this feature even existed until you guys started talking
gt; about this. Thanks for bringing it up.
gt;
gt; Since I just discovered it I'm not too disappointed that it doesn't do rows
gt; yet. Maybe after I get used to it for a bit.
gt;
gt; Can you make a 'plugin' for it using VBA?
gt;
gt;
gt;
gt; quot;Arsenio Olorosoquot; wrote:
gt;
gt; gt; Incredible...and illogical! Anyone circulating a petition?
gt; gt;
gt; gt; quot;Bob Umlasquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Something I've requested for years and years. Simply not an implemented
gt; gt; gt; feature.
gt; gt; gt; Bob Umlas
gt; gt; gt;
gt; gt; gt; quot;Arsenio Olorosoquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt;gt; I've noticed that if you double click the plus sign on the fill handle,
gt; gt; gt;gt; Excel will automatically fill out a series in an entire column--so that
gt; gt; gt; you
gt; gt; gt;gt; don't have to drag. How do you get it to do that for an entire row?
gt; gt; gt; Excel
gt; gt; gt;gt; Help doesn't provide any guidance on this.
gt; gt; gt;gt;
gt; gt; gt;gt; Thanks for any advice.
gt; gt; gt;gt;
gt; gt; gt;gt; OLY
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()