71.7k views
4 votes
The selected cells have been merged and centered. How do you unmerge them?

a) Click the Unmerge button in the Alignment Ribbon Group
b) Press Ctrl + U on the keyboard
c) Right-click and select Unmerge from the context menu
d) Use the keyboard shortcut Ctrl + Alt + M

User Jaquan
by
8.0k points

1 Answer

5 votes

Final answer:

To unmerge merged cells in a spreadsheet, click the Unmerge button in the Alignment Ribbon Group; options 'b', 'c', and 'd' are incorrect for unmerging cells.

Step-by-step explanation:

To unmerge cells that have been merged and centered, you should:

  • Click the Unmerge button in the Alignment Ribbon Group of your spreadsheet application, such as Microsoft Excel.

Option 'a' is the correct answer to this question. There is no 'Unmerge' option available in the context menu when you right-click (option 'c'), and the keyboard shortcuts Ctrl + U (option 'b') and Ctrl + Alt + M (option 'd') are not standard shortcuts for unmerging cells. Instead, Ctrl + U generally underlines text, and Ctrl + Alt + M does not typically pertain to cell merging.

User StXh
by
8.9k points