How To: Create an in-cell dropdown menu in Excel 2003
1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.
1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.
Make a breathtaking meteor diorama that will blow the competition away! This five part video series will show you everything you need to know about making a diorama, from setting up the box to placing dolls. This diorama is sure to impress!
The video describes how to convert any unit of weight to any other unit. The example used here is conversion of pounds to kilos. Going to the Google homepage, the desired conversion should be typed in the search box directly, e.g., "150 pounds in kilos". Click the "Google search" button and Google will use its built-in converter to give the result, in this case, 150 pounds is equal to 68.0388 kilos. This, if it is ones own weight, will of course make anyone feel better, because kilos look les...
This video is about how to make a puppet dragon out of household items. First, a piece of card stock paper is cut in half the long way. Next, you must take an empty 18-pack egg carton and cut off a strip of egg slots. Using a stapler, the two pieces of paper are connected long ways, with the egg strip stapled on top of it. This forms the body. To make the head, a small cardboard box is stapled to one end. A smaller cardboard box (about half the size of the one already used) is glued on top. F...
This video demonstrates how to suggest a friend to join your Facebook page. First you find the fan page by typing the name in the search bar at the top of the page. Choose the right result. Then click on suggest friends on the left hand side the page, just under the picture. A box will pop up with all of your friends listed. You can then choose which friends that you would like to suggest to become a fan of the Facebook page. Existing fans will be grayed out so you cannot choose them again. C...
The video demonstrates how to connect your Bluetooth phone to your computer and send/receive files between them through Bluetooth. You need to first switch on Bluetooth in your phone and then click on the icon for Bluetooth connectivity in the computer. Then click on the option called 'Add a Bluetooth Device'. You can see a setup wizard pop up in your computer screen where you have click on the check box and then click on Next button. Once the phone is detected, select it and click on Next. T...
Kim the in-house mechanic for Driverside shows you how to quickly and easily replace your cars air filter. The reason you would need to change your air filter is that over time the flow is reduced which consequently reduces your car's gas mileage. To change your air filter you first need to locate it on your car. The air filter is under the hood and usually in a box that either has clips of fillip's head screws holding the cover on. Remove these to gain access to your filter. From there you c...
In this video, Brian from Trutricks shows us how to create a new Twitter account. First, go to Twitter and click on the "sign up now" button. You will now be brought to a new page where you can choose your user name and enter your email, password and full name into the information boxes. Once finished, click "create account". After this, you will be able to follow people you want as well as have other people follow you. Once you are ready to tweet you can type whatever is on your mind in 140 ...
This video shows you how to embed a YouTube video inside your PowerPoint presentation. Once you have the link for the video that you hope to embed in your presentation, open your PowerPoint. Click on the circular icon in the upper left hand corner. Go to PowerPoint “options”. Check the box for “Show Developer Tab in the Ribbon”.
This video is about how to block recent activities on Facebook. The first thing that you will have to do is to log in to your Facebook account. After logging in to your account, the next thing that you will have to do is to go to account settings and look for the "Ads and Pages". After you have found "Ads and Pages", click on the "Edit Settings" and go to the "Special Permissions" tab and uncheck "Publish recent activity" box then press "Okay" after wards. The next step is to look for "Events...
Steps to make Sprite animation in Photoshop are:1. Open a spreadsheet of your own choice; in this case we are going to take running animation.2. Once your spreadsheet is loaded, zoom-in until you get a four page, for ease of use.3. Zoom-in to the required movement, after zoom, select the image and open File and from that click New File and click OK (Dialog Box), and you will get a work space to work on with your selected image. The feature makes it simple for one character animation (work).4....
In this Computers & Programming video tutorial you will learn how to add photos to Facebook using Picasa. The video is from Help Me Rick. Log into Facebook, go down to the lower left corner and click ‘Applications’. Click ‘Find More’ and in the search applications box, type in ‘Picasa’. You will get a list of Picasa applications. Select the Picasa by Alan Lundeen. Here you click ‘go to applications’ -> install now -> OK -> Yes -> Facebook -> Add -> OK. Now you will get a Facebook icon on the ...
This video shows how to embed a YouTube video in a PowerPoint presentation in Microsoft Office PowerPoint 2007. First you want to copy the URL of the YouTube video that you want to embed in your PowerPoint. Then, open PowerPoint 2007 and click the office button in the top left corner (circular button with office logo). Then click "PowerPoint options" and check "show developer tab in ribbon". Then click "OK". Click on the developer tab, and click on "more controls". Then scroll down to "Shockw...
This video is by chilled chaos demonstrates how to make a moving catapult in LittleBigPlanet. In materials first use the cardboard to draw and two legs at the bottom. Detach it from the ground. Take the rubber tool from the tool box and make two wheels. Take bolts and attach to wheels. Make the switches on it and set the right and left direction. Do the setting for the wheels. Make a basket and attach it with the previous structure that it can move up and down. Set the timings to set the spee...
This is a Computers & Programming video tutorial where you will learn how to make a simple port scanner in VB.Net. It detects all the open ports on your network. Open up a Form1 and you will have a ListBox1, a ‘Start’ and a ‘Stop’ button and a blank text box. There is also a Timer1 button at the bottom. Thereafter, the video shows the various parts of the code on the screen. Then click on Debugging, and click ‘Start’. The system starts scanning ports starting with port 1. In the video it show...
In this tutorial, Zain will explain how to download free mp3's from your PSP to your PSP. All you need is a wireless connection, and a PSP. First, go to your internet browser. You can enter on Kohit for downloading free music. There you have search box where you can write the title of the song you want. Type it there and then click 'go'. A song list will appear on the web page. Click on the song you want to download. Now click on 'Download now'. Go to options and click on 'Save Link Target'. ...
This video details how to set up a generator to provide back-up power for a home or business. Generators are the ideal emergency power solution for a home or business, generators can automatically transfer the power load from the utility power line to the generator when an outage occurs. To make sure the generator is always ready, generators can self run weekly and perform self diagnostics so maintenance issues are minimized or eliminated. When planning to use a portable generator, it should ...
Yanik Chauvin demonstrates how to do Non Destructive Dodging (lighten) and burning (darken) of images using the tools in Photoshop. He shows the image of a man lying on earth with his camera. To start the work he wants to make a new layer which can be done in two ways either by clicking on the ‘layer’ button on top of menu or by pressing down the alt key and clicking on the new layer at button of the layer palette. It will bring up the dialogue box. He named it “dodge and burn” and from the l...
This is a step-by-step guide to cleaning out those old fires in your Windows XP computer. You want to start by clicking the "start" button and then clicking on "my computer". Once there, you are going to want to right click on the C-Drive to clean that one first and click on "properties". Once the box opens you want to click on "tools" on your tool bar and then click on the "defragment now" button. When the box opens click on the C-Drive and then click "Analyze" to
This video describes how to insert keywords and SEO with the fusion essentials in the website. He asks you to first go to the site mode and then click on the home page and from there you can get in to the property box. There you can find three choices or tabs. He explains that the first one can be used to change the page name and page title and also can adjust the master border. The second tab is used to mention the page status, if it is done and can be displayed to the viewers or if it shoul...
This video shows us how to burn files to a disc using Windows Vista. Insert the blank disc in your computer's recordable disk drive. Autoplay will automatically appear. Choose "Burn Files to disc using Windows". Click next when "Burn a disc" dialog box appears. Empty folder window appears. Choose files that you want to copy and drag them to the window. For example, if you want to copy a photo, click Start menu and open the Pictures folder. Select photos and drag them to the window. Photos are...
Simple steps on how to clear your cache on Firefox and Google Chrome. Clear Cache on Firefox:
Vanessa from Tekzilla Daily gives us a very helpful video guide on how to edit or tweak icons in the system tray on Windows 7. Typing "notification area" in the search box of the Start Menu calls up the Notification Area control panel. This control panel shows the different processes and programs that are on the system tray. It is where you can edit the settings for each process or icon, with options of "always appear, never appear or show up only when needed". You can also control the basic ...
Not sure how to enable javascript on your computer? Follow these steps to enable all the functionality javascript provides.
Want to know how t o find that file you've been searching for on your Mac? Apple computers are renowned for being simple to use, as this exercise in searching for a lost file demonstrates.
Worried about your baby or toddler either wrecking or wrecking themselves in your home? Baby proofing time! Make sure your house is safe and secure for your child when they start exploring their turf.
Don't put up with another winter of discontent. There are simple things you can do to lift yourself out of the doldrums.
Just like wine, some beer gets better with age. Learn how to properly store and age beer for optimal flavor.
Keep your possessions safe from thieves with these tips. You Will Need
Making a storyboard before shooting a movie is like drawing a blueprint before grabbing a hammer and nails. Do it well, and make sure your film is structurally sound.
Magic is something almost everybody wants to learn, so why not learn now? Magic tricks can be done by anybody, you just need a little confidence and a little sleight of hand to pull off the illusion.
Systm is the Do-It-Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. They will help you avoid pitfalls and get your project up and running fast. In this DIY episode, see how to build and use a handheld automated warspying device.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to make calls and use voicemail on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to shop iTunes on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
Put your team in a position to score by mastering the art of the corner kick. Strive to be like Beckham. Master the corner kick with this soccer guide from Howcast.
Learn how to make a DTV antenna & a steadicam. Digital converter box? Check! Great reception? Not so much. John Park shows how to take a fistful of wire coat hangers and make a TV antenna that gives great digital reception. While he’s at it, he also makes a video camera stabilizer using metal piping and counterbalance weight; great for at-home moviemaking.
Aspirin masks are not something new, but many people are not aware of this amazing mask and the potential it has for clearing you skin!
Want to make a Rubik's Cube just like Erno Rubik? Of course you do, but before you start making all of the intrinsic mechanisms of the classic Cube, maybe you should start out a little simpler.
Check out this video tutorial from Obsessed Board Gamers to see how to play the board game Aquaretto. You will get an introduction to what's inside the box of Aquaretto and how to play it. Aquaretto is the third game in the Coloretto and Zooleretto series, but is it the best one?
The Tigris and Euphrates Rivers run right through Iraq and meet inside the so-called Sunni Triangle. This has been a traumatizing spot for U.S. troops over the past few years, but it doesn't have to be... especially if your playing the board game Tigris and Euphrates.