We show you how to rearrange columns in Excel using four different techniques. Each will ensure that your data will not be overwritten.

You can switch columns and rows in Microsoft Excel using the Transpose function. It works with a formula we'll show you here or by using paste options.

How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

We show you how to autofit in Excel for both columns and rows, using double-click. shortcuts, and the ribbon.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

Select the first cell (after the header) of the first column and type the formula. The formula to reverse a list with data in multiple columns in Excel by using the INDEX function is as follows: ...

How to Divide Excel Columns. When working with business data, you may encounter grouped data that needs to be divided into multiple columns. As an example, you might have a customer list that ...