Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Merge Cells in Excel? 3 Easy Ways

How to Merge Cells in Excel? 3 Easy Ways

(Note: This guide on how to merge cells in Excel is suitable for all Excel versions including Office 365)

When working in Excel, you might have to deal with a lot of data. The data can either be manually populated or can either be downloaded or exported from external databases. When exporting or downloading any workbook or spreadsheet, the large data might contain different sections which can be improperly aligned or oriented. 

Some cells, especially those containing larger data, might take up the place of another couple of cells. In such a case, there might be a need for you to merge cells. In this article, I will tell you 3 ways and conditions to merge cells in Excel.

You’ll Learn:

  • Why Merge Cells in Excel?
  • How to Merge Cells in Excel?
    • Using the Merge & Center Option
    • Using Keyboard Shortcuts
    • Using Format Cells
  • How to Merge Two or More Cells with Different Values
  • Workaround to Merge the Cells

Watch our video on how to merge cells in Excel

Related Reads:

How to Unmerge Cells in Excel? 3 Best Methods

How to Count Cells with Text in Excel? 3 Different Use Cases

How to Calculate Percentile in Excel? 3 Useful Formulas

Why Merge Cells in Excel?

Before we learn how to merge cells in Excel, let us see what merging is and why we merge cells in Excel.

The layout of Excel consists of cells. Every cell contains a name and every data in Excel is entered in the cell. The data can either be a text, string, character, number, or special characters. 

Merge is a function in Excel where you can combine two or more cells to form a large single cell. 

Consider an example where you have to enter a string or a long text. When you enter them into a single cell, Excel makes it seem like the text is populating over different cells. But, only one cell (A1) holds the value. And, when you want to edit the text, you can only edit them in cell A1. 

Select the Cells to Merge
Select the Cells to Merge

Also, when any data is entered in any nearby cells, the contents of the former cell are shortened.

The contents are shortened
The contents are shortened

Though this might look good when the data is small, the orientation and alignment of the text get complicated as the data gets larger. This is true, especially in the case of Excel tables or PivotTables.

Merging cells help in clearing the nearby blocks and help showcase the particular cell as a whole block of text. Merging cells greatly helps in improving the readability of the sheet. It also helps in improving the overall texture and appearance of the workbook and provides emphasis on specific places like titles and headings. 

Also Read:

Scientific Notation in Excel – A Step-by-Step Guide

How to Use ISTEXT in Excel? With 3 Different Methods

How to Use Excel Split Screen? 3 Simple Ways

How to Merge Cells in Excel?

When you enter a text in Excel, it appears across multiple columns and cells. Sometimes, they might not be properly oriented or aligned. Now, let us see how to merge cells in Excel with the same example.

Using the Merge & Center Option

You can easily merge cells in Excel using the Merge & Center option. 

To merge the cells, first, select the cells you want to merge. In this case, we want to merge the cells A1, B1, and C1. 

How to Merge cells in Excel using Merge & Center
How to Merge cells in Excel using Merge & Center

After selecting the cells, navigate to Home. Under the Alignment Column, select Merge & Center. You can either select the option directly or click on the dropdown and select any merging option to merge the cells.

There are 4 options in the Merge dropdown.

  • Merge & Center: Merges the content of the cell into one large cell and aligns the content in the center.
  • Merge Across: This option merges the cells in the same row but maintains the same alignment.
  • Merge Cells: This option just merges the selected cells.
  • Unmerge Cells: This option separates all the merged cells.
Select Merge and Center
Select Merge and Center

Once you merge the cells, you can see that the partitions that separate the cells have disappeared and the cells A1, B1, and C1 are combined. However, you can see that the cells B1 and C1 have disappeared, and only A1 remains. This is one of the drawbacks of merging the cells.

In case you have to merge the whole row, only the cell in which you house the value will be available and the rest would disappear.

The selected cells are merged
The selected cells are merged

Using Keyboard Shortcuts

Excel provides a lot of shortcut keys for various operations to help perform them easily and effectively. To merge cells, Excel has a combination of shortcut keys called hotkeys.

To merge cells using the keyboard shortcuts, first, select the cells by holding the Shift key and using the arrow keys to select the adjacent cells.

Select the cells
Select the cells

Now, hold the Alt key and press H. This opens the hotkeys layout which shows the specific keys corresponding to specific operations. 

The hotkeys are enabled
The hotkeys are enabled

Press M. This shows up a list of options from the Merge dropdown. Press any of the keys (C, A, M, U) to merge the cells in a specific format. 

Press the shortcut keys to merge the cells
Press the shortcut keys to merge the cells

This merges the separate cells into one single cell.

How to Merge Cells in Excel using Shortcut Keys
How to Merge Cells in Excel using Shortcut Keys

Using Format Cells

Another way to merge cells is by using the Format Cells option.

Select the cells you want to merge and right-click on them.

Select the Format Cells option. Or, you can use the keyboard shortcut key Ctrl+1.

This opens up a Format Cells dialog box. Click on the Alignment tab. Under the Text Control section, check the checkbox for Merge Cells and click OK. 

This merges all the selected cells. 

Select Merge Cells
Select Merge Cells

How to Merge Two or More Cells with Different Values

We saw how to merge cells into a single cell without any values populating the nearby cells. But if you had to merge two cells with separate values, what would you do?

Consider another example where you have to merge two cells that contain the first name and last name into a single cell.

The best option would be to choose the Merge & Center option. So, you would select the cells and click on Merge & Center.

Excel only keeps the data in the first cell (or the data in the top-left of the selected cells) and deletes the data in the rest of the cells.  

To reconfirm, Excel throws up a warning popup saying “Merging Cells only keeps the upper-left value and deletes all the other values”. Once you confirm it, click OK.

Merge warning pop-up
Merge warning pop-up

Workaround to Merge the Cells

You can see when you merge cells with neighboring values, Excel only considers the upper-left value while merging and deletes any other values in the existing cells. This cannot be the case every time.

When you want to merge cells without deleting or losing any value, you can choose other methods like concatenation, or copy and paste the values into other cells.

Frequently Asked Questions

How to merge cells quickly in Excel?

Using the shortcut keys is one of the fastest and most efficient ways to merge cells in Excel. Select the cells you want to merge and press the shortcut keys Alt+H+M+C.

Can we combine or merge two columns in Excel?

In Excel, you can not only merge cells but also multiple rows and columns. Just select the cells, rows, or columns you want to merge and follow the same instructions from this article.

How to merge cells in Excel without losing data?

Use the CONCATENATE function or copy and paste the data into the neighboring cell while merging to avoid loss of data.

Suggested Reads:

How to Create a Venn Diagram in Excel? 2 Easy Ways

How to Create a Step Chart in Excel?

How to Enable Excel Dark Mode? 2 Easy Methods

Closing Thoughts

Sometimes, merging cells can lead to inconsistency of values or discrepancies when sorting data. However, merging cells greatly helps in improving readability. The text that was unevenly formatted or improperly aligned in the sheet or table can be properly merged and emphasized.

In this article, we saw how to merge cells in Excel in 3 easy ways. Additionally, we also saw what would happen if we merge two or more cells with values. 

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

5 Tips for Using Windows 7 to Help Your PC

How to Combine Two Columns in Excel? 2 Easy Methods

Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)

How to Use the Format Painter Excel Feature? — 3 Bonus Tips

How to Enter Bills for Vendors in QuickBooks 2019

HLOOKUP in Excel

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)