Hiding – Unhiding a Rows or Columns in Excel 2010

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-keyboard-shortcuts/hiding-or-unhiding-a-column-or-columns-in-microsoft-excel.html
SHARE




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

 

image1

 

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.

 

image2

 

Hiding rows using keyboard:-

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

 

image3

 

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

image4

In this way we can unhide cells in excel.

Please follow and like us:
0


Leave a Reply

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

To avoid automated spam,Please enter the value *

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>