Move rows and columns

You can move a row or column by dragging-and-dropping it to a new location. Or, you can follow these steps:

  1. Select the row(s) or column(s) you'd like to move.
  2. Go to the Edit menu.
  3. Selecting from the following options:
    • Move row up
    • Move row down
    • Move column right
    • Move column left
  4. Your row(s) or column(s) will move to the selected location.

Here's how to move a selection of cells:

  1. Select the cell(s) you'd like to copy and move.
  2. Point your cursor to the top of the selected cell(s). The pointer turns into a hand.

    move selection of cells

  3. Drag the data to its new location, and release the mouse to drop it there.