With
A1:D100
And the information in cells B1:D100 pertain to their respective values in
Col_A

Before sorting A1:A100....Select A1:D100

If you will sort using one of the [sort] buttons..make sure a cell in Col_A
is the active cell, then click the [sort] button

Or
You can use the Excel menu
<data<sort
Select the column to sort on
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Michaela" wrote:

In Exel; is there a way to sort Column A and have the information in each row
follow the change?
For example: A5 has 4567 in Column A, with information about 4567 in
different columns but on the same row.
However, when I enter 3456 in Column A, it sorts by number (which I want it
to do), but it leaves the information about 4567 in that row. I need the
information to correspond with the number in Column A.
Does anyone know how to correct this problem?