Merge and Center

Posted on:  10/14/2018
Merge and Center

It is tempting to use merge and center in Excel. It stands out when you open Excel. Avoid merge and center. Three reasons why merge and center is evil:

  1. Data with Merge and Center can't be sorted.
  2. Remove Duplicates, another great Excel feature, doesn't work with merge and center.
  3. Selecting a column with the keyboard shortcut CTRL + Space doesn't work.

To unmerge all cells at one time

  1. Select All the cells on the worksheet.
  2. Click the Merge & Center down arrow.
  3. Select Unmerge Cells.

YouTube Video - Merge & Center is evil!

Keyboard shortcuts used in the video

  • CTRL + Space to select a column.
  • SHIFT + Space to select a row.
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories