Quickly re-arrange columns in Excel

    • iTG Technologies |
    • 0 step |
    • 35 seconds
      To follow this guide please download our sample sheet found here [https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ESFTSI6a1WhLj89T1oR4ZeABoOjadCLhCtKplqO8eyDCxA?e=uJ1pKs](https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ESFTSI6a1WhLj89T1oR4ZeABoOjadCLhCtKplqO8eyDCxA?e=uJ1pKs)
      Oh no! Our table is not correct! We accidentally mixed up our columns so C is at the start instead of A. Lets re-arrange these so they are correct!
      Click on the column you want to move by pressing in the top row - in our example this is column 'C'.
      Now column 'C' is fully selected with data that needs to be moved to column A.
      {{Press and hold}} {{SHIFT}} and hover the mouse over the edge of the selection and the 'move mouse' pointer will appear.
      The move mouse pointer looks like this
      [[With SHIFT still held]] drag column 'A' to column A in excel then release the mouse and stop pressing shift on the keyboard. If this has been done correctly the column will have been moved.
      Tip! Remember that holding shift means 'move'
      Repeat these steps for column C moving it from column B to column C.
      Your sample data should now be rearranged A through to D
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe