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

Tech Library TV

Product Reviews, Tech Knowledge, Kindle Publishing, and more....

  • Blog
  • Downloads
  • YouTube
  • Contact
  • About
  • Privacy Policy
You are here: Home / Excel Tips / How to Hide Cell Contents in Excel

How to Hide Cell Contents in Excel

March 18, 2018 by Arun 1 Comment

Share
0
Tweet
0

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: blogposts, Excel Tips

Reader Interactions

Leave a Reply Cancel reply

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

two × two =

Primary Sidebar

Recent Posts

  • 25+ Most Amazing Websites to Download Free eBooks (2019)
  • KDP eBook Setup – MetaData Guidelines
  • Is having more than one Amazon KDP account allowed?
  • How to Publish Public Domain Books on Kindle ( KDP )
  • How to Convert Image to Text (without any software)




Tips by Categories

  • Amazon Tips
  • Best of Tech
  • blogposts
  • eBook Publishing
  • Excel Tips
  • Google Docs Tips
  • How-To Videos
  • KDP
  • Listicles
  • Paperback Publishing
  • Reviews
  • Tech Haiku
  • Windows Tips
  • Word Tips
Download your free eBooks :)
download free ebooks
We respect your privacy.

Join now for FREE!

Most Recent Video on YouTube