How to hide or unhide rows & columns in Excel

- Advertisment -
- Advertisement -

Microsoft Excel’s  Spreadsheets comes with hundred of features those are very useful to manage large amount of data in the rows and columns of this office program. Here are not going to its introduction as everybody know about Excel, instead, we will explain how to use hide and unhide rows or columns feature in Excel.

Now, where this feature would be useful, it solely depends on person why he or she wants to use rows or columns hiding feature of Excel, however, generally, if we don’t want to show some information to other or want to hide some data or figures, this will be handy.  This tutorial work on almost all active or working versions of Microsoft Office Excel programs such as Excel 2007, 2010, 2016, 2017, 2019 or Office 365.

First, we see the process of hiding any rows or columns:

Hide or Unhide a complete Row in Excel

  1. Open Microsoft Excel Software.
  2. Import the Sheet which wants to use. If you already on that move to the next step.
  3. On your Excel to hide any complete row, go to it and right-click on top of it where the serial number series is given such as A, B, C, D and so on. See the screenshot for reference.
  4. Now a pop-up menu will open, at the lower side you will find an option “Hide” select that. You can also use a keyboard shortcut to hide rows that is- Ctrl + 0 (zero). Just select the row and use it.
  5. This will hide the selected complete row.
  6. Now to unhide the row which you have hidden, use mouse pointer and highlight the left and right side of the hidden one and then right-click.
  7. There you will see an option unhide, select that and you will get your row back.

See the Screenshots for more info:

Just right click on top of the row and select the Hide option. Ctrl+0 (zero) is a shortcut.

Hide rows on Microsoft Excel

To unhide a row, use your mouse click on left row drag your mouse towards the right row of the hidden one. Now, right on it and select the unhide option. That’s it.

Unhide Rows in microsoft Excel sheets

Hide or Unhide a complete Column in Excel

  1. Go to the Excel sheet where you want to hide a column in Excel.
  2. Select the entire column.
  3. Right-click on it.
  4. Select hide option or you can use shortcut key Ctrl+9 to hide the column.
  5. To unhide just like we did for rows, select and highlight the upper and lower column of the hidden one and right to select unhide option. If you want to use a keyboard shortcut to unhide column then after highlighting press Ctrl+Shift+9.
  6. For more info see the below two screenshots.

Hide entire column, select, right-click and hide.

Hide entire column on Excel

To unhide the entire column, highlight the upper and lower column, for example in the above screenshot we hid 12th number column and to get it back we use mouse pointer for highlighting above and lower ones and after that, we will right-click on it to select the unhide option or use keyboard shortcut Ctrl+Shift+9.

unhide column in Excel microsoft office

Unhide all columns and rows in excel

To unhide all hidden columns in any Excel sheets, go to the top left corner of your sheet area and click on + icon to select the whole sheet or alternatively you can use Ctrl+A shortcut. After that press, Ctrl+Shift+9 buttons simultaneously from the keyboard or just right-click anywhere on sheet and select unhide.

And for unhiding all rows at once, after selecting the whole sheet, right-click on the top area of the rows where the serial numbers are given (A, B, C..) and select unhide.

unhide all columns or rows

Other Excel Articles:


H2S Media Team
H2S is a group of tech enthusiasts those are passionate about latest technology developments. They always like to solve own technical problems and share the same solution with others through this Website.


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Posts

Harmano launches Air Flex Pro Foldable TWS Bluetooth earphones

Harmano, that deals in audio products recently has announced its Neckband earphones "Air Flex Pro" which provides protection Sweatproof...

How to rearrange the Chrome Duet menu on Chrome 80 for Android

If Google Chrome is the browser of your choice on Android, you might have experienced the new Chrome-Duet menu...

How to set different default folders for Downloads & Media files on Windows

When we start using our Windows computer the default folder for storing the Downloads, Documents, Pictures, Videos, and everything...

How to install Ubuntu Cinnamon Remix 19.10 on Virtual box or PC

The Ubuntu distribution of Linux doesn’t need an introduction, and it is the favourite Linux distribution of many users,...
- Advertisement -

How to open 4 or more than 4 Windows Explorer locations on PC

When we use our computers running Windows, copying and moving files from one location to the other is something...

Top 5 Classic games that you should download on your Android mobile

Thanks to the powerful Android phones that we have in our hands in 2020, we can run a lot...

- Advertisment -
- Advertisement -

You might also likeRELATED
Recommended to you