Learn how to merge and unmerge cells in excel

merge unmerge

To merge unmerge multiple cells in one single cell you can use the shortcut keys Alt ➜ H ➜ M ➜ A. When you press the shortcut key merges all the cells but only takes the upper left value (the value you have in the first cell). It shows you a message that says, merging cells only keeps the upper left value and discard the other values”. cell merge

And when you click OK it merges all the cells

2-merged-cells

Alt ➜ H ➜ M ➜ A

If you want to unmerge cells you need to use the same shortcut keys as above. And following are some other important shortcut keys related to merging cells.

  • Alt ➜ H ➜ M ➜ A: To merge selected cells into rows.
  • Alt ➜ H ➜ M ➜ C: To merge cells and center align the value.

Free Excel Templates

Employee-Promotion-Letter

Employee Promotion Letter

Employee Promotion Letter is a ready-to-use excel template which helps …

Money Manager Excel Template

Money Management

Download Our Excel Template for Money Management: The Ultimate Tool …

http://xlsxtemplates.com/wp-content/uploads/2022/01/project-budget-WBS.png

Project Budget in WBS

What is Work Breakdown Structure (WBS) You can manage your …

Task Order Billing Format

Task Order Billing Format

Task Order Billing Format Template: Your Key to Efficient Milestone-Based …

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.