- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -
Find Merged Cells in Excel
Posted By On July 13, 2009 @ 12:48 PM In MS Excel | 1 Comment
Next we need to click the Format button.
In the Find Format dialog box go to the Alignment tab, check the Merge Cells box and click OK.
Back in the Find and Replace dialog box you’re ready to either Find Next or Find All.
If you Find Next then Excel will move the selection to the next set of merged cells.
If you click Find All Excel will give you a list at the bottom of the dialog box where locations of merged cells are located.
You’ll find that the locations are linked to their locations. Click on any of them and Excel takes you to that location.
And… in case you aren’t aware… you can edit a worksheet with the Find and Replace dialog box open. Just slide it out of the way and get to work – but don’t bother closing it – this will allow you to jump from place to place on the list without starting over.
No more slow manual searches for you… find one or all but be sure to make Excel do the looking.
Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com
URL to article: http://www.worldstart.com/find-merged-cells-in-excel/