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
- Oct 22 Sun 2006 20:09
fill handle question
close
全站熱搜
留言列表
發表留言