Forum Discussion
No text or data showing in my cells....
Everything I type whether it be words or numbers will not appear in the cell. I can highlight, tab and hit enter to move cells but it won't take any data. Please help.
First, type a value into a cell and look at the formula bar above the worksheet. If the value appears there but not in the cell, the data was entered and the problem is formatting. Select the affected cells, set the font color to Automatic or Black, change the number format to General, then use Home > Clear > Clear Formats.
If nothing appears in either the cell or the formula bar, check whether the sheet is protected under Review > Unprotect Sheet. Also test in a new blank workbook. If the same problem happens there, close and reopen Excel; if it continues, start Excel in Safe Mode to check whether an add-in is interfering.