Excel ‘Sort Assending’ help

Question

I have a spreadsheet used daily that’s developed an error.

I input data which needs to be sort assessed by date. This used to work Fine however now, when I sort the data it poses half the information in the top Column up one line (out of my table) which then puts everything out of sync.

How do I stop this ?

column A - frozen and will sort correctly

The data in row 9 has shunted up (should remain in row 10)

Row 8 and 9 should be blank

Thanks

Answer 1

Hi thanks

I’m use a mobile device most often but opening it on laptop (via cloud) has the same issue.

Unfreezing column A does not fix the problem.

The sheet is part of a more comprehensive spreadsheet that runs foR a whole year. I cannot copy and paste into a new sheet every time the issue populates as I risk causing errors further down the line, plus I cannot do that every for every month. I need to fix the problem.

Scaling all parts of the spreadsheet also did not resolve the issue

TIA

Answer 2

Hi, MichTal

Thank you for using Microsoft products and posting them to the community.

Are you on a mobile device or a computer-based file?

Try unfreezing and then re-sorting to see if the problem persists?

If it's easier, create a new file and copy the contents of your file into the new one and see if the problem persists?

It's also likely a display issue, try displaying all rows normally without scaling.

Looking forward to your reply.

I hope the above information can help you. Feel free to send a message if you need further help.

Best wishes

Aiden.C - MSFT |Microsoft Community Support Specialist