How to hide cell data in Microsoft Excel

Just like you hide Excel sheet formulas, you can also hide data entirely from cell and many of you don’t know that. This little trick can be useful if you want to hide specific cell data or entire row / column data from users who can access the Excel sheet.

This is different from hiding the rows / columns using the Hide function which may be known to multiple users. Hiding the Excel sheet data results in a blank cell, however the data is still present but not visible in the cell. Here is how the trick works, follow these steps below to hide cell data in Microsoft Excel.

How to hide cell data in Microsoft Excel

  • Step 1: Select the cell data you want to hide.
  • Step 2: Click the right mouse button on it and choose Format cells from the menu. You can also use CTRL + 1 to access the Format Cells option.

How-to-hide-cell-data-in-Microsoft-Excel-5-836x1024

  • Step 3: Under the Format Cells window, make sure you are in the file Number form. In the left pane, go to the bottom and click Costume.
  • Step 4: In Custom, type ;;; (three times) to hide the values ​​from the cell. You can choose multiple cells and use the same trick to hide the data.

You can quickly view the cell data in the preview bar next to the function button in the upper area. Although the cell data is visible in the preview bar and anyone can view it if they know, it’s still useful if people don’t notice the preview bar. You can repeat the steps and remove the file ;;; to show cell data.

Here’s how to hide cell data in Microsoft Excel. You can do a lot in Excel, there are a number of simple tips and tricks as well as quick shortcuts, hacks, and time-saving workarounds that can boost your productivity, no wonder if you are a beginner or an advanced user. For more such content, please visit ours Practical guides section.

Do you like this trick? Check out other things we’ve shared below.

To receive updates on the latest tech news, smartphones and gadgets, be sure to follow us on our social media profiles.

Instagram | Facebook | Twitter | Youtube

Google News button

Leave a Reply

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