How To Detect Which Cells Are Merged In Google Sheets

if you have such an option you can use Conditional Formatting to check for merged cells like:

=MOD(COLUMN(),2)=0

enter image description here

where you can immediately spot merged cells where the color pattern is interrupted

in the same manner you can use this formula for rows:

=MOD(ROW(),2)=0

enter image description here

or you can play with scripts to find merged cells: https://issuetracker.google.com/issues/36753230

Related