How To Move Columns In Excel

To move columns in Excel, you can select the column you want to move, right-click, choose “cut”, then right-click on the target location, and choose “insert cut cells” or “insert copied cells” to paste the column.

Excel is a powerful tool that many of us use on a daily basis for managing and organizing data. One common task we often encounter is reordering columns within our Excel spreadsheets. This seemingly simple task can sometimes be a bit tricky for beginners or even seasoned Excel users. In this blog post, we will walk through the steps on how to move columns in Excel, providing you with the knowledge and techniques to efficiently rearrange your data and optimize your workflow. Whether you need to realign columns for improved readability or reorganize data for better analysis, this guide will equip you with the necessary skills to confidently manipulate columns in Excel. Let’s dive in!

How To Move Columns In Excel: Step-by-Step


Step 1: Open Excel,

To initiate this process, find and open Microsoft Excel on your computer. Then, access the relevant spreadsheet that contains the columns you want to relocate.

Next Step

Step 2: Select the column,

To move a specific column, locate and click on the alphabetic header of that column to select it. This will allow you to easily rearrange and reposition the entire column to your desired location.

Next Step

Step 3: Cut or Copy the Column,

To cut or copy a column, right-click and choose “Cut” or “Copy” from the drop-down menu. Cutting removes the column while copying keeps the original.

Next Step

Step 4: Choose the new location for the column,

Decide where you want to relocate the selected column by clicking on the header of the column where you would like the relocated column to be displayed. This action allows you to easily choose a new position for the selected column within your data set.

Next Step

Step 5: Insert Cut or copied Column,

To move or copy the selected column to a new location, right-click on it, then choose “Insert Cut Cells” (if you cut the column earlier) or “Insert Copied Cells” (if you copied the column earlier) from the drop-down menu.

Next Step

Step 6: Save changes,

Once you are content with the revised column arrangement, save your changes by clicking on the ‘File’ menu at the top left corner of the screen and selecting ‘Save’.


Moving columns in Excel is a simple yet powerful feature that allows you to organize your data and improve overall workflow. By understanding the different methods and techniques discussed in this blog post, you can easily rearrange columns to suit your specific needs without disrupting the integrity of your data. Whether you prefer using drag and drop, cut and paste, or the built-in Excel features, such as the “Insert” and “Insert Cut Cells” functions, incorporating these techniques into your Excel workflow will undoubtedly make your data manipulation tasks more efficient and productive. So go ahead and start experimenting with moving columns in Excel, and take full control of your data organization today.

Table of Contents