Fix Missing Data Validation Arrows in Excel Spreadsheet Issue
Microsoft Excel is one of the most popular and widely accepted application used to store, calculate, record and maintain data. You can easily create graph, charts, pivot tables and many others. Many of while entering information or data in a spreadsheet you go through the situations when you are required to enter same data in the cells of workbook. On that particular time, validation of data becomes convenient. In respect of entering the same things repeatedly, you can make a drop-down lists in Excel cells. By this method only you need to select the part from the list drag it on the succeeding cell.
By adding drop down lists for data validation to the Excel workbook, you can enter the data with ease. When you try to access the an Excel spreadsheet again, you might experience that data validation arrows are missing. There are many causes that could start from items being concealed to the corruption in workbook. However, the many of the causes can be resolved by some modifications in the Excel settings, but in the scenario of Excel workbook corruption, you are required to go for alternative solution to repair Excel files completely.
This significant issue comes out in the situations when your spreadsheet contains some other shapes including text boxes, logos, charts and you enabled a setting to make them invisible and as they are objects so the drop down arrows will also not be visible. It is also possible that you have disabled the default drop down list option. In order to make the Excel sheet items not hidden, you can go through the steps mentioned below:
- Click - Office Button, then go Excel Options
- Click -Advanced Category
- Go down to the section of 'Display Options for This Workbook'
- Within 'For Objects, Show', select All, click -OK
You can also copy data to the new Excel spreadsheet, it is likely possible that data validation arrows appear again. You can use Excel file Open and Repair option. After going through these all manual steps, if you are still getting the same issue of missing data validation arrows in Excel spreadsheet, lastly make use of third party excel repair software. This Excel repair utility is incorporated with the advanced algorithm that scans the Windows hard drive thoroughly to repair and recover any logically damaged Excel file irrespective to the reasons.