when i sort, how can i get the formatting to sort along with text

[Guest]

 

[Gord Dibben]

What type of formatting are you talking about?

Assuming a list of months in column A......January through December with every
third month bold.

Sort alphabetically and the bold months remain bold as they move around.


Gord Dibben MS Excel MVP

On Mon, 11 Sep 2006 06:24:01 -0700, PJ <[email protected]> wrote:

 

[Gord Dibben]

What type of formatting are you talking about?

Assuming a list of months in column A......January through December with every
third month bold.

Sort alphabetically and the bold months remain bold as they move around.


Gord Dibben MS Excel MVP

On Mon, 11 Sep 2006 06:24:01 -0700, PJ <[email protected]> wrote:

 

[Guest]

I guess it would be the cell formatting as opposed to the text formatting;
i.e. shading and borders. I see that the text formatting does hold when
sorting. There are several field types i am sorting; date and time fields
and regular text fields. thank you.