What should I do if the blank space in Excel does not display the content? How to solve the problem of grid lines not showing when opening Excel?

Problem: Excel opens blank and grid lines are not displayed. When encountering this situation, many users are confused and don’t know how to deal with it. In order to solve this problem, PHP editor Baicao specially prepared a detailed tutorial. This tutorial will guide you step by step to resolve the issue and get your Excel back to displaying content normally.

1. First open the Excel document and stay on the start page. At this time, you can see that there is neither grid lines nor information displayed.

2. Then find the view in the upper toolbar, click and enter.

3. The tools under the view are divided into many sections. You can see that they are all gray at this time, indicating that we have found the crux. Then click on the word window of unhide.

4. A window will pop up, choose to unhide the workbook (U): Workbook 1, if your workbook has another name, select the one corresponding to the name Just file. Finally click OK below.

5. Return to the main page and you will see that the original data has become visible. After exiting the excel program, the unhidden settings will be saved forever. So there is no need to repeat the operation the next time you open it.

If the above method cannot solve the problem of blank form, then it involves a more complicated registry problem. To solve this situation, you need:

1. Press and hold the Win+R keys on the keyboard, open the manager run, enter regedit, and press Enter to confirm.

2. Find HKEY_CLASSES_ROOTExcel.Sheet.12shellOpencommand according to the index and double-click to open the default value.

3. Original value: C: Program FilesMicrosoft OfficeRootOffice16EXCEL.EXE; increase %1: C: Program FilesMicrosoft OfficeRootOffice16EXCEL.EXE %1. Just save it. If /dde is deleted, the table display can be successfully restored.

The above is the detailed content of What should I do if the blank space in Excel does not display the content? How to solve the problem of grid lines not showing when opening Excel?. For more information, please follow other related articles on the PHP Chinese website!