Have you tried each and every possible method?? still not working?? let excel to repair the sheet now.
The worksheet may be corrupted. Try copying the data to a new worksheet or workbook, and the dropdown arrows may reappear.
Or, try to repair the file as you open it:
- In Excel, choose File | Open
- Select the file with the missing data validation arrows
- On the Open button, click the arrow
- Click Open and Repair
- When prompted, click Repair.