Summary:MS Excel is a program which helps users to import and format data to design and create spreadsheets, charts, graphs, and perform numerous functions. Users can work with functions and formulae available in the application. However, changing the file properties and formatting of rows and columns, may occasionally result in data to disappear in Excel. Find out the reasons for data disappearance and the solutions on how to retrieve that data.

• Excel File Disappears
• Excel Text Disappears When Scrolling
• Excel Text Disappears
• Excel Text Disappears When Printing
• Excel Text Disappears When Word Wrap Is Used
• Toolbar On Excel Disappears

Whether you are a Business Analyst, Marketing Manager or a Teacher, MS Excel lets you organize, interpret data more clearly and thus prepares you for vital scenarios and changes through calculated forecast but this forecast may not be as reliable if even a small portion of data disappears or erased from the Excel spreadsheet/cell.

The probable reasons of data disappearing in MS Excel are:

1. Unsaved work
   Most Excel users forget to save their file at regular intervals, while they are working on their spreadsheet. As a result, if you close the workbook after entering some valuable information and then click on ‘No’ button when the popup displays the message to save the file, then MS Excel file may be saved without the recently added information, and the unsaved data disappears from the spreadsheet. Though Excel sheet has a time-setter to save the information, automatically, if the time setter is set at the lower time, the unsaved data is lost.
2. Format Conversion
   Microsoft provides an option to save an Excel file in various formats – spreadsheet, text, webpage and more. At times, saving the spreadsheet in a different format may lead to missing data. For example, keeping the spreadsheet into basic text results in the disappearance of all the formulae and calculations applied on the data. In such cases, remove all calculations before saving the file. If the sheet is shared on multiple computers, then save the file in compatibility mode.

3. Merging Cells
   Two or more cell-data is combined to make one large cell. This technique is primarily used with the Title of the spreadsheet. If there is data in two or more cells, then only the data in the top left cell is displayed, and data in all other cells are deleted. If the other merged cells have been populated with data then after merging, this data is not featured and it does not appear even after remerging the cells.

Select the cells you need to keep leading zeroes of input numbers, then click Home Number Format drop-down icon Text. You can enter your text in the Left section, Center section, or Right section, depending on where in the header or footer you want the text to display. Here’s the trick. When you type your ampersand, type two of them, one right after the other, as shown in the following image.

Excel File Disappears

4. Cell Formatting
   Cells and Data in the cells can be displayed in different colours to make the spreadsheet simple to create and infer. You may experience data loss when you try to change the data also along with changing the colour of data. Though the information may exist, the data may show an error due to following reasons:
   • White coloured text will not show in white coloured cell
   • Large font sized data may not appear in small-sized cell
   • Calculations may show error after cell-formatting

Excel Text Disappears When Scrolling

As discussed earlier, Excel files are essential for the professionals. Hence the recovery of these files is a must. Microsoft has provided an option to repair the Excel files with the help of Excel repair option. Follow the steps to fix Excel file:

1. Reboot the system – Before starting with repair function, it is mandatory to reboot the system as rebooting ensures that any file used by the system is fully released.
2. Go to Control Panel and click on Programs and Settings
3. Locate Office and right click on it. Click on Change from the available options.
4. Repair option is displayed –Click on Repair option to repair MS Excel file
5. Open MS Excel to check if the data is fixed.
6. Still unable to resolve the issue? Re-install MS Office on your system, but take care that re-installing will not repair the current Excel file and hence you cannot retrieve the disappeared data from that file.

If the above steps do not resolve the problem, opt for an Excel repair tool like Stellar Repair for Excel. This software has a proven track record of repairing the corrupt or damaged Excel files to recover disappeared excel sheet content.

Excel Text Disappears

Software with 100% integrity and precision

The software helps in:

• Fixes all corruption errors – a prominent reason to use this software. It helps in getting back the data which has disappeared.
• Repairs a single as well as multiple Excel files
• Recovers all components of XLS/XLSX files – tables, chart sheet, cell comment, image and more
• Does not hamper the worksheet properties and cell formatting
• Supports the latest as well as earlier version

Excel Repair software repairs the Excel file in these simple steps

• Launch and open the software.
• Select the corrupt Excel file. If the file location is not available, then find the Excel file by clicking on Search option.

• Click on Repair to scan the corrupt file.

• Once the scanning is complete, verify the components of Excel file and check if the available preview shows complete data that disappeared from Excel.

• Save file at default location or preferred location.

After scanning and repairing, the professional software creates a new file and provides an option to save this new Excel file in the default location or preferred location.

Conclusion

Better to repair than suffer the loss when data or text disappears in Excel and professional software ensures that users get back all the data in the form of a new Excel file. Stellar Repair for Excel tool repairs the corrupt file without modifying the original content and file-format. The user interface lets you perform the functions without a formal software training and ensures that even the non-technical computer users can use this software.

How to show drop down list’s disappeared arrows again in Excel?

In some cases, the arrow of drop down list is disappeared in Excel, even you click at the drop down list cell, which means that you cannot show the drop down list if the arrow disappears as below screenshot shown. This article, will give you a trick may do you a favor.

Show drop down list’s disappeared arrow again with one option-checked

In some cases, the arrow of drop down list disappears because the option called In-cell dropdown is not checked.

1. Select the drop down list cells and click Data > Data Validation. See screenshot:

Excel Text Disappears When Printing

2. In the Data Validation dialog, under Settings tab, go to check In-cell dropdown option. See screenshot:

3. Clock OK to close dialog, and you can see the arrow of drop down list has been shown.

Excel Text Disappears When Word Wrap Is Used

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Toolbar On Excel Disappears