LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
52
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Hide Data Thoroughly
UPVOTE
52
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Hide Data Thoroughly

Excel Spreadsheet

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.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

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. 



User Comments