Results 1 to 6 of 6

Sorting information with Color Cells Microsoft Excel 2003

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2009
    Location
    Michael
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile Sorting information with Color Cells Microsoft Excel 2003

    Hello Everybody,

    I am using Microsoft Excel 2003.

    I put color in my cells to show contrast with the information in my data list. I used blue and white for my cell colors. When I used sort to put my information in alphabetical order it did not only rearrange the information, it also rearranged the colored cells. My orginal pattern (before using sort) was blue, white, blue, white, blue, white. After I used sort, the pattern was changed to white, white, blue, white, blue, blue.

    Is there any way I can use sort to arrange my information only in alphabetical order, using sort, without rearranging the color of the cells?

    If anybody knows, please answer and thank you in advance.
    Last edited by Page001; 12-09-2009 at 10:01 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1