How to Merge Cells in Excel: Step-by-Step Guide for Beginners
Microsoft Excel is one of the most commonly used tools for working with data. People use it for simple lists, office reports, budgets, and large datasets. When beginners start using Excel, one of the first formatting questions they ask is how to merge cells in Excel.
Merging cells can help make a spreadsheet look cleaner and easier to understand, especially when working with headings or titles. However, if it is not used properly, it can also cause confusion, data loss, or problems with sorting and formulas.
This guide explains how to merge cells in Excel step by step, what each merge option does, common mistakes beginners make, and better alternatives you should know. It is written in a clear and simple way, making it useful for anyone learning Excel, including those exploring Excel courses in Perth or self-learning Excel skills.
What Does “Merge Cells” Mean in Excel?
Merging cells in Excel means joining two or more cells into one single cell. After merging, the selected cells behave like one larger cell instead of separate ones.
This is usually done to:
- Create titles that span across multiple columns
- Make headings easier to read
- Improve the visual layout of reports
- Align text neatly in a worksheet
For example, if you want a heading to appear across columns A, B, and C, you can merge those cells so the text looks centered and clean.
Why Beginners Use Merge Cells in Excel
Beginners often use merged cells because:
- It makes spreadsheets look organised
- Headings stand out clearly
- Reports appear more professional
- Data is easier to read when printed
Many people learning Excel through practice or from training focus on formatting early on, which is why merge cells is one of the most used features by new users.
However, merging should be done carefully and only when needed.
Important Things to Know Before Merging Cells
Before you merge any cells, it is important to understand how Excel handles data during the process.
Only One Value Is Saved
If more than one selected cell contains data, Excel will keep only the value in the top-left cell. All other data will be removed.
Merged Cells Can Cause Problems
Merged cells can:
- Break sorting and filtering
- Cause issues with formulas
- Make navigation harder in large sheets
Because of this, merged cells should be used mainly for visual formatting, not for storing or managing data.
How to Merge Cells in Excel (Basic Method)
This is the simplest way to merge cells and is suitable for beginners.
Step 1: Select the Cells
Click and drag to select the cells you want to merge. The cells must be next to each other.
Step 2: Go to the Home Tab
On the Excel ribbon at the top, click Home.
Step 3: Click “Merge & Center”
In the Alignment section, click Merge & Center.
The selected cells will now be merged into one, and the text will be centered automatically.
Understanding Excel Merge Options
Excel offers different merge options. Knowing the difference helps you avoid mistakes.
Merge & Center
- Combines selected cells
- Centers the text
- Best for headings and titles
Merge Across
- Merges cells across each row separately
- Useful when working with multiple rows of headings
Merge Cells
- Merges cells without changing text alignment
- Gives more control over formatting
Unmerge Cells
- Splits merged cells back into individual cells
- Restores the original layout
How to Merge Cells Without Losing Data
A common beginner issue is losing text or numbers after merging cells. If your goal is to combine content, merging is not the right tool.
Use a Formula Instead
To safely combine text from multiple cells, use a formula like:
=TEXTJOIN(” “, TRUE, A1, B1, C1)
This keeps all data and avoids formatting problems. Many Excel learners, including those taking Excel courses in Perth, are taught to use formulas instead of merging for data-related tasks.
How to Unmerge Cells in Excel
If you need to undo a merge:
- Select the merged cell
- Go to Home
- Click Merge & Center
- Choose Unmerge Cells
The content will remain in the top-left cell.
Common Mistakes Beginners Make When Merging Cells
Many Excel issues come from incorrect use of merged cells. Common mistakes include:
- Merging cells inside tables
- Merging cells used in formulas
- Merging before sorting or filtering
- Using merged cells in data entry areas
Best practice is to merge only headers and titles, not the data itself.
A Better Option Than Merging: Center Across Selection
Many experienced Excel users avoid merging cells and use Center Across Selection instead.
How to Use Center Across Selection
- Select the cells
- Press Ctrl + 1
- Go to the Alignment tab
- Under Horizontal, choose Center Across Selection
- Click OK
This option:
- Looks like merged cells
- Keeps data separate
- Works better with formulas and sorting
When Should You Use Merge Cells?
Good Situations for Merging
- Report titles
- Section headers
- Printable worksheets
- Dashboard headings
Situations to Avoid Merging
- Large datasets
- Tables with filters
- Sheets used for calculations
- Pivot tables or data analysis
Knowing when to merge and when not to is a key Excel skill taught in structured learning.
How Merged Cells Affect Sorting and Filtering
Merged cells can:
- Prevent sorting from working
- Disable filter options
- Cause Excel warning messages
If you plan to sort or filter data, it is best to avoid merging cells entirely.
Keyboard Shortcut for Merging Cells
Excel does not have a single-key shortcut, but you can use:
Alt → H → M → C
This performs Merge & Center using the keyboard.
Example: Creating a Simple Report Title
To create a clear title:
- Select cells A1 to D1
- Click Merge & Center
- Type your title text
This works well for visual presentation without affecting data below.
Excel Versions That Support Cell Merging
Merge cells works in:
- Excel 365
- Excel 2021 and 2019
- Excel for Windows
- Excel for Mac
- Excel Online (with some limitations)
Best Practices for Beginners
- Use merge cells only for headings
- Avoid merging data cells
- Use formulas to combine text
- Test sorting and filtering after formatting
- Keep layouts simple and clear
These practices are commonly recommended in beginner learning paths and Excel courses Perth to avoid long-term spreadsheet issues.
Key Takeaways for Excel Beginners
Understanding how to merge cells in Excel is an important beginner skill. While merging can improve the appearance of a worksheet, it should be used only where it makes sense. Overusing merged cells can lead to errors, lost data, and problems with sorting and formulas.
By following the steps and tips in this guide, beginners can format Excel spreadsheets correctly while keeping their data clean and functional. If you want to build stronger Excel skills beyond basic formatting, learning through structured practice or guided by an Excel specialist in Perth can help you understand best practices and avoid common spreadsheet mistakes.
Frequently Asked Questions
How do I merge two cells in Excel?
To merge two cells in Excel, first select the two adjacent cells. Then go to the Home tab and click Merge & Center in the Alignment section. The two cells will combine into one, and the text will appear centered.
This is one of the first formatting skills covered when learning Excel basics, especially in beginner-level Excel training or Excel courses in Perth that focus on spreadsheet layout and presentation.
What is the shortcut for merge cells in Excel?
Excel does not have a single-key shortcut to merge cells, but you can use the keyboard sequence:
Alt → H → M → C
This shortcut applies Merge & Center without using the mouse. Keyboard shortcuts like this are commonly taught in structured Excel courses in Perth to help users work faster and more efficiently.
How do you merge two columns in Excel?
Excel does not merge entire columns at once. Instead, it merges selected cells within columns.
To merge cells from two columns:
- Select the cells across both columns that you want to merge
- Go to Home → Merge & Center or choose Merge Cells
Understanding the difference between merging cells and managing column data is an important concept in Excel courses Perth, especially for users working with structured datasets.
What is Ctrl + F4 in Excel?
Ctrl + F4 closes the current Excel workbook window while keeping the Excel application open.
This shortcut is helpful when working with multiple files at the same time and is often introduced in Excel learning sessions or Excel courses in Perth that focus on productivity and file management.
How do you combine all cells into one cell?
To combine multiple adjacent cells into one:
- Select all the cells you want to combine
- Go to Home → Merge & Center
Excel will merge all selected cells into one and keep only the data from the top-left cell.
If the goal is to combine text from many cells without losing data, a formula such as TEXTJOIN is usually recommended. This distinction between formatting and data handling is commonly explained in Excel courses in Perth to help users avoid common mistakes.
NATIONAL & INTERNATIONAL TRAINING