USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Center
|
|
|
Merge
|
|
|
Merge & Center
|
|
|
Wrap Text
|
Detailed explanation-1: -Click Home > Merge & Center. If Merge & Center is dimmed, make sure you’re not editing a cell or the cells you want to merge aren’t inside a table. Tip: To merge cells without centering the data, click the merged cell and then click the left, center or right alignment options next to Merge & Center.
Detailed explanation-2: -20. To merge and center cells across multiple columns in Excel, and keep the data from the other cells, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E, then Ctrl + Shift + M on your keyboard.
Detailed explanation-3: -Merge across cells: To merge across cells in a single row, highlight the cells and use this keyboard shortcut: ALT H+M+C. Unmerge cells: If you need to unmerge a group of cells, you can highlight the merged cell and press the following keys at the same time: ALT H+M+U.