How to move columns in Microsoft Excel

In Excel, information is entered into cells and those cells are further organized into rows and columns. However, even probably the most well-planned spreadsheets want to be reorganized every now and then. Whether you’re organizing by data kind or searching for developments, it’s important to know how to move columns in Excel.

As with many Excel features, there’s multiple means to get the job finished. Here are a couple of fundamental methods:

How to move columns in Excel:

1. The first approach that you'll be able to take a look at is an easy click and drag. You is also pondering that that is the most obvious answer, but it surely’s just a little trickier than it sounds. To start, click on at the column that you want to make a selection.

2. Next, move your cursor to the brink of one of the crucial cells till you spot a four-sided arrow appear. Avoid making an attempt to make a choice a column on the heading as a result of it could actually take on extra shapes and homes.

3. Now hang the Shift key and drag your column to its new location. You will see a faint line where the column shall be located.

4. Finally, unencumber your column at its new location.

You too can move columns in Excel through cutting and pasting your whole column of cells. The strategy is the same to the click and drag way but I in my view think it’s more uncomplicated.

1. Start via deciding on all of the column via clicking on the header.

2. Cut the column by both urgent Ctrl+X or right-clicking and choosing the Cut possibility.

3. Now make a choice the column that you want to insert cells in front of and right-click on it. Once the pop-up menu seems, click on Insert Cut Cells.

4. Now your column should seem correct the place you want it.

If you've gotten a base level of familiarity with VBA, you'll take a look at writing a macro that may move columns for you. However, it won't in truth prevent any time because you'll most definitely spend more time defining the column movements than you would spend clicking and dragging.

See additionally: How to make a line graph in Excel

What else can I do with columns?

Now that you know how to move columns in Excel and organize your data, you’re able to continue to learn. There is so a lot more you can do with just a bit bit of coaching. If you’re interested in studying more, we’ve highlighted an in-depth learning equipment from Tech Deals that can take you a lot farther than a single submit can.

It’s called the Professional Microsoft Excel Certification Bundle, and it packs eight courses and over 40 hours of content material to will let you hone your talents. You can discover the entirety from charts and graphs to VBA and macros. Once you end the teachings you'll be able to test out the macro means that I hinted at above.

The very best part is that although the learning equipment has a $1,600 retail value, you can get started at the moment for just $39.

Was this page helpful?

You May Like Also

  • Move columns in Microsoft Excel
  • Unhide columns in Microsoft Excel
  • Insert multiple rows in Excel
  • Separate first and last name in Excel
  • Set a print area in Excel
  • Subtract in Microsoft Excel
  • Insert a checkbox in Excel
  • Create a drop down list in Excel
  • Make a pie chart in Excel
  • Make a line graph in Excel
  • How to make a line graph in Excel
  • Professional Microsoft Excel Certification Bundle
  • How to unhide columns in Microsoft Excel
  • How to subtract in Microsoft Excel
  • How to insert a checkbox in Excel
  • Move columns in Microsoft Excel
  • Unhide columns in Microsoft Excel
  • Insert multiple rows in Excel
  • Separate first and last name in Excel
  • Set a print area in Excel
  • Subtract in Microsoft Excel
  • Insert a checkbox in Excel
  • Create a drop down list in Excel
  • Make a pie chart in Excel
  • Make a line graph in Excel