2007 Excel Auto Fill - Lower right corner

N

needhelp

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?
 
P

Peo Sjoblom

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
 
N

needhelp

The advanced functions are checked and it still isn't working. Hence, my
frustration with this so called "better and friendlier" version.
 
N

needhelp

Okay, nevermind. I work with Essbase for a significant amount of the day and
found that one of my options for double clicking had been selected. Swell....

Thanks for responding Peo.
 
P

Peo Sjoblom

Excel 2007 is neither better nor friendlier. Although I have 2007 I went
back and installed 2003 as well and I am using that version 99.9% of the
time.

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
Embedded video only showing a corner 0
Text in note pane of "normal" display suddenly much larger 1
Edit / Enter sign in lower left hand corner of spreadsheet 6
Auto Fill formula when inserting a new line 4
Change Default Auto-Fill-In month 5
Excel Auto Fill Options 1
Auto fill a column 0

Top