Let’s say we have the below table in an excel worksheet. Here we need to hide the row & column headers.Below are the row and column headings.
To hide/unhide the headings go to ‘View’ tab and in ‘Show’ group, uncheck ‘Headings’ checkbox. See both row and column headings have been disappeared.
Now to display those back again select the same ‘Headings’ checkbox in ‘Show’ group of ‘view’ tab. See below the row and column headers reappeared.