How to Hide Cells in MS Excel?

How to Hide Cells in MS

Have a spreadsheet full of data? There may be times when we’d desperately need to conceal certain entries or contents amongst the available data. This can be due to some calculations being carried out in that portion or irrelevancy of interest towards the data that is needed to be looked into. So, knowing of a way to subtly hide them is in order. We shall cover such ways available to hide cells when working on MS Excel in this article.

Listed here are the different ways of having it done.

  1. Using the Keyboard Shortcut
  2. Using the Home Tab
  3. The Old-School Right Click

We would be trying to hide the contents of the following table using each of the above-listed methods.

Sample Table 6
A Sample list of Data

1. Using a Keyboard Shortcut

Let’s say we would like to hide the contents of Company F in rows numbers 7 & 8. First things first, we would select these cells which we need to hide as shown in the below image.

Selecting the Rows to Hide
Selecting the Cells to Hide

After this, we would be pressing the CTRL key followed by the number key ‘9’ (CTRL+9). The key here is to press the keys one after the other and NOT SIMULTANEOUSLY! Once done, the selected cells would be successfully hidden as shown below.

Hidden Rows
The Cells get Hid!

2. Using the Home Tab

The first step remains the same as in the above image, which is to select the cells that need to be hidden. We shall stick to the same cells belonging to row numbers 7 & 8 in this case. Once done, look out for the Format option in the Home tab.

Locating Format Option
Locating the Format Option

Click on Format and it shall display a list of options to choose from, but our interest here is to navigate to the Hide & Unhide option.

Hide Unhide Option
Locating the Hide & Unhide Option

The Hide & Unhide option in turn has within itself, a list of options to choose from. Now, it is time to click on that Hide Rows option as shown below.

Choosing Hide Rows Option
Choosing Hide Rows Option

The selected contents get hidden the very moment, the Hide Rows option is clicked.

Hidden Rows 1
The Hidden Selected Cells

3. The Old-School Right Click

In this method, the first step is a bit different and requires a bit more than selecting the cells that are required to be hidden.

Now it is all in the mouse (for the laptop users, it’s in the mouse-pad too!) to make these selected entries hidden. Hover the cursor over the row number of the cells that are to be hidden and click that row number using your left mouse button.

Selecting a Row 1
Selecting a Set of Cells

Now without lifting that finger off the left mouse button drag it one step below to select the next row number which is, Row 8 in this case.

Extending the Selection 1
Extending the Selection

Now hover the cursor over the selected row numbers and click using the right mouse button over that space. Once done, a pallet containing a list of options to choose from appears.

Right Click Pallet
The Right Click Pallet

Our interest here is to select the Hide Option, in the right-click panel. Selecting that option would make the chosen cells are hidden in no time.

Hidden Rows 2
And the Cells are Hidden!


Now that we’ve covered 3 different ways to hide the cells in MS Excel, hope it would come in handy when you face a situation of need. This article has predominantly dealt with hiding the cells across (i.e) horizontally in an active worksheet. But, there shall also arise a need to hide the cells vertically (i.e) alongside the columns in an active worksheet. That being said, check out this article, if you want to hide columns in an Excel sheet.

Do watch out for our space, QuickExcel to keep yourself updated with MS Excel. Cheers!