ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   EXCEL - I can not drag a cell with text to another cell, (https://www.excelbanter.com/excel-discussion-misc-queries/205706-excel-i-can-not-drag-cell-text-another-cell.html)

Skip56

EXCEL - I can not drag a cell with text to another cell,
 
Just upgraded to Excel 2007. I have a cell with text only. I can not select
and move it to another cell. The cursor changes to a cross hair, then as I
move it the cell ID is displayed beside the cursor which changes to an arrow,
but when I release it, nothing happens. I also can not cut or copy - then
paste to another cell. I can pull the text to the other location with
up/down then left/right drags. I have check the options and drag and drop is
enabled.

Skip56

EXCEL - I can not drag a cell with text to another cell,
 


"Skip56" wrote:

Just upgraded to Excel 2007. I have a cell with text only.


Actually, cells with numbers can not be grabbed and moved either. Neither
as a cell or range of cells.

Sheeloo[_2_]

EXCEL - I can not drag a cell with text to another cell,
 
How are you dragging? It does not depend on whether the cell has numbers or
text?

Does this happen on all worksheets/workbooks? If it happens in only one then
it might be protected.

"Skip56" wrote:



"Skip56" wrote:

Just upgraded to Excel 2007. I have a cell with text only.


Actually, cells with numbers can not be grabbed and moved either. Neither
as a cell or range of cells.



All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com