View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ronald J. Ronald J. is offline
external usenet poster
 
Posts: 1
Default Is there an easy way to find/display merged cells in excel

I received an excel spreadsheet from a third party and wanted to sort it, but
because it had merged cells - it couldn't be sorted. I would like to know if
there is a way to display or find merged cells in a spreadsheet.

As for the sort, I know that I can highlight the entire spreadsheet and
press the "merge and center" icon and it will unmerge everything. But I'm
concerned about what cells are merged and how it will affect the spreadsheet
if I indiscriminately unmerge them.

Thanks for any assistance.