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 Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite 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