Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell 2007 moving data in cell
my excell no longer allows me to left click on a cell or row, with or without
data, and move elsewhere on a spread sheet. mouse is ok. Is there a command i can use to get this facility back. Its stopping my work and driving me nuts. thanks -- greenliam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell 2007 moving data in cell
Tools Options Edit tab
Allow cell drag and drop should be checked. "greenliam" wrote in message ... my excell no longer allows me to left click on a cell or row, with or without data, and move elsewhere on a spread sheet. mouse is ok. Is there a command i can use to get this facility back. Its stopping my work and driving me nuts. thanks -- greenliam |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell 2007 moving data in cell
If I understand correctly... Click Office Button, Excel Options, Advanced and
make sure there is a check beside Enable fill handle and cell drag-and-drop. If this doesn't fix your problem, please give a little more detail about what you mean by left click a cell or row to move it. "greenliam" wrote: my excell no longer allows me to left click on a cell or row, with or without data, and move elsewhere on a spread sheet. mouse is ok. Is there a command i can use to get this facility back. Its stopping my work and driving me nuts. thanks -- greenliam |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell 2007 moving data in cell
All done, thanks.
-- greenliam "BoniM" wrote: If I understand correctly... Click Office Button, Excel Options, Advanced and make sure there is a check beside Enable fill handle and cell drag-and-drop. If this doesn't fix your problem, please give a little more detail about what you mean by left click a cell or row to move it. "greenliam" wrote: my excell no longer allows me to left click on a cell or row, with or without data, and move elsewhere on a spread sheet. mouse is ok. Is there a command i can use to get this facility back. Its stopping my work and driving me nuts. thanks -- greenliam |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell 2007 moving data in cell
perfect, thanks a lot.
-- greenliam "Stephen" wrote: Tools Options Edit tab Allow cell drag and drop should be checked. "greenliam" wrote in message ... my excell no longer allows me to left click on a cell or row, with or without data, and move elsewhere on a spread sheet. mouse is ok. Is there a command i can use to get this facility back. Its stopping my work and driving me nuts. thanks -- greenliam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems Coping and moving sheets between files Excell 2007 | Excel Discussion (Misc queries) | |||
Moving Data Points on Scatter Chart in 2007 | Charts and Charting in Excel | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
How can I highlight a cell or row or column in excell 2007? | New Users to Excel | |||
Force user to enter data in cell before moving to next cell | New Users to Excel |