Excel: Sorting with Formula

By Dataslycer
Sep 2, 2006
Topic Status:
Not open for further replies.
  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 Newcomer, in training Posts: 1,060

    You sure youre sorting down and not across?

    Regards,

    Korrupt
  3. jobeard

    jobeard TS Ambassador Posts: 13,029   +222

    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 Newcomer, in training Topic Starter Posts: 48

    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.


Add New 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.