Deleting Cell then Shift Down?

H

hoffman3

I'm trying to move a column down that has over 10,000 rows so it won'
let me paste special: values for some reason. So i was wondering i
there is a way to delete the bottom cell then shift all cells down, b/
there is a shift left and shift up but no shift down or right, an
solutions?? Thanks
Eric Hoffma
 
J

jeff

Hi,

I think this will work for you. Copy a blank cell from
anywhere. Go to the cell where you want the column moved
down one. Right click and select 'insert copied cells',
select 'shift down'.

jeff
 
D

Dave Peterson

Or just rightclick on a cell|Insert|shift down?
Hi,

I think this will work for you. Copy a blank cell from
anywhere. Go to the cell where you want the column moved
down one. Right click and select 'insert copied cells',
select 'shift down'.

jeff
Click to expand...
 
Top