Merge Cells in Excel (Step by Step Guide)

Merge Cells in Excel

Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean reports format and clean document prints.

Why merging cells used in Excel?

If you work with data in Excel, you may find yourself in a situation where you need to merge cells in order to create a single, cohesive unit of information. For example, you may have a list of data that contains first and last names in separate cells, and you want to combine them into a single cell. 

Excel VBA Master Tool Kit

Fortunately, Excel makes it easy to merge cells.

Excel Shortcut - How to merge cells in Excel?

There are multiple ways to use shortcut for merging cells in Excel. Here are mostly used methods:

  • Merge Cells: ALT H+M+M.
  • Merge & Center: ALT H+M+C.
  • Merge Across: ALT H+M+A.
  • Unmerge Cells: ALT H+M+U.

Step by Step Guide to Merge Cells in Excel

Let’s quickly scroll down a bit more to understand the steps of How to Merge Cells in Excel.  

Step 1

Select the cells you want to Merge with the help of mouse example A1 to C1.

or

Select the cell (A1), hold the Shift key and move the Right arrow key till cell C1. So this process will highlight the Range (A1 to C1) as displayed in below image:

SHIFT+ (→) Right Arrow Key for Row Selection

SHIFT+ (↓) Right Arrow Key for Column Selection

Merging Cells in Excel

Step 2: Click on the Home tab and select Merge & Center Option as Highlighted in below image:

This will merge all cells through A1:C1 and will display it as one cell. See how “Student Scores” is displaying across A1:C1. This is called merging cells.

Merge Cells in Excel

If you want to align your text on the right side or left side, you may use alignment option to align text within merged cells

Disadvantageous of using Merge Cells in Excel

  1. It is quite difficult to copy and paste data in the merged cells. 
  2. Post merging cells, data gets deleted from all the cells and only first cell data remain visible in the sheet i.e. First Left cell value or Upper Left cell value

Hope you liked this article. Please do comment your views on the same.

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.
Download Practice File

Similar Topics

If you like to watch videos for learning Microsoft Advanced Excel, then you may click here and subscribe our channel

Similar Posts

Correlation in excel
|

Correlation in Excel: coefficient, matrix and graph

BySumit Shrimal

This tutorial teaches the basics of correlation in Excel. It shows how to find a correlation coefficient, make a correlation matrix, and understand the results.
Correlation is one of the easiest calculations you can do in Excel. Even though it’s easy, it helps a lot in understanding how two or more things are related. Excel has all the tools you need to do a correlation analysis—you just need to know how to use them

Sort Data in Power Query in Excel

How to Sort Data Using Power Query in Excel: A Step-by-Step Guide

Byexcelsirji

This article unveils the magic of Power Query, a built-in Excel tool that simplifies data organization. Learn how to sort by single or multiple columns, create layered sorts for complex needs, and even reverse your data order entirely. Power Query puts you in control, transforming your data into a well-structured format for effortless analysis.

Histogram in Excel
|

How Histogram Works in Excel? (Definitive Guide)

Byexcelsirji

In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit