Hiding – Unhiding a Rows or Columns in Excel 2010


While working on Microsoft Excel, many a time, it happens that you want to remove a row but you do not want to delete it permanently. We can hide the rows and then to use we can unhide the rows in Microsoft Excel.

In excel 2010, there are two ways to hide or unhide rows in excel. You can use the keyboard or the mouse for these actions. Both the processes are given below and these steps will make it easier for you to understand do your work faster.

How to hide the rows?

Hiding rows using mouse:-

  • Select the entire rows which you want to hide
  • Right click on the selected rows
  • Click on hide
  • The selected rows will be hidden from the file view




How to unhide Excel rows?

Unhiding rows in Excel using mouse:-

  • Select the row above and below the hidden row(s)
  • Right click on the selected row(s)
  • Click on unhide
  • The row in between the selected rows will be visible again in the worksheet.




Hiding rows using keyboard:-

  • Select the entire row which you want to hide
  • Press CTRL+9
  • Selected row will be hidden from the view




Unhiding rows using keyboard:- 1

  • Select the cells containing the range of the hidden row(s)
  • Press CTRL + Shift + 9
  • Select the rows visible in the file


In this way we can unhide cells in excel.

Leave a Reply

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


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>