How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6403
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now

When sorting an excel spreadsheet by any field it jumbles

Customer Question

when sorting an excel spreadsheet by any field it jumbles the data and makes no sense
Submitted: 8 months ago.
Category: Microsoft Office
Expert:  Jess M. replied 8 months ago.

Hi David, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues. Are you using a Windows computer? What version of Excel are you using?

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Customer: replied 8 months ago.
no I am not using a Windows computer. I am using the 365 version of ExcelRegards David
Expert:  Jess M. replied 8 months ago.

David,

Thank you for writing back with that information. Is this sorting problem happening in a specific file? Or on all excel files that you are working on?

Customer: replied 8 months ago.
Jess The problem seems intermittent some files seem ok the data is similar everyday. Yesterdays file was ok yesterday, I added some more data to some of the rows today and tried to sort by various fields all seemed corrupted. Today's file
was corrupted as soon as I tried to sort. I hope this is usefulDavid
Expert:  Jess M. replied 8 months ago.

David,

Thank you for writing back with that information.

I believe the problem is with your MS Excel program, not on the file. Please boot your Mac computer in Safe Mode, and then test if your Excel sorting problem is gone. Here are the steps in booting into Safe Mode:

  1. Shut down the computer. To do this, click the Apple icon, and then select Shut Down.
  2. Start your computer by pressing the power button.
  3. Immediately after you hear the startup tone, press and hold the Shift key.

    Note Press the Shift key as soon as possible after you hear the startup tone. However, do not press the Shift key before you hear the startup tone.
  4. Release the Shift key when you see the gray Apple and the progress indicator on the screen. The progress indicator resembles a spinning gear. This might take a while (up to two minutes). Wait and do not restart the computer again. During startup, you will see Safe Boot displayed in the login window. (This appears even if you normally log in automatically.)
    1. If Mac OS X is configured to start up to the login screen, log on as the user who is running the Office for Mac software. Otherwise, skip this step.
    2. Immediately press the Shift key. This bypasses any startup items in the StartupItems folder.

When you are in Safe Mode, please test your Excel if sorting problem is gone.

Keep me posted with your results so that I can assist you further.

Best regards,

Jess

Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6403
Experience: Computer Software Specialist for more than 10 years
Jess M. and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 8 months ago.
Jess I am sorry if I misled you on your question regarding my computer I thought you were referring to the maker. In fact it is a PC.I would actually prefer to use the securely connect service so you can deal with what has to be done I need the computer for a few hours, say till 3 oclock today will this be ok ? Also will you tell me what was wrong after it is fixed ? Can you contact me after 3 when you are ready ?
Regards David
Expert:  Jess M. replied 8 months ago.

David,

Thank you for using our Secure Remote Assistance service. Are you available for a remote session now? Or will it be 3 hours from now?

Please let me know so that I can send you the procedures to join me in the remote session.

Best regards,

Jess

Expert:  Jess M. replied 8 months ago.

David,

Yes, you can use your computer now and we can just do the remote session at 3 oclock your time. And yes, after fixing the problem, I can tell you what caused the problem so that it can be prevented to re-occur in the future.

I will just send the procedures later (3 oclock your time) when you are possibly ready for the remote session.

Thank you very much.

Best regards,

Jess

Customer: replied 8 months ago.
JessI have now finished what I needed to do and am now ready for the remote session.
I look forward to hearing from youregards david
Expert:  Jess M. replied 8 months ago.

David,

Thank you for writing back. For me to remote in, we need a remote access tool. Please follow the steps below to join me in the remote session.

1. Please click on this link:
http://www.justanswer.com/remotedesktop/join.aspx?Session=d3105402-b115-45b7-b9b7-053967da9343

2. In that page, please click on the green I Agree button
3. Then download the remote tool when prompted.
4. Run the downloaded remote tool to join me in the remote session. I will be waiting for you there.

Thank you. If you are stuck in any of the steps, please let me know so that I can help you further.

Best regards,
Jess

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Previous | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    241
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    120
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    56
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions