As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Merge Two Columns in Excel: Step-by-Step Guide

Combining data from two separate columns in Microsoft Excel can be done quickly and easily using the "Merge and Center" feature. Here's a step-by-step guide to help you through the process.

Step 1: Select the Cells You Want to Merge

The first step is to choose the cells that you want to merge. Use either of the following methods:

  • Click and drag your mouse over the cells.
  • Hold down the "Shift" key and use the arrow keys to select the cells.

Step 2: Click the "Merge and Center" Button

Locate the "Merge and Center" button on the toolbar. It is situated in the "Alignment" section and is represented by two cells with an arrow between them. Click this button.

Step 3: Enter Your Data

Now that the cells are merged, you can enter your data. Click in the merged cell and start typing. Notice that the entered data is centered within the cell.

Step 4: Save Your Workbook

After entering the data, remember to save your workbook. You can do this in one of the following ways:

  • Click the "File" menu and select "Save" from the drop-down menu.
  • Use the keyboard shortcut "Ctrl+S" to save your workbook.

By following these steps, you can effectively merge two columns in Excel using the "Merge and Center" feature.