Discussion
In MS Excel, what does Merge and Centre do?
Answer: A
Correct answer: Combines the selected cells into one and centres the content
Merge and Centre joins the selected cells into a single larger cell and centres its content. Only the value in the upper left cell is kept; everything else is discarded, with a warning. It is useful for a title spanning several columns, and harmful almost everywhere else. Merged cells break sorting and filtering, prevent selecting a whole column cleanly, confuse formulas that expect one value per cell, and make pivot tables and keyboard navigation awkward. The alternative that gives the same appearance without the damage is Center Across Selection, in the Format Cells alignment tab. It centres text visually across several columns while leaving every cell separate, and it is what should be used in any range that will be sorted or analysed. The third option describes that setting, and the second describes SUM. Merging can be undone with the same button, which restores the cells but not the values that were discarded.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development