Where Is the Merge Cells Option in Excel? (All Versions)

Post actualizado el día September 27, 2026 by DeiviSanzPlay

If you’ve ever come across an Excel spreadsheet and needed to merge several cells into one to create a cleaner title or align information, you’ve surely asked yourself the million-dollar question. You’re not alone. It’s one of the most common queries among new users and those who don’t use the program daily. Finding the right tool can be a bit confusing at first, since Microsoft tends to reorganize its menus with updates.

I recommend checking out this interesting article: 10 Essential Gadgets That Will Improve Your Productivity in 2025.

On the internet, it’s easy to find forums full of people sharing their screens, frustrated because they can’t locate the command. It’s a universal problem and a simple one to solve once you know where to look. This article isn’t meant to be an expert’s guide, but rather a clear compilation of what can be found online, explained directly so anyone can follow the steps without complications. Let’s break down the location of the function to merge cells in all modern versions of Excel.

where is merge cells in excel

The main location of the merge cells function in Excel has remained fairly consistent over the years, although its visual environment has been changing. In the most recent versions, such as Microsoft 365 and Excel 2021, the command resides in the well-known Ribbon. This is the toolbar with tabs located at the top of the program window.

To find it, you should direct your attention to the tab called “Home.” This tab is the one selected by default when you open Excel and contains the most common tools for formatting your spreadsheet. Once you’re on the “Home” tab, your next stop is the group of tools labeled “Alignment.” This group is where Excel gathers all the commands related to how text is positioned within cells.

Within this “Alignment” group, that’s where you’ll finally find the button to merge cells. It’s not an isolated button; it’s usually accompanied by a small dropdown arrow that lets you access different variants of the merge function. If you don’t click on the arrow, the main button will execute the default action, which is usually “Merge & Center.”

It’s important to understand that “Merge & Center” is just one type of merge. This option joins the selected cells into one and also centers the resulting content. If the content of the original cells was different, only the value of the top-left cell will be kept, and the rest of the information will be lost. Excel will always show you a warning about this before proceeding.

The function is universal for most basic tasks. Whether you’re working on a list, creating a report, or designing a calendar, the path to finding the option always starts on the “Home” tab and then in the “Alignment” group. From there, you have full control over how you want to join your cells.

where is the merge cells button in excel

The merge cells button in Excel has a very particular design that makes it recognizable once you know it. Visually, it’s not a button with a word on it, but an icon. This icon is made up of a graphic representation of several small cells merging into a larger cell, and it almost always includes a lowercase “a” centered in that resulting large cell.

This iconic design aims to be intuitive. The image of the cells joining together conveys the idea of merging or combining immediately. The centered letter “a” represents the text that will be aligned in the middle of the new merged cell, making direct reference to the “Merge & Center” function. It’s a standard in the Microsoft suite that is maintained to ensure consistency.

When you locate this button in the “Alignment” group of the “Home” tab, you’ll notice that it’s actually an element divided into two parts. The main part is the icon itself. If you click directly on the icon, you’ll execute the default action, which, as mentioned, is “Merge & Center.” It’s a quick shortcut for when that’s your specific need.

Right next to the icon, on the right, there’s a small downward-facing arrow. This arrow is crucial because it opens a dropdown menu with all the available options related to merging cells. Not clicking on this arrow is a common mistake that leads users to think that the only option is merge and center, when in reality there are more.

When you open this menu, you’ll find a set of options that give you greater control. The typical options are “Merge & Center,” “Merge Across,” “Merge Cells,” and “Unmerge Cells.” “Merge Cells” joins the cells without automatically centering the text, while “Merge Across” is useful for rows of data. “Unmerge Cells” reverses the action.

where is the merge cells option in excel

The merge cells option in Excel isn’t just one, but a set of tools that let you achieve different effects. Its physical location is, as we’ve seen, on the “Home” tab, “Alignment” group. However, it’s just as important to know the different variants offered by the dropdown menu so you can work efficiently and avoid frustrations.

The “Merge & Center” option is by far the most popular. It’s ideal for table titles or for headers that span several columns. By automatically centering the text, it gives a professional and organized look instantly. Many online tutorials recommend this option as the first step to formatting any basic report.

Then there’s the “Merge Across” option. This one is less well-known but very practical. What it does is merge cells in each selected row independently, but it doesn’t join the rows together. It’s perfect if you have a block of cells across several rows and columns and want to merge the cells of each row separately, keeping the rows individual.

The third main option is simply “Merge Cells.” This function joins the selected range of cells into a single large cell, but unlike “Merge & Center,” it doesn’t alter the alignment of the text. The content will stay in the original position it had in the top-left cell of the selected range. It offers more control over the final format.

Finally, the “Unmerge Cells” option is the one that lets you undo any merge. It will only be active if you’ve selected a cell that was previously merged. When you click on it, the large cell will return to its original state, splitting into the individual cells that formed it. It’s your undo button for this specific function.

Knowing the difference between these options is what separates basic use from advanced use. While a casual user may settle for “Merge & Center,” someone who designs complex tables or dashboards will need to master the use of “Merge Cells” and “Merge Across” to achieve the exact design they have in mind without altering the alignment of their data.

merge cells icon in excel

The merge cells icon in Excel is, as described, a visual representation of cells merging. It’s essential to become familiar with this symbol to navigate the interface with agility. In older versions of Excel, such as Excel 2007 or 2010, the icon was slightly more schematic, but the essence has remained the same: small cells transforming into a large one.

In modern versions, with dark and light themes, the icon adapts to maintain good visibility. However, its shape and meaning are constant. This effort by Microsoft to maintain visual consistency helps users who migrate from one version to another, since they don’t have to relearn the location of essential tools from scratch.

What happens if you can’t find the icon? On rare occasions, the Ribbon may be customized. Some users, or corporate configurations, may have modified the visible tabs. If this is the case, you can right-click anywhere on the ribbon and select “Customize the Ribbon.” From there, you can restore the default settings.

Another alternative way to access the function is through the context menu. If you select a range of cells and right-click with your mouse, in the menu that appears, you can go to the “Format Cells” option. In the window that opens, you should go to the “Alignment” tab. There you’ll find a checkbox called “Merge cells.”

Checking that box and clicking “OK” has the same effect as using the ribbon button. This is the longest route, but it is useful for those who prefer classic dialog boxes or if the icon is not visible for some reason. It is a less efficient path, but just as valid for achieving the goal of merging cells.

Recognizing the icon is half the battle. The other half is understanding its behavior. A tip that is repeated in many help forums is that, after merging cells, you may need to adjust the row or column size manually, since the merge does not do it automatically. This is something that often surprises first-time users.