Select the first cell of the range to be shifted down>Right
click>Insert>Shift Cells down
If this post helps click Yes
> My spread sheet is a parts inventory for Ag Equioment parts. Somehow I have
> shifted my description column up 1 cell and now the description of a
> particular part doesn't line up with its part # or prices. How do I shift
> that column cells down 1 row?