Shift cells up or down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

A user brought me a spreadsheet in which the cells had gotten out of
alignment -- that is, the cells in one column had gotten shifted upward so
those cells were no longer in line with the other cells in their row.

I know when deleting cells you can shift the other cells upward or downward,
but how can you select a cell or cells and shift them up or down without
having to do a deletion?

Thanks,
 
Presuming the cols contain only data, you could just select the mis-aligned
col range, point anywhere at the range boundary (cursor will turn into a 4
arrow pointer), then just drag the range to move it up or down.
 
Thanks -- that worked,

Max said:
Presuming the cols contain only data, you could just select the mis-aligned
col range, point anywhere at the range boundary (cursor will turn into a 4
arrow pointer), then just drag the range to move it up or down.
Click to expand...
 
Back
Top