Tuesday, 7 May 2019

How to Merge and Unmerge Cells in Microsoft Excel

Merging and unmerging cells in Microsoft Excel is a great way to keep your spreadsheet clean, well-organized, and easy to understand. The most common use is creating a header to identify the content across several columns, but no matter the reason, it can quickly be done in Excel.

Note that Excel doesn’t allow you to split a cell the same way that you can in a table in Microsoft Word. You can unmerge cells that you have previously merged.

Merging Cells

Merging cells combines two or more cells into a single cell. To do this, select the cells you want to merge.

Highight cells in Excel

Next, on the “Home” tab, click the “Merge and Center” button.

Merge and Center

As the name implies, this will merge the selected cells. Any text in the cells will be centered by default.

Merged Cells in Excel

Read the remaining 9 paragraphs



from How-To Geek http://bit.ly/2Ww4Mr0

No comments:

Post a Comment