Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-16-2011, 12:46 AM
jaz jaz is offline Excel sort problem Mac OS X Excel sort problem Microsoft Office 2008 for Mac
Novice
Excel sort problem
 
Join Date: Jan 2011
Location: Blue Mountains near Sydney
Posts: 3
jaz is on a distinguished road
Default

Me again, problem solved; thanks to Bjorn in an old post where he is helping someone else with a similar problem. Here's the cut and paste from that post:

Quote:
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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel sort problem Sort problem Cpat Excel 1 09-19-2010 03:08 AM
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
Excel sort problem Sort By Last Name in a List eliz.bell Word 8 05-07-2009 01:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft