In Excel, row and column headers are very convenient helping view and reference data, if disappeared and you want them back, please follow the steps below.
Step 1: Click the "File" Tab from the ribbon;
Step 2: Click "Options" from the left navigation menu;
Step 3: Click "Advanced" from the left navigation menu in the dialog box;
Step 4: Check "Show row and column headers" under the section of "Display options for this worksheet";
Step 5: Click "OK" at the bottom.