Mouse pointer problem

[shajueasow]

All on a sudden my mouse pointer in excel is not working properly. I cannot use my mouse to drag and fill, or to adjust the page break lines in the Page Break View mode. It always is in the shape of the white cross with black border and never changes it shape when pointed at the lower right edge of cells too. Now.......what to do in order to get out of this problem.
TIA

 

[shajueasow]

bump....please help

 

[shajueasow]

It was noticed that any selected cell NOW has a full border for it....whereas actually it is a border with a "dot" on the lower right hand corner earlier.
Any guesses....?

 

[RoryA]

Which version of Excel. I suspect cell drag and drop had been turned off but the details of how to reset it vary.

 

[shajueasow]

Thanks A Lot. Your diagnosis was perfect. That itself was the problem.
I use Excel 2003 with Windows XP.....(if that will provide more ways to get out of this problem).
Thanks A Lot.

 

[RoryA]

The setting is Tools-Options, Edit tab, check the 'Allow cell drag and drop' option.

 

[zatmum]

My mouse pointer in excel 2007 is not working properly. I cannot use my mouse to drag and fill, or to adjust the page break lines in the Page Break View mode. It always is in the shape of the white cross with black border and never changes it shape when pointed at the lower right edge of cells too. Now.......what to do in order to get out of this problem.

 

[RoryA]

In 2007, it's in Excel Options (click the Office button) in the Advanced section, third option is: 'Enable fill handle and cell rag-and-drop'. Check that.

 

[zatmum]

Thank you very much. This very useful and i have sorted out my problem. One another problem, i am also facing in excel 2007 that is i cannot edit cell contains directly by double clicking at particular cell by mouse, which i want to edit. Please help me for this problem.
Thanks again.

 

[RoryA]

That's the allow edit in cell option below the other one.