Excel Video 278 has a real-world application from a client I visited in Dallas two weeks ago. They had a big spreadsheet that wouldn’t sort because of a merged cell. The problem was how to find a merged cell in a big spreadsheet. After doing all of these Go To Special videos I thought I’d find a solution there, but the solution that ended up working for us was under Options in the Find menu.
If you’re looking for a merged cell, or if you’re looking for cells formatted any of a number of different ways, watch Excel Video 278. I hope this real-world example is helpful for you.
