Excerpt from http://www.exceltip.com/st/Sorting_R...cture/245.html

"Do not select a column or a row in a List before sorting; instead, select only a single cell. Clicking the Sort icon automatically sorts the entire List and the data will be sorted according to the selected cell's field."

Looks like only a single cell should be highlighted when it is a *List*. Interesting!

Anyone wants to shed some light on this?

Also, from the link: "Be careful when sorting data if there are formulas in the cells........"

Epinn

"galimi" wrote in message ...
Lisa,

You need to highlight the entire range when sorting.
--
http://HelpExcel.com




"Lisa H" wrote:

I have 3 columns that Iwant to sort and two have formulas that are linked to
other cells in the same worksheet. Every time I select the cells I want to
sort, my formulas do not stay with the original cell. Here is an example of
what I have:

Alissa 2 $100000.00

I need this information to stay together no matter what, formulas and all.

Please Help!