Back to Newsletter Archive page

CNET Membership newsletter August 6, 2004 


The 5 that matter

Dear CNET members:
Every week I receive tons of e-mail from our members, not only for Q&A submissions, but also feedback, suggestions, and corrections. For those of you who asked me why I use such simple questions as this week's Excel question from Conrad, I say that we are all here to learn from one another, and everyone deserves to have their questions answered. Besides if it's easy for you, you should be able to submit a great answer.

I also received e-mails to let me know that I displayed the incorrect poll results question last week. And to those who brought it up to my attention, I sincerely appreciate it.

A few of you gave me a "shame on you" for last week's picks. I appreciate your directness, and I admit that I made a mistake, for I overlooked a solution that was in fact an old hoax. What really eats me here was that I even wrote about this hoax a few years back in my CNET Message Boards newsletter! Thanks for giving me swift kick in the rear.

So please, everyone, read up on my mistakes by clicking here. And on this note, thanks to everyone who wrote to me. You make all the difference, because this weekly newsletter is completely driven by you, its members. Without your participation, we as a community would suffer in our learning about the fast-moving world of technology. Just look at what resulted in last week's Q&A forum discussion, with its variety of opinions and solutions. So if you missed out, better hop to it and don't be the last one in line to participate. Now on to this week's question and answer.

1In Excel 2002, I want to lock in my title row so that it remains visible while I scroll down to see the rest of my data. Any ideas?

----Submitted by: Conrad F. of Walnut, California


There are two ways:
1. Freeze Panes (Alt+W, F). Position your cursor on the line below what you want to keep. If you want the entire row, put the cursor in column A. If you want some columns to also be frozen, position the cursor one column to the right. Click Windows (Alt+W). Then click Freeze Panes (F). To undo the freeze, do Alt+W, F again. The position of the cursor doesn't matter when unfreezing.

2. Split (Alt+W, S). Cursor positioning and undo are both exactly the same as for freezing.

There are several differences between the two.
1. You can reposition the split crossbar as you do windows (position mouse over a bar, right-click and hold, move mouse, unclick). You cannot move the frozen sections without... Read more

--Submitted by Mark S.

(Please click here for Mark's full answer and the honorable mentions.)

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

Check out next week's question:

I have a fairly new computer that's running Windows XP, and I would like to take some of my old family videos on VHS and transfer them on to DVDs and play them. I have a DVD burner, but what other equipment and software are needed in order for a novice like myself to accomplish this?

--Submitted by: Kirk S. of Lake Charles, LA

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.

How do you keep track of your passwords?


Write them down
Password-tracking software
It's all in here, baby (pointing to brain)
Easy, I use one password for everything!
None of the above
More than one of the above

Now that it's back-to-school season, what kind of PC are you buying for yourself (or your kids) this fall?
Neither: I can get another year or two out of my old machine 65%
Desktop: the maximum bang for the buck 18%
Notebook: gotta have mobility 17%

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

CNET Help.com's "Introduction to Macromedia Dreamweaver MX 2004" starts Monday August 9-- signup now for free!

Build Web sites without knowing any HTML
Create lists, tables, and other complex elements
Work with style sheets and XHTML
Put images and other multimedia files on your Web site
Manage all of your Web site pages
And much more...
1 What is the difference between hardware and software firewalls?
Compromised data on computers are all too common today. So, many home users have turned to firewalls to prevent their PCs from being exploited. However, firewalls come in two forms, hardware and software. So what's difference? Does one perform better over the other or are they equal in strengths? If you have both soft and hardware firewalls running together will there be conflicts? These and many other questions come to mind. So if you are you looking into getting a firewall and need a little firewall demystifying, join us in this discussion. And all you firewall gurus out there, come a drop you two cents in, we'd all appreciate it. More from the Broadband forum

1 Precautions for taking digital camera/card overseas?
I have gone through airport security X-rays numerous times with my digital camera and its storage devices without any incident of data loss. But I've always carried it with me rather than check it in with my luggage. However, be aware that if your tendency is to check in your digital storage devices with your luggage, you may just lose your data stored in it because of how airport security now scans/sanitizes your luggage. Here is topic brought up by a member that lost their digital photos after a plane trip overseas. Since security is getting more and more stringent, what is expected next? Should we be concerned with data loss in our digital storage devices now? How can we prevent this from happening? If you are someone who has any knowledge or experience in this field, please chime in. With your knowledge we can get a better understanding of what takes place behind the scenes in airports and how we can prevent precious digital data from being lost during a trip. More from the Digital Cameras forum




Open Windows Explorer collapsed
XP Media Player dialing--how to stop it
Opening e-mail: Outlook Express virus-prevention instructions

" /> " />
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
CNET Membership newsletter
 Back to Newsletter Archive page

CNET Membership newsletter July 23, 2004 


The 5 that matter

Dear CNET members:
I missed you folks last week, and it's great to be back on track, tackling one technical problem at a time each week. This week, instead of one winner, we have two. Thanks to Julie F. and Matthew J., we can now swap out those XP and Mac icons with the ones we prefer. Be sure to check out the honorable mentions for additional tips and advice. If any of you would like to discuss this topic further, you're welcome to join us by clicking here.

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

As a bonus, I added the Mac OS to the above question.

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

For Windows XP: In Windows XP, some application or file icons cannot be customized without the use of special software. You can however, customize shortcut icons, which are typically what you use from your desktop, start menu, and quick-launch menu. The instructions below assume that you have customized icons stored in a folder on your hard drive.

To change a shortcut icon:
1.Right-click the icon and select Properties.
2.Click the Short Cut tab and click the Change Icon button.
3.In the section "Look for icons in file," click the Browse button and navigate to the folder that you have your customized icons stored in.
4.Open the folder and look for the icon that you want associated with the program and double-click it.
5.Click the Apply button and OK.
(Note: If you want to simply change an icon that is preloaded in XP, go to step 3 and instead of clicking the Browse button, copy and paste this line in the "Look for icons in file" field: %SystemRoot%\system32\SHELL32.dll and hit the Return key. This will display all the icons native to Windows XP, and you can choose any of them to replace your current icon.)

--Submitted by: Julie F. of Thousand Oaks, California

For Macs:
1. Locate the custom icon you wish to use for your favorite program. This can be any icon in any folder of your hard drive or one that you made yourself..
2. Highlight the icon and choose Get Info from the File menu in the Finder or (Command+I).
3. In the Get Info window, click the icon that is displayed under General.
4. Choose Copy from the Edit menu or (Command+C).
5. Close the Get Info window and locate the icon of the program you wish to customize.
6. Highlight the program icon, choose Get Info from the File menu again (Command+I), and highlight the program icon under General.
7. Choose Paste from the Edit menu (Command+V), and your program's icon is changed to the one you copied to the clipboard.
8. Close the Get Info window.
9. If you change your mind and wish to revert the program's icon back to what it was originally, choose Get Info from the File menu, highlight the icon under General and press the Delete key. Your icon is restored.


--Submitted by: Matthew J.

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

For their efforts, we’re sending Julie and Matthew their choice of any Help.com Learning CD.

Check out next week's question:

Help! Somebody's using my e-mail address to send viruses all over the country. And people are sending *me* e-mail saying "You sent me a virus!" I don't want everyone to think I'm sending out viruses. Is there any way for me to stop them and clear my name?

--Submitted by: James C. of Dallas, Texas

(This week's question is interesting, and while there probably isn't a black-and-white solution to it, given so many circumstances, I hope that we can guide James C. to the right approach, so do your best to help him out.)

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.

How do you connect to the Internet?


Dial-up
Enhanced dial-up (such as NetZero HiSpeed, and so on)
DSL
ISDN
Satellite
Cable
T1/T3

What's your favorite desktop OS?
Windows 95/98/2000/XP 78%
Macintosh 9 or X 9%
Linux 8%
None of the above 3%
What's an OS? 2%

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

CNET Help.com's "Web Animation with Macromedia Flash MX" starts Monday July 26 -- signup now for free!

The fundamentals of the Flash Interface
How to create your first Flash movie
Adding ActionScript for interactivity
Publishing Flash content
Advanced methods for Flash authoring
And much more...
1 Digital camera: need help in switching from old to new technology
With hundreds of different digital cameras in the market today to choose from, it can be mind-boggling to scope out what's best for you, especially if you're moving from old to new technology. If you have expertise in digital cameras, this member needs your help with his decision. And if find yourself in the same situation, join in the discussion and see other suggestions and advice that will lead you to the right tech decision. More from the Digital Cameras forum

1 Is Linux for you?
Tired of the same old Windows grind? Maybe it's time to drop this ubiquitous OS and take on a new challenge: Linux. Many of you may wonder what all the hype is about and why Linux users love the penguin mystique. So, if you're contemplating using this OS or are just curious about it, join us here and find out what Linux users suggest. And if you're already a Linux guru, share your thoughts with curious and the daring. More from the Linux forum

1 To add or not to add a firewall?
News headlines about compromised data on computers are all too common. So, many home users have turned to firewalls to prevent their PCs from being exploited. Adding a firewall to a home PC may seem unnecessary to some, but is it? Check out this thread on firewalls to determine what's best for you and what people are recommending. And if you have something to add, let's hear your thoughts.More from the Computer Help forum

1  When should you get a new computer?
Trying to keep up with the dizzying pace of computer advances by buying a new machine every few years makes us wish that money grew on trees. Without that special blessing, many of us can't afford to purchase the latest computer. So exactly when is a good time to replace your old computer, every three years, five years? When you've out grown it or when newer applications will no longer run on your computer? Maybe it isn't about having the latest and greatest, and your old computer is all you really need, at least for now. Join the discussion and share your thoughts.




How to test your antivirus program
How to transfer files from one computer to another
Microsoft Word - all commands and keyboard shortcuts

" /> " />
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