Fix Gray Blank Areas and Display Problems in Excel 2016
Question details
The user needs to resolve gray or partially blank areas in Excel 2016 and check why recent workbooks may be missing.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Viewing or working with spreadsheets in Excel 2016 and accessing recently used workbooks.
- Observed behavior
- Excel can show gray areas or partially blank screens; recent workbooks may also be missing from its taskbar list.
Open Excel and check whether the gray areas appear in more than one workbook. Note whether recent files are missing inside Excel, from its taskbar list, or both, since that may be a separate issue.
Disable hardware graphics acceleration in Excel 2016
Use this setting first if Excel displays gray areas or portions of its window appear blank.
In Excel, select File > Options > Advanced.
Under Display, select Disable hardware graphics acceleration, then click OK.
Close and reopen Excel, then open a workbook to check whether the blank areas persist.

Update display drivers and Office, then repair Office if needed
Try updates and repair when changing the graphics setting does not resolve the display problem.
Check Excel recent-file and taskbar settings separately
Use these checks if the spreadsheet display is stable but recent workbooks are still missing.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheets for a straightforward move between office applications; it does not repair Excel 2016.

Frequently Asked Questions
Where is the hardware graphics acceleration setting in Excel 2016?
Select File > Options > Advanced, then look under Display for Disable hardware graphics acceleration. Select it, click OK, and reopen Excel.
What should I try if disabling graphics acceleration does not fix the gray areas?
Update the display adapter driver in Device Manager, check Office updates under File > Account > Update Options, and restart the computer. If the issue remains, use the Office repair option from the installed programs list.
Why are recent workbooks missing from Excel?
The recent-workbook count may be set to zero. Check File > Options > Advanced > Display and set Show this number of Recent Workbooks to a number greater than zero.
Why do recent files appear in Excel but not on its taskbar list?
The taskbar Jump List is controlled separately. Check Windows Settings > Personalization > Start for the option to show recently opened items in Jump Lists, if available.
Can WPS Office repair the Excel 2016 display problem?
No. WPS Office is a separate application that can open compatible Excel workbooks, but Excel’s display settings, updates, and installation must be fixed in Microsoft Office or the operating system.




