Headings (numeric for rows and alphabetic for columns) in Excel worksheets make it easy to view and reference data. However, in some cases the headings are distracting, and then it would be more convenient to hide them. Hiding titles is very easy, and you will soon learn how to do it.
Open the Excel workbook that contains the sheet we need and select it. To select a sheet, click on the appropriate tab at the bottom of the window. However, this is not required. Below you will find out why.
Click the File (Queue).
In the menu on the left, click Parameters (Options).
On the left side of the dialog box Excel options (Excel Options) click Additionally (Advanced).
Scroll to group Sheet display options (Display options for this worksheet). If you have already opened the sheet on which you want to hide the headers, then its name will be displayed in the drop-down list to the right of the parameter group header. If not, select the desired sheet in this drop-down list.
Note: The drop-down list lists all sheets of all currently open Excel workbooks. You can select any sheet of any open workbook.
Uncheck the option Show row and column headers (Show row and column headers).
Press OKto save changes and close the dialog Excel options (Excel Options).
The row and column headings on the selected sheet will be hidden. If you switch to another sheet, then the row and column headings will be visible on it. You can only hide headers on one sheet at a time. It is not possible to hide headings on all sheets at once.
Note that Excel cannot hide or show only row headers or only column headers. Both are either shown or hidden at the same time.
In addition, Excel can hide notes, formulas, out-of-bounds text, gridlines, worksheet tabs, sheets themselves, and even entire workbooks.