View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
galimi galimi is offline
external usenet poster
 
Posts: 210
Default sorting cells with formulas

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!