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: 8,945   +584

    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

Create an account or login to comment

You need to be a member in order to leave a comment
TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...

Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.