Excel Training

Hide and unhide feature in Excel

The hide and unhide feature feature in Excel is very useful . We may wish to hide unnecessary data from the user, particularly the data that is of no use to her or occupies many columns and makes the sheet look big. In the application that has a combo button, spinner button and a scroll bar to change the data automatically in the relevant cells, we can hide data columns to make our Excel sheet look more professional. In our Excel worksheet we select the columns and then right click to get a menu and then select hide. Or, you can select the columns first, then click on 'format' in the menu bar, select 'column' and finally click on 'hide'. You can hide Excel rows in a similar fashion. To 'unhide' the columns or rows you select a column or row on either side of the hidden cells (indicated by a thick line), right click and then unhide the Excel data.
The training video demonstrates how to implement the hide and unhide feature in Excel.
 
hide unhide feature excel hide feature excel
Excel worksheet before hiding the data
Excel worksheet after hiding the data
 



Further Reading
Hide Unhide feature in Excel