Hi Pam

To the best of my knowledge you can't force differently shaped ranges
due to merging into one another. Merging cells is an unnecessary and
unneeded activity in XL. It is a long way from best practise and you
can get the same look and feel using basic formatting functions.

Go into your workbooks unmerge the merged cells - all of them. Now
your question title becomes one of the most commonly answered question
on this and other forums. You will find your answer in moments.

Take care

Marcus