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.
(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 nuhoangthoitrang.vn, Excel All-in-One For nuhoangthoitrang.vn, Excel Workbook For nuhoangthoitrang.vn, and Windows For nuhoangthoitrang.vn Quick Reference. He"s also an experienced educator.
This article can be found in the category:
From the Book Excel 2010 For nuhoangthoitrang.vn
Opt in khổng lồ our newsletter!
nuhoangthoitrang.vn has always stood for taking on complex concepts & making them easy to lớn understand. nuhoangthoitrang.vn 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 nuhoangthoitrang.vn, rely on it lớn learn the critical skills & relevant information necessary for success.
bởi vì Not Sell My Personal Info - CA Only