How to move Columns in Microsoft Excel

How to move Columns in Microsoft Excel

In this article, I am going to share with you how you can move or change the position of Columns from one position to other. So, follow below some simple and easy steps to know how to use this function of Microsoft Excel.

Move Columns in Microsoft Excel

Step 1: The very first step is to open your saved data spreadsheet or create dummy data to perform this function in MS Excel.

Step 2: In the second step, select the range of your data, for example, in the below picture I have selected the State and I am going to move this in the place of Sales.

Move Columns in Microsoft Excel
Move Columns in Microsoft Excel

Step 3: Now, on your keyboard, hold the shift key and also hold your left button of the mouse and move your mouse towards Quarter and release the left button of the mouse.

Step 4: You have successfully moved your column from State to Quarter.

Move Columns in Microsoft Excel
Move Columns in Microsoft Excel

Above I have shared the shortcut method, which can be done by just using your keyboard and mouse now, let’s see

Read More:

how you can do this with the old style. Follow below, steps.

Step 1: Select the column, as I have selected Quarter in the above first image.

Step 2: Right-click the mouse and click on the Cut option as shown in below image.

move Columns in Microsoft Excel
move Columns in Microsoft Excel

Step 3: Select the new place where you want to place this, as I have selected the State column. And click the Insert Cut Cell.

move Columns in Microsoft Excel
move Columns in Excel

Step 4: Now, see the result.

move Columns in Microsoft Excel
move Columns in Microsoft Excel

Thank you.

Leave a Reply

Your email address will not be published. Required fields are marked *