In Excel, you may want to move an entire column or row to another location. Rather than inserting a new column or row and using the copy/cut and paste method; use the following quick alternative.

  • Select the row or column by clicking on its header, hold down the Shift key, and then hover your cursor over the row or column border until it becomes a fourheaded arrow. Click and drag up or down to move the row or column and drop. You’ll see a placeholder to help guide your movements. This method will not replace a column or row with information. 
  • If you are moving a column or row to another location and there are empty columns and rows, simply hover your cursor over the row or column border until it becomes a fourheaded arrow and drag and drop.
Advertisements