How do I locate merged cells in my Excel worksheet?
 

How do I locate merged cells in my Excel worksheet? I am receiving an error
messages when I try to sort the worksheet which tells me to either unmerge
all the merged cells or merge all cells to be the same size as the largest
merged cell. I there some way to identify the merged cells?
--
Organ Donors Save Lives

How do I locate merged cells in my Excel worksheet?
 

Thanks to saruman576 at http://www.mrexcel.com/forum/showthread.php?t=74144

To find a merged cell in Excel 2003.

1. Open a Find and Replace Menu.
2. Next to the Find What Field is a Format Box, Click it.
3. This opens the Find Format Menu screen which looks very similar to the
Cell Format Tabs and screens
4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit
boxes.
5. Leave a tick in the Merge Cells Box and click the OK Button to return to
the Find and Replace screen.
6. Now click the Find All Button and ALL merged cells are shown in the lower
window and are selectable to jump to their location.


-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"KarenB" wrote:


How do I locate merged cells in my Excel worksheet? I am receiving an error
messages when I try to sort the worksheet which tells me to either unmerge
all the merged cells or merge all cells to be the same size as the largest
merged cell. I there some way to identify the merged cells?
--
Organ Donors Save Lives

How do I locate merged cells in my Excel worksheet?
 

Thank you very much! It worked like a charm and I will waste no more time
trying to find a solution via Excel Help. Thanks a bunch and have a great
day. :-)
--
KarenB
Organ Donors Save Lives


"Sheeloo" wrote:

Thanks to saruman576 at http://www.mrexcel.com/forum/showthread.php?t=74144

To find a merged cell in Excel 2003.

1. Open a Find and Replace Menu.
2. Next to the Find What Field is a Format Box, Click it.
3. This opens the Find Format Menu screen which looks very similar to the
Cell Format Tabs and screens
4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit
boxes.
5. Leave a tick in the Merge Cells Box and click the OK Button to return to
the Find and Replace screen.
6. Now click the Find All Button and ALL merged cells are shown in the lower
window and are selectable to jump to their location.


-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"KarenB" wrote:


How do I locate merged cells in my Excel worksheet? I am receiving an error
messages when I try to sort the worksheet which tells me to either unmerge
all the merged cells or merge all cells to be the same size as the largest
merged cell. I there some way to identify the merged cells?
--
Organ Donors Save Lives

How do I locate merged cells in my Excel worksheet?
 

Glad I could help.

Thanks for your feedback.

"KarenB" wrote:

Thank you very much! It worked like a charm and I will waste no more time
trying to find a solution via Excel Help. Thanks a bunch and have a great
day. :-)
--
KarenB
Organ Donors Save Lives


"Sheeloo" wrote:

Thanks to saruman576 at http://www.mrexcel.com/forum/showthread.php?t=74144

To find a merged cell in Excel 2003.

1. Open a Find and Replace Menu.
2. Next to the Find What Field is a Format Box, Click it.
3. This opens the Find Format Menu screen which looks very similar to the
Cell Format Tabs and screens
4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit
boxes.
5. Leave a tick in the Merge Cells Box and click the OK Button to return to
the Find and Replace screen.
6. Now click the Find All Button and ALL merged cells are shown in the lower
window and are selectable to jump to their location.


-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"KarenB" wrote:


How do I locate merged cells in my Excel worksheet? I am receiving an error
messages when I try to sort the worksheet which tells me to either unmerge
all the merged cells or merge all cells to be the same size as the largest
merged cell. I there some way to identify the merged cells?
--
Organ Donors Save Lives