Articles → EXCEL → Hide and unhide rows and columns in excel

Hide and unhide rows and columns in excel




















Prerequisite











Open a new excel





Add data in excel




Picture showing the sample excel file with records

Click to Enlarge


Hide row in an excel








Picture showing the hide option in context menu for hiding the row

Click to Enlarge





Picture showing the set the records after rows are hidden

Click to Enlarge


Unhide row in an excel








Picture showing the hide option in context menu for unhiding the row

Click to Enlarge


Hide and unhide column in an excel





Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, June 11, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250