Excel: Sorting with Formula

By Dataslycer
Sep 2, 2006
  1. I'm working with an excel document and I am having trouble with the sorting function since I have formulas within my data. Whe I use the sort function, the reference cell does not shift to the new position as it normally woud when you use copy or cut command. Is there a way to get around this?
  2. korrupt

    korrupt TS Rookie Posts: 716

    You sure youre sorting down and not across?


  3. jobeard

    jobeard TS Ambassador Posts: 9,158   +599

    YEP! a real bummer! (my Office 2000 at least). seems like it would have been so obvious that this needed to work, but I've never got it right in several years now :(
  4. Dataslycer

    Dataslycer TS Rookie Topic Starter Posts: 31

    As far as I know. What I do is select the spreadsheet cells that contains data and click sort ascending. Here is the screenshot
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...