30 EXCEL POWER TIPS
Discover the shortcuts and tricks used by the pros
Enter your details for immediate access
Using Merge and Centre in Excel can cause many problems.
Here’s a quick tip to overcome those problems using one of those little gems hidden deep inside Excel.
Perhaps you use the Merge and Centre feature, available in Excel on the Home ribbon. It merges a range of pre-selected cells and horizontally centres the text. If more than one of the cells contains text, only the text in the first cell is retained and the rest are discarded.
There are a number of problems that occur when using Merge and Centre.:
To get around the problems with Merge and Centre, you should use ‘Center Across Selection’ instead. Here’s how:
The text becomes centred but the individual cells remain intact so Excel can continue using the rows and columns that it so loves. All of the aforementioned problems disappear.
So stop using Merge and Centre and start using Center Across Selection.
Did this clear something up for you? If so, please share on your socials and/or post a brief comment below.
Likewise, if something didn't make sense or you have a question, pop it into the comments below. I'll be waiting ...
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.