How move up item up, shift rest downs?

K

kevs

How move a cell up ( in a columns), and shift whatever it's replacing
downwards.

I've tried holding down both shift and option, (with hand), but it seems to
replace .

For example, I have column full of stuff. I want to move cell A 13 to A1,
and I want whatever was in A1 to go to A2, and hole now in A 13 will be
closed naturally.

OS 10.3.5
Office 2004
 
K

kevs

Just did some testing.
That seems to work IF you are moving an entire row.

But it seems if you workbook is just one column only, and you do this,
instead of moving the the cells down, Excel moves the cell to the right.

Any ideas? Thanks.







hold down shift key when you drag the cell, works for me.

w.
Click to expand...

OS 10.3.5
Office 2004
 
B

Bernard Rey

kevs:

"Willis Eschenbach":
kevs wrote :
Just did some testing.
That seems to work IF you are moving an entire row.

But it seems if your workbook is just one column only, and you do this,
instead of moving the the cells down, Excel moves the cell to the right.
Click to expand...

Kevs, can you describe it more precisely?

I did exactly what you were advised following your example and it works
exactly as you seem to expect it :

I filled a column with numbers in column A.
I selected the columns from col B to the end and did Hide them.
Now I have a "one column only" worksheet, I select cell A13;
Holding the Shift key, I grab the cell from its border "with hand";
I drag it up to cell A1 (in fact I can see a grayed line above cell A1);
When I drop it on cell A1, everything is pushed down one cell and the
"hole"; in A13 gets filled, the cells A14 and lower remain untouched.

From what point do things come differently in your case?
 
N

Neill Massello

kevs said:
How move a cell up ( in a columns), and shift whatever it's replacing
downwards.

I've tried holding down both shift and option, (with hand), but it seems to
replace .

For example, I have column full of stuff. I want to move cell A 13 to A1,
and I want whatever was in A1 to go to A2, and hole now in A 13 will be
closed naturally.
Click to expand...

To get a menu of move and copy options, hold down the Control key while
dragging a cell, row, column, or range.
 
K

kevs

Bernard:
Amazing! I just test this out too. Yes it works, IF, you grab from the
middle or the right side of cell, and then you see the light grey bar go all
way across horizontally.
BUT, if you grab from the extreme left as I was, and you just see a small
light grey symbol (looks like the greater than or less than symbol)
And you release at A1, it pushes what was at A1 to B1, that what was
happening.

But now it's ok, I just grab from middle or right side. Hope that was clear,
hard to explain without screen shots.


kevs:


"Willis Eschenbach":

kevs wrote :


Kevs, can you describe it more precisely?

I did exactly what you were advised following your example and it works
exactly as you seem to expect it :

I filled a column with numbers in column A.
I selected the columns from col B to the end and did Hide them.
Now I have a "one column only" worksheet, I select cell A13;
Holding the Shift key, I grab the cell from its border "with hand";
I drag it up to cell A1 (in fact I can see a grayed line above cell A1);
When I drop it on cell A1, everything is pushed down one cell and the
"hole"; in A13 gets filled, the cells A14 and lower remain untouched.

From what point do things come differently in your case?
Click to expand...

OS 10.3.5
Office 2004
 
Top