Hi Epinn

Firstly, I would not regard this source of information as in any way the
definitive answer.

However, If you have used
InsertTable from XL2007 or
DataList from XL2003,
then indeed if you do select any cell within the List and click sort, it
will sort the whole table according to the values of the column
containing that cell.

--
Regards

Roger Govier


"Epinn" wrote in message
...
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!