Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel 2007: mouse cant find cell handle to drag/move

I am using Office 2007 sp1, and I find myself not being able to move/drag a
cell around inside Excel. Normally I would enter some data in a cell, then
find the handle on the lower right corner, click on it, watch my pointer turn
into a plus sign, and be able to drag it down and watch it populate
sequential cells. Now I dont get a plus sign pointer, nor even a move arrows
pointer when I click on any cell wall.
What is causing this?
Thanks in advance!!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Excel 2007: mouse cant find cell handle to drag/move

It sounds like the "Enable fill handle and cell drag-and-drop" option may have been turned off in Excel. Here's how to turn it back on:
  1. Click on the Office button (the round button in the top left corner of the Excel window).
  2. Click on the Excel Options button at the bottom of the menu.
  3. In the Excel Options window, click on the Advanced tab.
  4. Scroll down to the "Editing options" section.
  5. Make sure the "Enable fill handle and cell drag-and-drop" option is checked.
  6. Click OK to save the changes.

If this option was already checked, it's possible that there is a problem with your Excel installation. You may want to try repairing or reinstalling Excel to see if that fixes the issue.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Excel 2007: mouse cant find cell handle to drag/move

Office Button, Excel Options, Advanced, Editing options, click Enable fill
handle and cell drang-and-drop

Tyro

"Carl Henthorn" wrote in message
...
I am using Office 2007 sp1, and I find myself not being able to move/drag a
cell around inside Excel. Normally I would enter some data in a cell, then
find the handle on the lower right corner, click on it, watch my pointer
turn
into a plus sign, and be able to drag it down and watch it populate
sequential cells. Now I dont get a plus sign pointer, nor even a move
arrows
pointer when I click on any cell wall.
What is causing this?
Thanks in advance!!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel 2007: mouse cant find cell handle to drag/move

to enable drag:
1)Click Office button.
2)Click Excel options.
3)Click Advanced Tab.
4)Mark "enable fill hand and cell drag and drop".

On Monday, April 14, 2008 12:53 PM CarlHenthor wrote:


I am using Office 2007 sp1, and I find myself not being able to move/drag a
cell around inside Excel. Normally I would enter some data in a cell, then
find the handle on the lower right corner, click on it, watch my pointer turn
into a plus sign, and be able to drag it down and watch it populate
sequential cells. Now I dont get a plus sign pointer, nor even a move arrows
pointer when I click on any cell wall.
What is causing this?
Thanks in advance!!



On Monday, April 14, 2008 1:13 PM Tyro wrote:


Office Button, Excel Options, Advanced, Editing options, click Enable fill
handle and cell drang-and-drop

Tyro



On Thursday, August 06, 2009 3:21 AM Amit Ghai wrote:


You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel 2007: mouse cant find cell handle to drag/move

to enable drag:
1)Click Office button.
2)Click Excel options.
3)Click Advanced Tab.
4)Mark "enable fill hand and cell drag and drop".

On Monday, April 14, 2008 12:53 PM CarlHenthor wrote:


I am using Office 2007 sp1, and I find myself not being able to move/drag a
cell around inside Excel. Normally I would enter some data in a cell, then
find the handle on the lower right corner, click on it, watch my pointer turn
into a plus sign, and be able to drag it down and watch it populate
sequential cells. Now I dont get a plus sign pointer, nor even a move arrows
pointer when I click on any cell wall.
What is causing this?
Thanks in advance!!



On Monday, April 14, 2008 1:13 PM Tyro wrote:


Office Button, Excel Options, Advanced, Editing options, click Enable fill
handle and cell drang-and-drop

Tyro



On Thursday, August 06, 2009 3:21 AM Amit Ghai wrote:


You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.



On Friday, August 12, 2011 6:13 AM sagar aggarwal wrote:


to enable drag:

1)Click Office button.

2)Click Excel options.

3)Click Advanced Tab.

4)Mark "enable fill hand and cell drag and drop".




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill Handle doesn't display - Allow cell drag and Drop option is c Joey Excel Discussion (Misc queries) 1 April 9th 08 09:29 PM
Fill handle turned into a move handle Northwoods Excel Discussion (Misc queries) 1 March 2nd 07 04:40 PM
if you drag the fill handle will it decrement the series ajbanana Excel Discussion (Misc queries) 3 January 31st 07 09:04 AM
if you drag the fill handle will it decrement the series ajbanana Excel Discussion (Misc queries) 3 January 31st 07 08:33 AM
Highlight 1 cell in Excel & move mouse-stays highlighted - stop? Patriot Excel Discussion (Misc queries) 2 January 16th 06 11:49 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"