Choose the area and go to Home->Font->Open Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all the values in the area will be invisible, and can only be found in the preview area next to the Function button.
Almost all users know how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data. The best and easiest way to hide data thoroughly is to use the Format Cells function.
Philonoist. Pursuer of Dreams. Travel Aficionado. Web & Market Researcher. Social Media Analyst. Achiever. Internet Junkie. Independent. Creative
If you found any useful or interesting tricks, tips or hacks today, we ask that you please consider following us on your favorite social media websites. Thank you!
Register For This Site
Are you a robot? Yes or No?
A password will be e-mailed to you.