View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 2007 Excel Auto Fill - Lower right corner

Click the office button top left and select excel options, then click
advanced in the left pane and make sure "enable fill handle and cell drag
and drop" is checked.


--


Regards,


Peo Sjoblom

"needhelp" wrote in message
...
Okay, I'm ready to chuck this new version of Excel out the window. All
I'm
trying to do is double click on the lower right hand corner (when it turns
into a cross) to fill the cells below with the formula in the current
cell.
In the past it would auto fill to the end of data to the left. What's
going
on and how do I restore this functionality?