Excel shortcuts

How to hide cells in Excel: The complete guide

Hiding cells in Excel is a great way to keep your worksheets clean and organized. But how do you do it? In this article, we'll show you how to hide cells in Excel so that they're not visible to other users.

There are a few different ways to hide cells in Excel. You can hide cells by:

  • Selecting them and then going to the Home tab > Format > Hide & Unhide > Hide Cells
  • Selecting them and then going to the Home tab > Format > Hide & Unhide > Hide & Unhide Rows/Columns
  • Applying a filter
  • Applying a custom view

Let's take a look at each of these methods in more detail.

Method 1: How to hide cells by selecting them and then going to the Home tab > Format > Hide & Unhide > Hide Cells

This is the most common way to hide cells in Excel. To do this, simply:

  1. Select the cells that you want to hide.
  2. Go to the Home tab > Format > Hide & Unhide > Hide Cells.

The cells will then be hidden from view.

Method 2: How to hide cells by selecting them and then going to the Home tab > Format > Hide & Unhide > Hide & Unhide Rows/Columns

This method is similar to the first one, but it allows you to hide entire rows or columns rather than just individual cells. To do this, simply:

  1. Select the cells that you want to hide.
  2. Go to the Home tab > Format > Hide & Unhide > Hide & Unhide Rows/Columns.

The cells will then be hidden from view.

Method 3: How to hide cells by applying a filter

Applying a filter is a great way to hide cells that you don't want to see. To do this, simply:

  1. Select the cells that you want to hide.
  2. Go to the Data tab > Filter.
  3. Click on the filter icon in the column header that you want to filter.
  4. Click on the drop-down arrow and select "Hide".

The cells will then be hidden from view.

Method 4: How to hide cells by applying a custom view

Applying a custom view is a great way to hide cells that you don't want to see. To do this, simply:

  1. Select the cells that you want to hide.
  2. Go to the View tab > Custom Views.
  3. Click on the "Add" button.
  4. In the "Name" field, enter a name for your custom view.
  5. Click on the "OK" button.

The cells will then be hidden from view.

That's it! You now know how to hide cells in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.