Deleting Cell then Shift Down?

[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

 

[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

 

[hoffman3]

Thanks for the help, much appreciated
Eric Hoffma

 

[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