In this short video I'll show you how.Want mo. Now, the hidden text in your cells will be visible again. Hiding the gridlines, especially if you've added your own borders to cells, makes a spreadsheet easier to read. But this time choose “ General” as the format of the cells. If you want to display the hidden cell values, right-click the cells and select “ Format Cells“. The contents are still there and accessible for formulas, charts as such. This method only hides the cell contents from being seen. Click OK and now the data in your selected cells is hidden.On the Number tab, choose the Custom category and enter three semicolons ( ) without the parentheses into the Type box.Right-click to choose “ Format Cells” option from the drop-down menu. Select the cells that contain sensitive data you want to hide.Under For cells with comments, show, select the No comments. On the Excel Options dialog box, click Advanced in the list of items on the left.
On the backstage screen, click Options in the list of items on the left. How to Hide Data or Text in an Excel Cell? In this tutorial we’ll walk you through the procedure to hide data or text in a cell in Excel 2016. How can I hide the data in an individual cell I want to keep private? Hiding the confidential content of a cell is a useful trick most Excel users probably don’t know.
