Do Not Merge & Center, Use This Trick Instead To Sort Effectively - The Excel Hub

We cover a useful trick to merge cells without using merge & centre and the drawbacks that come with it. In our example, we have fictitious investment fund data. For most of the funds, we have data for the Returns, ESG Rating, Fees and Fund Size. The exception is one fund where the data is missing. To make it look more presentable, we may want to merge the 4 cells that currently have N/A values. The issue is that when we try to filter one of the columns, we are unable to do so, due to the merged cells. This is because all cells need to be the same size. Therefore, we have a dilemma - we want to make the table look presentable but at the same time we want to sort to make the data more useful. To overcome this, we can use horizontal text alignment.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Do Not Merge & Center,...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[e-mail]
Overview: (0:00)
Sorting Using Merge & Center: (0:37)
Solution: Text Alignment (1:02)