#1   Report Post  
Posted to microsoft.public.excel.misc
Arsenio Oloroso
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas
 
Posts: n/a
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.misc
Arsenio Oloroso
 
Posts: n/a
Default 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






  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob_F_Roecker
 
Posts: n/a
Default 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







  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trend using the same formula as the fill handle does Roy G. Biv Excel Worksheet Functions 0 October 18th 05 08:31 PM
Fill handle formula neeraj Excel Worksheet Functions 9 September 13th 05 01:46 AM
Fill Handle Across Columns SenojNW Excel Discussion (Misc queries) 4 August 8th 05 07:23 PM
fill handle rexmann Excel Discussion (Misc queries) 2 June 9th 05 03:02 PM
3-d reference not adjusting when using Fill Handle to copy down gall Excel Worksheet Functions 3 November 24th 04 06:42 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"