1] Use the Clear Formats option to remove formatting in Excel The first and easiest method to clear formatting in your Excel workbook is to use the Clear Formats option. It is available on your ribbon ...
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.