#1
|
|||
|
|||
Sort problem
When I attempt to sort a range of cells I get the message 'This operation requires the merged cells to be identically sized'. Is there a function to find the merged cells, my range is 400 x 25. |
#2
|
|||
|
|||
Hi,
(note: Commands etc translated from Swedish and might not correspond to 100% to your English text) Solution 1. the easiest way is to mark all cells (25x400), then select menu Format/cells. Select the second tab from the left ("Adjustment" or somehting like that). Under "Text control", uncheck the (probably grey) checkbox called "Merge cells". Now there shouldn't be any more megred cells. Solution 2. If you want to find them and keep them, there is a way of finding them by conditional formating (using the function Column() or Row() to paint either every second line or every second row in different colour). Tell me if solution 1 doesn't work and you need help with details for solution 2. Kind regards Bjorn |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort by Date in Email | lancerocke | Outlook | 0 | 01-28-2010 08:15 PM |
MS Outlook 2002 Address Book Sort Problem.... | blizzster | Outlook | 0 | 07-30-2009 07:52 AM |
Sort Macros | boutells | Excel | 1 | 07-16-2009 11:48 AM |
Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |
Sort By Last Name in a List | eliz.bell | Word | 8 | 05-07-2009 01:33 PM |