Why can't I drag a column in Excel in XP?

G

Guest

In previous versions of Windows, you could highlight a column, point at the
column heading (eg A/B/C etc), hold down the left hand mouse button and drag
the column wherever you wanted it - effectively doing a cut and insert.

Why can't you do this in XP? It will let you move the selection but it will
overwrite the cells that you move it to, rather than inserting.
 
J

JulieD

Hi Amber

can't answer the "why" part but i can give you an alternative .. use the
right mouse to drag instead and then you'll get 'shift right and copy' or
'shift right and move' options.

Cheers
JulieD
 
G

George Nicholson

XL 2000 and XP both behave the same for me: Left-dragging a column with
SHIFT pressed will "move" a column via cut/insert. Without Shift the "move"
will copy/overwrite.

Maybe you just forgot about holding down Shift?
 

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

Similar Threads

mouse locked in "drag mode" 3
Moving Columns Excel 2007 2
Why is only the last column available in the Excel worksheet? 2
Crosshair is missing when I try to click & drag a cell 2
cannot move a column in my spreadsheet 3
Auto Fill formula when inserting a new line 4
Move column to in-between existing columns 3
HIGHLIGHTING A COLUMN OF DATA 3

Top