Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift cells up or down
Glad to hear that !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rosemary" wrote: Thanks -- that worked, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
Delete - Shift Cells UP problem | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
I need to shift cells down only to a point w/o disturbing the bot. | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |