- Select the values in the row/rows or column/columns (must be a contiguous selection).
- Keep your mouse button pressed and also press the Shift key on your keyboard.
- Move your cursor to the edge of the selection until the move icon is visible.
- Move the selection to the row or column where you want this data to be shifted to. When you bring the selection to the edge of any row or column, you should see a vertical line (something that looks like roman numeral 1 or alphabet Capital I).
- Release the mouse button.
- Release the Shift key (remember to keep the Shift key pressed until the end).