ABC ~ All 'Bout Computers
The Online Web-azine for Computer Enthusiasts
-- brought to you by

Holiday Issue
contents page for this issue

What's New at Linda's Computer Stop

For any of you who are tired of all the pop up ads you have to weed through when you go to ClipArt sites, I've compiled a Holiday Graphics Page for you.  I've included graphics for Christmas, Hanukkah, and New Years.  Please feel free to grab any of these for use on your holiday cards or websites.  And don't forget to click on the link for the "Contributors" to visit their sites for lots more.

http://personal-computer-tutor.com/xmas.htm

Next, I want to apologize if the reorganization of my website has caused you to stumble upon broken links.  Because ABC is becoming so large, I had to separate it out into subwebs, which changed some of the links, but only if you come here from an old external link.  I assure you, once you are inside Linda's Computer Stop or ABC, all of the internal links will work.  If you have any problems finding anything, please send an email to linda@personal-computer-tutor.com and tell me the link that isn't working and I will give you the new one.  Also, if you have links to any of my pages on your own website, please update those links to reflect my new format.

Along these same lines, I have made re-direct pages to try to get you to some of the more popular pages that are linked to from a lot of external sources.  I also made a new Search Page, just for ABC, so you can search just the ABC articles, without searching my whole website.  Check it out and let me know how it's working for you:

http://www.personal-computer-tutor.com/abc/searchabc.htm

Of course, you can also search the rest of my site, if what you are looking for isn't covered in ABC:

http://personal-computer-tutor.com/search.htm

And I've also categorized my Site Map, so you can easily find all of my tutorials.  I hope all of this has made my site easier for you to maneuver.

http://personal-computer-tutor.com/TOC.htm

And, after one too many complaints from my viewers that they couldn't see the arrows and box on my dark blue on dark blue scrollbars, I changed the box and arrows to pale blue.  Of course, in this issue, I've chosen appropriate red and green scrollbars for some holiday festiveness.  J

I've also added an Awards and Recognitions page to thank all of the people who gave my site an award or allowed me to contribute to their sites.  Please visit this page and click on the graphics to visit these fine sites.

http://personal-computer-tutor.com/awards.htm

And, I wrote two new articles this month.

TechTrax Ezine
Make an Out of Office AutoResponder, using Outlook *Without* Exchange

copy on my site:
http://personal-computer-tutor.com/autoresponder.htm

Neat Net Tricks Premium
Microsoft Word Formatting & Styles

copy on my site:
http://personal-computer-tutor.com/wordformat.htm

And, as usual, for more of my favorite links, go here:
http://personal-computer-tutor.com/internet.htm

Well...that's about it for this month.  Please come back to my site often to see what else I've added and drop me a line at linda@personal-computer-tutor.com if you have any suggestions.

Linda

<<<back to contents

Subscribers' Exclusive Tip
Adding a Dropdown List To a Cell in Excel

Is there a way I can add a dropdown list to a cell, so people can choose one item from a list of items located on another part of my spreadsheet or in a different sheet entirely?

This is a question I answer a lot, so I figured it warrants a tip.

It's actually pretty simple.  Let's say you want a dropdown list in cell C2 that lets people choose from the items that are listed in cells H10:H25.  Here's the steps.

• Click in cell C2 and go to the Data menu and choose Validation.
• Make sure you are on the Settings tab and click on the dropdown that says "Allow" and choose "List".
• In the box that says "Source", either type in =H10:H25 or simply click in H10 and drag to select H10 through H25 and the box will be filled in for you.  (Or, if you don't want to use values from a range, you can just manually type in the values you want to appear in the list, separated by commas.)
• Make sure there is a check in the box that says "In-cell dropdown"
• Click OK. 

Now check out cell C2.  There's your dropdown list all set and ready to be used.

<<<back to contents

Linda Johnson is a college instructor of all of the Microsoft Office Programs, as well as Adobe PhotoShop and Windows. She also teaches online distance learning classes in Excel, Outlook, PowerPoint, Publisher, and Word at Eclectic Academy. She has worked helpdesk and teaches and lectures at many local businesses and tech schools in her area. Support this newsletter by checking out Linda's eBooks, MS Word MAGIC!, Book I: Fonts, Fun & Formats and Book II: Table Wizardry, How To Get Started As a Software Trainer, and her newest series of MSOffice eBook Tutorials and CD