Get instant live expert help on how to find merged cells in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula that could find values in the merged yellow rows (IDDD, /DDDD, and ZDDD) and show those values in the output columns... for those rows that are under the yellow rows.. one possible solution is a formula that searches the most recent merged cells in excel and copies the values from there. This is because the rows with the data have merged cells. Any other solution is also welcomed.
Solved by G. Y. in 12 mins
I am hoping to find a macro that will help me to convert one table (with columns of data that may contain merged cells and duplicate values) to another table with non merged cells and non duplicate values in 2 columns. Please see attached spreadsheet. Can you please help? Thanks!
Solved by K. L. in 13 mins
When sorting in Excel, I keep getting the Alert message: This operation requires the merged cells to be identically sized. Help!
Solved by D. H. in 17 mins
if i have merged cells in a column together and written in it how do i get writing in the middle of the box
Solved by S. Q. in 21 mins
when i try to sort, i get this message- This operation requires the merged cells to be identically sized. i know nothing about merged cells, didnt know i had any, i just want to, please?
Solved by O. D. in 28 mins