If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
doubleclicking autofill crosshairs doesn't work in Excel 2007
In past versions of Excel, if I needed to copy a sequence or formula down all
the rows of a large table, I could enter the first row, select that cell, and double-click the crosshairs at the lower right corner of the cell. Excel would then auto-fill the sequence all the way down the table. I have updated the Excel 2007 on two different machines, and now when I double-click, nothing happens. Yet I have spend a few hours searching the internet and everything I read assumes that it works in 2007 - I can't find anything about what to do if it doesn't work. Anybody have any ideas how I can get it working again? |
#2
|
|||
|
|||
doubleclicking autofill crosshairs doesn't work in Excel 2007
ButtonExcel OptionsAdvancedEditing Options.
"Enable fill handle and cell drag and drop" Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 13:40:01 -0700, KDaddy wrote: In past versions of Excel, if I needed to copy a sequence or formula down all the rows of a large table, I could enter the first row, select that cell, and double-click the crosshairs at the lower right corner of the cell. Excel would then auto-fill the sequence all the way down the table. I have updated the Excel 2007 on two different machines, and now when I double-click, nothing happens. Yet I have spend a few hours searching the internet and everything I read assumes that it works in 2007 - I can't find anything about what to do if it doesn't work. Anybody have any ideas how I can get it working again? |
Thread Tools | |
Display Modes | |
|
|