how do i prevent data from being changed when i sort excel column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

world's - 17 Mar 2006 23:10 GMT

I have been using excel to import data but when i try to sort columns some of
the information changes how can i prevent the information from changing?

Reply to this Message

David McRitchie - 17 Mar 2006 23:24 GMT

If you really want help, you would describe exactly what your problem is.

You have to select all cells on the sheet if you sort on a column and want
the information on the row to remain with the row at a new location.

If you have formulas that refer to the row above, then you want to use
OFFSET in your formula see
http://www.mvps.org/dmcritchie/excel/offset.htm

Shading of cells will travel with the data, but border formatting will not.

You would get a lot more out of newsgroups by using your name, especially
in technical newsgroups.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I have been using excel to import data but when i try to sort columns some of
> the information changes how can i prevent the information from changing?

Reply to this Message