How to combine text from two cells in excel

Merging cells in Excel is like turning multiple lanes of traffic into one super lane. It’s a handy trick when you want to create a header or label that spans across several columns or rows.

But before you start, remember that merging cells will keep the content from the upper-left cell and ditch the rest. So, let’s get merging!

Step by Step Tutorial: Merge Cells in Excel

First things first, merging cells is all about combining two or more cells to create a single, larger cell.

This is useful for headings or organizing your data in a way that’s easy on the eyes.

Step 1: Select the cells you want to merge

Click and drag to highlight the cells you want to merge.

Selecting the cells is the starting point.

Make sure you’ve got all the cells you want to merge highlighted.

Merge cells in excel shortcut

If you make a mistake, no worries—just click away and try again.

Step 2: Right-click and choose ‘Merge Cells’

Right-click on the highlighted cells and select ‘Merge Cells’ from the dropdown menu.

When you right-click, a menu pops up like magic.

Find ‘Merge Cells’ and give it a click. If you’re more of a keyboar

how to merge two cells in excel and keep both data

how to merge two cells in excel shortcut keys