Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Valser
 
Posts: n/a
Default Does font color affect sorting a list in Excel?

None of the Help links answered my question. I need to know if using font
colors prevents me from alphabetizing a list.
My Excel spreadsheet, which is a list of names and addresses, uses several
different colors of font (as a code), and suddenly will not "sort" using Data
- Sort by - Then by (as it always has done with no problem.) Does font color
affect the ability to sort by alphabet in a chosen column?

  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

No not at all. Indeed, if you want to sort by colour, it requires some extra
work.

What exactly happens, and are you sure it is not already sorted? Show us
some data, and describe exactly what you did.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Valser" wrote in message
...
None of the Help links answered my question. I need to know if using font
colors prevents me from alphabetizing a list.
My Excel spreadsheet, which is a list of names and addresses, uses several
different colors of font (as a code), and suddenly will not "sort" using

Data
- Sort by - Then by (as it always has done with no problem.) Does font

color
affect the ability to sort by alphabet in a chosen column?



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Valser

Font color will not affect the alphabetic sorting of a list.

Color, whether it be font or background, is a Format only and does not affect
the underlying value of the data in cells.


Gord Dibben Excel MVP

On Sun, 27 Feb 2005 10:09:03 -0800, Valser
wrote:

None of the Help links answered my question. I need to know if using font
colors prevents me from alphabetizing a list.
My Excel spreadsheet, which is a list of names and addresses, uses several
different colors of font (as a code), and suddenly will not "sort" using Data
- Sort by - Then by (as it always has done with no problem.) Does font color
affect the ability to sort by alphabet in a chosen column?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a cascading list box using Excel JPB Excel Discussion (Misc queries) 1 February 24th 05 09:43 PM
How do I enlarge font in a drop-down list in EXCEL? Stan Excel Discussion (Misc queries) 2 February 21st 05 11:30 PM
how to alphabetize a list in Excel DJ Somers Excel Worksheet Functions 4 January 1st 05 04:39 AM
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 05:07 PM
how to increase the font size in a dropdown list? Sossys Excel Worksheet Functions 2 December 16th 04 02:09 PM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"