Slider

How to Hide the Content in an Excel Cell

Date:2019-7-31 Author:Cordelia

I've introduced how to hide cells (precisely speaking, rows or columns) in Excel. In this post I'll share another trick about hiding the content of one or multiple specified cells without affecting the structure of the table. And the best thing is, when you double-click that cell, the content will show again.

In this table below, I want to hide the values in the Profit column.

How to Hide the Content in an Excel Cell

So I select all the cells containing the data of profit and right-click the selected area, then choose Format Cells...

How to Hide the Content in an Excel Cell

Select Custom in the list of Category. Delete the content in the textbox below Type and press Space key. It means the content in these selected cells will show as blank. Then hit OK to confirm the settings.

Back to the worksheet, all the content in selected cells have been hidden.

How to Hide the Content in an Excel Cell

But if you double-click any of the cells, the value in it will appear again.

How to Hide the Content in an Excel Cell

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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