• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer

Tech Library TV

Books, Productivity, and Design

  • Blog
  • Books
    • Self-publishing
  • Productivity
    • Excel Tips
    • Mobile Tips
    • Google Docs Tips
    • Tech Haiku
    • Windows Tips
  • Design
  • Listicles
  • Resources
  • Info
    • About
    • Contact

Excel Tips

How to Hide Cell Values in Excel (also in Formula bar)

March 18, 2018 by Arun Leave a Comment

In the previous video, we saw how to hide cell values in an Excel file. But that technique was a partial one as it still showed the contents in the Formula bar.

In this video, we will see how to hide cell contents in an Excel file not only from plain sight, but also make it invisible on the Formula bar.




If you want to watch this technique, simply click on the play button below. If not, read on:

Here’s how to do that.

To accomplish this, we first need to protect our Worksheet. But before we do that, let’s open our Format Cells dialog box and go to the Protection tab and select the checkbox that says ‘Hidden‘.

Once the cells are marked as ‘Hidden’, in case you want the cell contents to also be hidden from the normal view, just follow what we saw in our previous blog post…which is going to the Format Cells dialog box, choose CUSTOM category under the Number tab and type in three semi-colons in the Type field. This has now hidden from the normal view but still visible on the Formula bar here.

Let’s now hide it from the Formula bar as well.

To do that, go to the Review tab, and click on Protect Sheet under the Changes tab group, and click on OK.




That’s all.

Now the cell contents are completely hidden and protected from both normal view as well as the Formula bar.

To make it visible again, simply unprotect the sheet.

You can make use of this trick to hide any “behind-the-scenes” formulas or any calculation.

Filed Under: Excel Tips, Blog Posts Tagged With: guides, Resources

How to Hide Cell Contents in Excel

March 18, 2018 by Arun 1 Comment

In this blog post, I will show you how to hide the contents of the cells in an Excel file.

In this method, the contents won’t show up on the cells upfront on your sheet but it will be visible in the formula bar when the cell is clicked.

Read: How to find how long your computer has been turned on?

Here’s what you have to do:

Simply click on the play button in the video below to learn now by watching, if not simply scroll down to read further:

Right-click on the cell or cells where you want the contents to be hidden.




Select Format cells. alternatively, you can also hit the Ctrl + 1 key combination on your keyboard. OR you can also click on this tiny arrow on your Number group under the HOME tab.

hide cell contents in excel

In the Format Cells dialog box, under the Number tab, select custom.

Under the Type field, type three semi-colons. Click OK to save it.

how to hide excel cell contents

That’s all!

You can see that the cell contents are now hidden, but only visible on the formula bar.




 

Filed Under: Excel Tips, Blog Posts Tagged With: guides, Resources

Primary Sidebar

  • How to Solve iPhone to PC Transfer Error Easily (in 1 min)December 31, 2022
  • My Best Desk Camera Mount – for YouTube CreationsSeptember 17, 2022
  • Easy way to Download List of YouTube Videos Metadata from ANY YouTube Channel (FREE)June 3, 2022
  • Canva Embed – Remove Canva Footer from the Embedded Design?April 22, 2022
  • How to Format eBook for Kindle (5 simple DIY tips)March 9, 2022
  • Remove Weather from Taskbar Easily – Windows 10January 14, 2022
  • Tech Stack of Companies: 3 Easy Tools to CheckJanuary 7, 2022

Follow us!

  • Facebook
  • Twitter
  • YouTube

Footer

Archives

Copyright © 2023 · News Pro on Genesis Framework · WordPress · Log in