View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JethroUK© JethroUK© is offline
external usenet poster
 
Posts: 49
Default how do i sort rows and maintain cell references

dont use the sort icons

you must select the whole block of data

choose sortdata

choose the column to sort by


"tfb" wrote in message
...
| sounds like a simple task but i can't get it! i want to sort selected
rows
| of a worksheet using an alpha sort of, say, clm "c". how do i maintain
the
| original references in clm "a"?