FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the range of cells over which you want to center text. Right-click the selected cells, and then click Format Cells. Click the Alignment tab. In the Horizontal list, click Center Across Selection.

Detailed explanation-2: -To merge a group of cells: To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar.

Detailed explanation-3: -Excel has a unique button called “Merge & Center, ” which is used to merge two or more different cells. When data is inserted into any merged cells, it is in the center position; thus, the name “Merge & Center.” On re-clicking on the button, it unmerges the cells.

Detailed explanation-4: -So when you have two or cell merged and you want to unmerge them, use merge and center button. Go to the home tab> Click on “Merge & Center” in Alignment Group.

Detailed explanation-5: -One way to merge and center data in Excel is to use the Merge and Center button on the toolbar. To do this, select the cells you want to merge and then click the Merge and Center button. This will merge the selected cells into one cell and center the data within that cell.