Cursor not changing on hovering upon cell outline


A

Abhay S. Kushwaha

Hi:

I have Office 2007 installed on Vista Business
on my HP laptop and am running into a peculiar
problem.

Normally when you select a cell, Excel shows an
outline with an auto-fill handle at the bottom
right corner and hovering on the cell outline
changes the cursor so that you can do operations
with the cell like dragging it to a new location.

In my laptop, a cell outline is a solid box and
neither displays the handle at the bottom right
or changes the cursor when I hover on the cell
outline.

Searching the Net hasn't turned up anything
useful for me yet.

Does anybody know what's going on and how to
make Excel behave 'normal'?

TIA.

[a]
 
Ad

Advertisements

G

Gord Dibben

In 2003 version I would go to Tools>Options>Edit.

Checkmark "allow cell drag and drop".

Where you go in 2007 for the option is not known to me but probably the
solution to your problem.


Gord Dibben MS Excel MVP
 
A

Abhay S. Kushwaha

Awesome! It was in Excel Options -> Advanced, called "Enable fill handle and
cell drag-and-drop". Enabled it and voila! Thank you so much! It's taken a
*huge* overhead away.

[a]

Gord Dibben said:
In 2003 version I would go to Tools>Options>Edit.

Checkmark "allow cell drag and drop".

Where you go in 2007 for the option is not known to me but probably the
solution to your problem.


Gord Dibben MS Excel MVP

Hi:

I have Office 2007 installed on Vista Business
on my HP laptop and am running into a peculiar
problem.

Normally when you select a cell, Excel shows an
outline with an auto-fill handle at the bottom
right corner and hovering on the cell outline
changes the cursor so that you can do operations
with the cell like dragging it to a new location.

In my laptop, a cell outline is a solid box and
neither displays the handle at the bottom right
or changes the cursor when I hover on the cell
outline.

Searching the Net hasn't turned up anything
useful for me yet.

Does anybody know what's going on and how to
make Excel behave 'normal'?

TIA.

[a]
 
N

Nirmal Kumar

Thanks It also solved my problem in excel
Hi:

I have Office 2007 installed on Vista Business
on my HP laptop and am running into a peculiar
problem.

Normally when you select a cell, Excel shows an
outline with an auto-fill handle at the bottom
right corner and hovering on the cell outline
changes the cursor so that you can do operations
with the cell like dragging it to a new location.

In my laptop, a cell outline is a solid box and
neither displays the handle at the bottom right
or changes the cursor when I hover on the cell
outline.

Searching the Net hasn't turned up anything
useful for me yet.

Does anybody know what's going on and how to
make Excel behave 'normal'?

TIA.

[a]
On Monday, September 22, 2008 3:51 PM Gord Dibben wrote:
In 2003 version I would go to Tools>Options>Edit.

Checkmark "allow cell drag and drop".

Where you go in 2007 for the option is not known to me but probably the
solution to your problem.


Gord Dibben MS Excel MVP
On Monday, September 22, 2008 4:01 PM Abhay S. Kushwaha wrote:
Awesome! It was in Excel Options -> Advanced, called "Enable fill handle and
cell drag-and-drop". Enabled it and voila! Thank you so much! It's taken a
*huge* overhead away.

[a]

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]
 
Ad

Advertisements

Joined
Aug 6, 2013
Messages
1
Reaction score
0
Awesome! It was in Excel Options -> Advanced, called "Enable fill handle and
cell drag-and-drop". Enabled it and voila! Thank you so much! It's taken a
*huge* overhead away.

[a]

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]
> In 2003 version I would go to Tools>Options>Edit.
>
> Checkmark "allow cell drag and drop".
>
> Where you go in 2007 for the option is not known to me but probably the
> solution to your problem.
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 22 Sep 2008 10:27:18 +0530, "Abhay S. Kushwaha"
> <[email protected]> wrote:
>
>>Hi:
>>
>>I have Office 2007 installed on Vista Business
>>on my HP laptop and am running into a peculiar
>>problem.
>>
>>Normally when you select a cell, Excel shows an
>>outline with an auto-fill handle at the bottom
>>right corner and hovering on the cell outline
>>changes the cursor so that you can do operations
>>with the cell like dragging it to a new location.
>>
>>In my laptop, a cell outline is a solid box and
>>neither displays the handle at the bottom right
>>or changes the cursor when I hover on the cell
>>outline.
>>
>>Searching the Net hasn't turned up anything
>>useful for me yet.
>>
>>Does anybody know what's going on and how to
>>make Excel behave 'normal'?
>>
>>TIA.
>>
>>[a]
>>

>
>
Thanks this helped for me too. Not sure why it suddenly changed.

I am using Professional Plus 2010
 

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

Top