why you should never merge cells in excel if you merge and center your values you're gonna notice two things number one you won't be able to select your values properly and number two he won't be able to sort them either you'll get an error so instead just do this selector values press control one and then click on the alignment tab click on the general dropdown and change it to center across election then click ok and that's it now you can select their values properly and you can also sort without having any errors that's it