November 25, 2020

How to Hide/Unhide headings in Excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *