Real Name: Greg Cunningham Member Since: February 21, 2007 Last Signed In: March 31, 2008 Profile Views: 446 Blog Views: 1206 I'm running out of disk space. How can I free up some space? How can I download streaming video to my computer? How do I change the Power button in Windows Vista to shut down my PC instead of going to sleep? Someone told me about using to open the Start menu in Windows. Are there any other handy Windows keyboard short cuts? I just upgraded to Internet Explorer7. What happened to the menu bar? File, Edit, View, etc.? How can I stop Windows Messenger from asking me to sign in every time I start Windows? Someone told me to to ram my computer. What did they mean? I want to sell my old PC. How do I make sure there isn’t any personal information left on it? How do I protect my formulas in Excel? Am I backing up my PC correctly? February 07 March 07 April 07 May 07 June 07 July 07 August 07 September 07 October 07 November 07 December 07 January 08 February 08 March 08 April 08 May 08 June 08 July 08 August 08 Bandwidth Speed Test - how fast are you? Virus and Malware Threats - the latest info Open Source Windows - free MS replacements 
RSS 2.0    |
|
|
How do I protect my formulas in Excel?
OK, this isn't really very intuitive, so pay attention. In Excel all of the cells in a spreadsheet are protected (locked) but the worksheet itself is not. So you need to do two things to protect your formulas. First, highlight the cells you DON"T want to protect - the not-formulas part of your worksheet - then right click and choose Format Cells. Click on the Protection tab and uncheck Locked. Second, from the Excel menu bar choose Tools, then Protection, then Protect Sheet. You can enter a password to unprotect the sheet, but usually it's not necessary. Click OK. Your formulas are now protected. To make it easier to differentiate between the protected and unprotected areas of the worksheet I usually change the font color in the unprotected areas. I like a nice blue. 0 comments from 0 users
|