excel is taking a long time to sort my speadsheet based on highlighted cell

jonathan wagner 21 Reputation points

I have a list of names numbers and addresses that I will trying to sort based on the phone number. I have been highlighting the duplicate numbers and then sorting the sheet by highlighted cell . When I do this it is taking almost an hour to sort 50k lines of data . How can i speed this up. Computer has 16gig of ram.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,362 questions
No comments
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 11,566 Reputation points Microsoft Vendor

    Hi @jonathan wagner ,
    Did your Workbook contain cell formats or formulas?
    I suggest you try these methods:

    1. Change Calculation mode to manually, go to Formula tab- Calculation Options- select Manual:
    2. Select all cells (Ctrl + A), go to Home tab- Editing- Clear- Clear Formats:
      Try these methods and just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful