Next press “Ctrl+F” from keyboard, this will open excel “Find” window.First of all select the range where you want to find merged cells.But in this method we are going to use the excel find and replace method quite cleverly to do this task: Method 1: To find Merged Cells in Excel:Īctually in excel there is no direct option to find out merged cells present in a sheet. This can be an easy task if the column is small but if you have a huge column with hundreds of elements, then manually searching for merged cells can become a cumbersome task.įew days back I also faced the same issue and this is the reason why today I am going to guide you on how to find or locate merged cells in excel. If the problem continues to occur, go to the next method. Uncheck Do not check spelling or grammar, and then click OK. Select the language dictionary you want the speller to use, such as English (US). To resolve this issue you simply need to find the Merged Cells present in the range to be sorted. To set Document Language, follow these steps: Open a document in Word for Mac. As you can clearly see that this issue is due to the presence of merged cells in the column to be sorted.
There are times when you try to sort a column in your spreadsheet and it throws an error saying that, “To do this, all merged cells should be of same size”.
0 kommentar(er)
