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




  1. select a row(or a range of rows).
  2. Right click on it.
  3. Picture showing the hide option in context menu for hiding the row

    Click to Enlarge

  4. Click on ‘Hide’.


Picture showing the set the records after rows are hidden

Click to Enlarge


Unhide Row In An Excel




  1. Select one row above and one row below the range of cells (which are hidden). For example to unhide row from 4 to 6, select row from 3 to 7.
  2. Right click on the selected range and click on ‘Unhide’
  3. 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