Back to Newsletter Archive page

CNET Membership newsletter July 9, 2004 


The 5 that matter

Dear CNET members:
Every week while going through all of the questions and answers, I not only learn a lot about the topic of the week but also a bit about the personalities of the members who submit them. It's a great feeling knowing that people from all walks of life, in fact, from all over the world, read and participate in this newsletter. And I hope that most of you are benefiting from it as we all teach and learn from one another. So I would just like to send a big thank-you to all my readers to let you know that I appreciate your submissions and your feedback whether it's positive, critical, or funny. Now let's move on to this week's great answer by Brian H. of Israel on how to protect those selective cells in Excel. I hope this helps you out, Chris H. of Thailand. As always, check out the great honorable mentions too!

(Note: I will be taking a week off, so I'll miss you all next Friday. But please stay tuned for the answer to this week's question in a couple of weeks. If you are in dire need of help, check out our technical forums, the solution could be just one post away.)

1In Microsoft Excel, how can I protect selective cells in a worksheet (the ones that contain formulas) from accidentally being altered or deleted?

--Submitted by: Chris H. of Hua Hin, Thailand

By default, all Excel worksheet cells have locked definitions associated to them. This function will take effect only if the worksheet has been protected, and it covers all cells in the protected worksheet or workbook.

If you want to protect only specific cells, such as those with formulas, you would first need to unlock all the cells on the worksheet, lock the cells that you want to protect, and protect the worksheet.

1.Select all of the worksheet (hold down the Ctrl key and A) or all of the working cells in your sheet (hold down the Ctrl, then select Cells).
2.When the selection has been made, right-click the mouse and select Format Cells from the drop-down window.
3.Click the Protection tab, deselect the Locked check box, and click OK.
4.Now click the specific cells that you want to protect. You can select them all at once by holding down the Ctrl button on your keyboard while you click each cell.
5.Once all cells are selected, right-click the mouse again, go to Format Cells, click the Protection tab, and this time select the Locked check box and click OK.
6.The final stage is to protect the worksheet. Click Tools, go down the menu to Protection, click Protect Sheet, then click OK. A password is optional here. If you want to password-protect it, enter a password (you will need to reenter it to confirm), then click OK. Don't forget your password because there is no way to retrieve it.
7.Save your work!!

Now your worksheet is protected, and locked cells cannot be tampered with unless you follow step 6 to Unprotect sheet or open it with the protection password you assigned to it.

--Submitted by: Brian H. of Israel

(Please click here for Brian's complete answer and don't forget to read the honorable mentions, which include a lot of great additional tips.)

For his efforts, we’re sending Brian his choice of any Help.com Learning CD.

Check out next week's question:

In Windows XP, is there a way to change the icons for my favorite programs into my own icon designs?

--Submitted by: Laura S. of Sparks, Nevada

(BONUS: This week, I'm going to throw in an additional Learning CD-ROM if you can answer the above question for Macs also.)

We feature a new question every Friday. If you have the answer, e-mail us at messageboards@cnet.com. If we choose your response, you'll get a free Help.com CD. Click here for Q&A submission guidelines

Best regards and enjoy!

Lee Koo
CNET Community
Got suggestions? E-mail me: messageboards@cnet.com


Have a question?
E-mail us a question on one of our upcoming topics:
Microsoft Excel
Digital Cameras
PC Upgrading
PC Troubleshooting

Need help right away? Don't wait for us, come and join our lively community forums for all the tech help and how-tos.

What's your favorite desktop OS?


Windows 95/98/2000/XP
Linux
Macintosh 9 or X
None of the above
What's an OS?

What do you do when your computer stops working?
Find a working PC and surf the Web for a solution. 37%
Ask a friend or a family member for help. 26%
Does that ever really happen? 20%
Take it to a repair shop. 14%
Buy a new computer and start over. 3%

Do you have a poll you'd like to ask our members? E-mail us a suggestion.
     

CNET Help.com's "Setting Up Your Home Office" starts Monday July 19-- signup now for free!

Brought to you in partnership with:
1 Build my own PC or not? Need advice!
So you've done a few hardware upgrades here and there on your computer. And the daredevil inside of you is having brave thoughts about building your own computer vs. buying a prebuilt system. Is building one cheaper than buying one out of the box? What are the advantages of building your own? Is it difficult? With some knowledge and a bit of nerve, building a computer can be quite rewarding. If you're curious about or contemplating building your own system, take a peek at this discussion. It's bound to be helpful. And if you're a resident expert at building computers, offer up some advice for the rest of us. More from the PC Hardware forum

1 Looking for software to burn photo slide shows to DVD
If you've successfully burned digital photo slide shows to DVD, please chime into this discussion in which a member is looking for some advice and suggestions on software to complete this task. And if you're looking to do this yourself, this discussion is for you, too. Take a look. More from the Digital Cameras forum

1 Low system resources?
Have you ever had a pop-up message saying your system was dangerously low on resources? Then, did your mouse act erratically, while the computer slowed to a crawl and eventually froze up? It's a pretty rude shock, but why does it happen? What are these "resources" that the computer wants you to know are lacking? If it's all a mystery to you, find out in this discussion what you can do to prevent your resources from running low.




Partitioning for dummies
Solution to receiving phone calls while I'm online (dial-up)
Firefox 0.9.1 options?

" /> " />
Sign up for CNET Newsletters
Home & Entertainment Weekly
A weekly wrap-up of all of CNET's coverage of personal technology for home and entertainment, from digital cameras to cell phones to plasma TVs. You won't want to miss a thing.
On-the-Go Weekly
All of our coverage of cell phones, handhelds, MP3 players and headphones, ultracompact digital cameras, and everything else for the mobile lifestyle is now in one newsletter.
At Work Weekly
Focuses on the needs of the business professional. Whether your office is at home or in a skyscraper, it provides advice on how to buy and use personal tech to save time and get more done.
Photo & Video Weekly
Our weekly dose of the latest product reviews, features, columns, and advice on digital imaging and video--straight from the editorial experts. It's the best way to keep up.

Manage My Newsletters

CNET readers and the gadgets they love
Every day, CNET editors review all the latest gadgets and hardware and give each one their approval rating. But CNET readers are just as picky about their gear as our editors. Each of the readers featured in "Three I can't live without" have three pieces of tech that keep them going, and they're proud to show them off. Want to show other readers your own must-have survival tech? Send in your profile, and you could be on CNET's front page.

Personal Tech Radar
Join our vibrant online community -- browse hundreds of discussions, ranging from computer troubleshooting to technical product help and how-tos. It's your community, so get involved now!

1. Windows XP

2. Computer Help

3. Speakeasy

4. Windows 98/95

5. PC Hardware

6. Windows Me

7. Computer Newbies

8. Web Design

9. Cell Phones

10.Virus & Security

Personal Tech Radar
Your CNET membership always gives a discount on Help.com Learning CDs, which let you quickly build your skills in Photoshop, Dreamweaver, Linux, Office XP, Web development, and much more.
Home Theater SuperGuide
Get the inside scoop on all the tricks and terminology you need to know to master the secrets of Home Theater.
View sample content now
 
PC Maintenance 101
This comprehensive CD-ROM provides tutorials and software that let you precisely analyze and repair your computer.
View sample content now
 
Digital Camera SuperGuide
Get expert advice on buying and using digital cameras from Help.com's comprehensive new guide.
View sample content now

Copyright © 2004 CNET Networks, Inc. All rights reserved.

 Back to Newsletter Archive page