Shift cells up or down
 

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,

Shift cells up or down
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rosemary" wrote:
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,

Shift cells up or down
 

Thanks -- that worked,

"Max" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rosemary" wrote:
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,

Shift cells up or down
 

Glad to hear that !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rosemary" wrote:
Thanks -- that worked,