to maintain data consistency, i use formula "=" a reference cell's value. when
sorting by different criteria (headers), the link list in Excel cannot link
cleverly but say, still pointing its above content, how to solve this problemin
Excel?

In Word, copy-format is simply shift-ctrl-c, why excel hasn't supported such a
shortcut? just ask to know anybody can figure out a reason so this is not
asking Microsoft per se

Thanks a lot.