• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Gadgets

How to Hide Cells, Rows and Columns In Excel

By: Waseem Patwegar

In this tutorial, you will be learning the steps to Hide Cells, Columns and Rows in Excel, so that you can prevent confidential information from being viewed by others.

Hide Cells, Rows and Columns In Excel

Hide Cells in Excel

While you can hide and unhide entire Rows and Columns in Excel, individual Cells or group of Cells can only be blanked out.

In other words, hiding Cells in Excel makes the content of the Cells hidden, it does not make the Cells disappear. If this is what you are trying do, you can find below the steps to Hide Cells in Excel

To hide Cells, select the Cell or Group of Cells that you want to hide, right-click and click on Format Cells… option in the drop-down menu.

Format Cells Option in Excel

On Format Cells screen, click on the Number tab, select Custom Category and enter three semicolons (;;;) into the Type box.

Hide Cells Using Custom Format in Excel

Click on OK and you will see that the data in the selected cells is no longer visible and the cells appear blank, as if there is no data in them.

Select any hidden cell and you will see that the Data in the hidden cell can be seen in the formula bar.

If you type anything into hidden cells, the original value will be replaced and the new content will automatically become hidden when you press the Enter key.

Unhide Cells in Excel

To unhide the Cells, select the hidden Cell or Group of hidden Cells and click on Format Cells option in the drop-down menu.

Format Hidden Cells in Excel

On Format Cells screen, click on the Number tab, select the General Category and click on OK.

Unhide Cells in Excel by Switching to General Category

You will see that the Data in hidden cells is now visible.

Hide Rows and Columns in Excel

In case you are dealing with a large worksheet, it can be helpful to hide other Rows or Columns that you are not currently dealing with.

To Hide Rows in Excel, select the Rows that you want to hide. Next, right-click on the selected Row Numbers and click on the Hide option in the contextual menu.

Hide Rows In Excel

To Hide Columns in Excel, select the Columns that you want to hide. Right-click on the selected Column Number and click on Hide option in the menu that appears.

Hide Columns in Excel

As mentioned above, hiding Rows and Columns in Excel actually makes them disappear from your view.

Unhide Rows and Columns in Excel

When you Hide Rows or Columns in Excel, you won’t be able to view the hidden Rows and Columns, unless you unhide them.

To Unhide Rows or Columns, select the two Adjoining Rows or Columns between which the Rows or Columns are hidden. Next, right click on the Column Number (Row Number in case of Rows) and click on Unhide.

Unhide Columns in Excel

Once you click on Unhide, you will immediately see the hidden Rows and Columns appearing on your screen.

Related
  • How to Hide Formulas in Excel
  • How to Hide Blanks in Pivot Table

Primary Sidebar

Twitter
Facebook

Popular Now

  • How to Boot Windows 10 From USB Drive
  • How to Backup iPhone to iCloud
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Setup Chromecast on Android and iPhone

Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks



About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2020 @Techbout.com · All Rights Reserved