Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel Auto Fill Options

Is there a way to change the default on the Excel auto fill? When you grab
the bottom right of the cell and drag it down it defaults to fill the
formula. I want to change it so it defaults to fill "copy cells" instead of
the formula.
Someone please help!
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel Auto Fill Options

You can't change the default.

I like to rightclick on that autofill button and then when I let go, I can
choose how I want to fill.



astanfo wrote:

Is there a way to change the default on the Excel auto fill? When you grab
the bottom right of the cell and drag it down it defaults to fill the
formula. I want to change it so it defaults to fill "copy cells" instead of
the formula.
Someone please help!
Thanks


--

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
Auto Fill Options Dorothy Excel Discussion (Misc queries) 3 October 6th 08 03:31 AM
Where do I find 'auto fill options' in the Excel Menus? Willem Excel Discussion (Misc queries) 1 June 12th 06 10:50 AM
auto fill options vic Excel Discussion (Misc queries) 3 December 16th 05 11:19 PM
turn off auto fill options box Excel 2003 martock Excel Discussion (Misc queries) 2 October 13th 05 02:23 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 12:49 AM


All times are GMT +1. The time now is 06:50 AM.

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"