By checking this box, you agree to lớn the Terms of Use và Privacy Policy & to receive electronic communications from, which may include marketing promotions, news và updates.

You can merge & center data horizontally or vertically across multiple cells in Excel 2010. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and center in Excel 2010 is lớn horizontally center a worksheet title over a table.

Bạn đang xem: How to merge cells in excel 2010

You can only split a cell that has previously been merged.

Merging and centering cells

Follow these steps lớn merge và center a range of cells:

Select the range of cells you want to lớn merge and center.

You can use Merge & Center only on a contiguous, rectangle-shaped range of cells.


A worksheet title before merging and centering.

On the trang chủ tab, in the Alignment group, click the Merge và Center button.

The cells are merged into a single cell, và the text (if any) is centered within the merged cell.


A worksheet title after centering it across columns A through E.

Xem thêm: Trò Chơi Bán Hàng Ăn Nhanh, Top 20 Game Bán Đồ Ăn Nhanh Hay Nhất 2022

(Optional) Change the alignment in the merged cell, if desired.

For example, click the Align Text Right button in the Alignment group if you want the text in the merged cell lớn be right-aligned instead of centered.

If you want to lớn merge cells without centering the text contained in the cell, click the drop-down arrow beside the Merge và Center button in the Alignment group and choose either Merge Across or Merge Cells.

Splitting a merged cell

If you need lớn split a cell that you"ve merged with the Merge & Center button, follow these steps:

Select the merged cell.

The Merge & Center button appears selected in the Alignment group.

Click the Merge & Center button in the Alignment group.

The merged cell reverts to lớn a cell range again, and any text contained in the merged cell appears in the upper-left cell of the range.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the tác giả of all editions of Excel For, Excel All-in-One For, Excel Workbook For, and Windows For Quick Reference. He"s also an experienced educator.

This article can be found in the category:

From the Book Excel 2010 For

Quick Links


Opt in khổng lồ our newsletter!


By entering your thư điện tử address & clicking the “Submit” button, you agree lớn the Terms of Use and Privacy Policy và to receive electronic communications from, which may include kinh doanh promotions, news & updates.

About has always stood for taking on complex concepts & making them easy to lớn understand. helps everyone be more knowledgeable and confident in applying what they know. Whether it"s lớn pass that big test, qualify for that big promotion or even master that cooking technique; people who rely on, rely on it lớn learn the critical skills & relevant information necessary for success.

Terms of Use
Privacy Policy
Cookies Settings
bởi vì Not Sell My Personal Info - CA Only