Avoid Merge and Center Option in Excel & Use This Hidden Option

Published: 01 January 1970
on channel: Easy Explain

4,488

311

How to use Replace Merge and Center option in excel with a hidden alternative in Excel?

In this video we will learn how can we replace with another hidden option in excel. Merge and center option used to club two or more cells and align the text in center written in it. This way multiple cells become one cell and make it hard to select and edit further.
Merge and Center is actually a cell(s) formatting option given in home tab just aside the fonts separator. It is very useful when you want to cover a large number of cells in row or columns and convert them into a single header of the table.

#easyexplain
#mergeandcenter
#alignmentinexcel
#ReplaceMergeandCenter