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


All times are GMT +1. The time now is 05:31 AM.

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

About Us

"It's about Microsoft Excel"