Monday, January 4, 2010

Lock and Hide Excel Formula

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSoGyf7MUm34H-FRKbhmY1508rG8PrlPS4IoooO36jSaHGv3148N2RMcKRlT_7e1iZ5wJTmGBy_IUc-9vEUSXFN1wu2LQYB8DBQQfc8CAUSb6AIyG9vPHiBTZW6qdri4CrdE3fYlmgc-0/s320/excel_logo.gifWhile working with formulas in Excel, you may feel the need to store and protect so that no change when you want to use it again. How?

Actually it's easy, even you can hide it all. Here's how.

• At first, first block of cells you want to hide the formula.

• Select the "Format Cell", followed by clicking on the tab "Protection". Enable "Locked" to lock and "Hidden" to hide it, then click "OK".

• Ensure that other cells do not come unlocked so that any time you can change existing data (Locked inactive, because its default active Locked) is to block all the cells would not be locked. Remember, do not activate the Locked and Hidden.

• Select "Tools> Protection> Protect Sheet ...". Dialog box will appear "Protect Sheet". Enable "Contents", then type the password that will be used, ending with "OK". Dialog box will show "Confirm Password" to make sure. Type the same password again, then press "OK". Presto! The formula will disappear suddenly.

• To bring it up again, select "Tools> Protection> Unprotect Sheet ...". Enter the password, then click "OK". Tada! The formula will reappear.
Jika anda merasa artikel ini bermanfaat, silahkan lakukan vote ke Lintas Berita agar artikel ini bisa di baca oleh orang lain. Suported by : Start Sharing Not Selling

COMMENTS :

Don't Spam Here

0 komentar to “Lock and Hide Excel Formula”

Post a Comment

Site Info

 

Copyright © 2009 NdyShared | Blogger Templates Gallery. All Rights Reserved. Powered by Resources and Inspiration and NegeriAds.com Solusi Berpromosi | Portal News dan Entertainment | Download Film Gratis | Blogger Indonesia Dukung Internet Aman, Sehat & Manfaat | Ingat Solo Ingat Soloaja.com.