As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Effortless Formatting: A Guide on How to Merge and Center in Excel

Merging and centering cells in Excel is a powerful formatting feature that helps create visually appealing and organized worksheets. In this guide, we'll walk you through the process of merging and centering cells, providing you with the tools to enhance the layout and presentation of your data.

Recognizing the Need for Merging and Centering

Merging and centering cells is commonly used for creating titles, headers, or improving the overall aesthetic presentation of data in Excel. Understanding how to merge and center cells is valuable for achieving a clean and professional look in your worksheets.

Selecting the Cells to Merge and Center

Before merging and centering cells, it's crucial to select the range that you want to format. This could be a single cell, a row, a column, or a rectangular range of cells.

Using the "Merge & Center" Feature

Excel's "Merge & Center" feature is a straightforward way to merge selected cells and center the content within the merged cell. We'll guide you through the steps of using this feature to achieve a clean and centered presentation.

Merging and Centering Across Rows or Columns

In addition to merging and centering cells in a single row or column, we'll demonstrate how to apply this formatting across multiple rows or columns. This technique can be useful for creating headers that span a range of cells.

Handling Text Alignment and Wrapping

When cells are merged and centered, text alignment and wrapping become important considerations. We'll provide tips on adjusting text alignment and enabling text wrapping to ensure that your content is displayed as intended within the merged and centered cells.

Unmerging Cells When Needed

There may be situations where you need to unmerge cells to revert to the original layout. We'll cover the steps for unmerging cells and maintaining the content in the top-left cell of the merged range.

Using Merge and Center with Center Across Selection

For an alternative to "Merge & Center," we'll introduce the "Center Across Selection" option. This approach allows you to achieve a similar effect without physically merging cells, providing flexibility in your formatting choices.


Mastering the skill of merging and centering cells in Excel empowers you to create visually appealing and well-organized worksheets. By following the steps outlined in this guide, you'll be equipped to merge and center cells using various methods, whether you prefer the classic "Merge & Center" feature, spanning cells across rows or columns, or utilizing alternative options like "Center Across Selection." Whether you're formatting titles, headers, or improving the overall presentation of your data, understanding how to merge and center cells in Excel adds a layer of professionalism and clarity to your worksheets.