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.
Execllent Source Search Results
How To: Use Handbrake to rip DVDs to your Mac OS X hard drive
HandBrake is an application that lets you to burn any DVD into any other format for any of your devices like music and gaming devices. Open the HandBrake application. Initially it displays a menu that can be used to rip a DVD. First select the source. You can browse your computer for the source. Insert a video DVD that you want to rip and select it from the source menu. Now you set the destination. Browse to any of the folder on your computer where you want to put the output video. HandBrake ...
How To: Install Installous and download free apps on an iPhone
The iPhoneHackers shows viewers how they can install Installous on their iPhone and Download free applications. First, you will need to have a Jailbroken iPhone or iPod Touch with Cydia. Your first step, will be to load Cydia on your iPhone. When Cydia has loaded click on 'Manage' and then 'Source'. Under sources click edit and then Add. Add the source: http://cydia.hackulos.us/ Next, go to search and type in 'Installous'. Click on Installous and then click install. The password for Installou...
How To: Get your iPhone 3G/3GS to play HD YouTube videos
To watch HD videos in YouTube in your iPhone 3g you must have Cydia and jailbroken iPhone with 3.0.1 IOS.
How To: Make the Glock full auto on Counter Strike: Source
Counter Strike: Source is one of those PC games that is literally never going to go away. This video will help to increase that already-prodigious longevity by teaching you how to use a glitch to make the Glock handgun in the game fully automatic. This turns it from a pretty useless handgun into a destructive force on the map. Quick, easy, and fun.
How To: Get Installous on a jailbroken iPhone or iPod Touch
Worlds Playground shows you how to install Installous on a jail broken iPhone or iPod Touch. You must have an iPhone or an iPod Touch first or second generation. Your first step is to open your Cydia app. Go to the manage tab of the app and then click on the sources button. The next step is to go to edit and then add. The source you need to add is "http:/cydia.hackulo.us/". After adding that source go to changes and download the MI patch. Once that is done go back to Cydia and changes and cli...
How To: Map text files with MapForce
MapForce supports flat files as the source and/or target of any mapping involving XML, database, EDI, web services or other flat file data. In this how-to, you'll find instructions for mapping data from arbitrary text files (such as log files, CSV, fixed-width, and other legacy data sources) to databases and XML files.
How To: Add Repos to Sileo So You Can Find More Jailbreak Tweaks to Install
If you're familiar with jailbreaking, you're well aware of the fragmented nature of downloading tweaks. Unlike the iOS App Store, which contains about two million apps of varying categories, installing jailbroken packages often requires you to first install a separate repo into either Cydia or its replacement Sileo, as many of these tweaks aren't available outright.
Google Assistant 101: How to Customize Your News Feed & 'My Day' Experience
The Google Assistant comes in several different flavors. There's the baked-in Google app on Android, the dedicated Google Assistant app on iOS, and the Assistant-powered Google Home smart speaker. But no matter how you access it, your Assistant will only get better if you take some time to personalize things.
News: Break Out of Your Comfort Zone with This News App
Following the most recent election, some argue that increasing political polarization is dividing Americans. A new app, called Read Across the Aisle, is aiming to combat this by encouraging users to read news from media outlets on both sides of the political spectrum.
News: Forget CNN or FOX, WhatsApp Is Now a Popular News Source
According to a new study from the Reuters Institute and the University of Oxford, people are getting their news from ... unexpected sources. Put away your CNN app and stop checking the New York Times because a familiar app is now keeping you up to date on current events: WhatsApp.
How To: Block Ads in All Your Android Apps Without Root or Extra Battery Drain
If you're in the market for a non-root ad-blocker, developer Julian Klode has an app that you'll definitely want to check out. It uses Android's VPN system in a similar manner to alternative apps like NetGuard and AdGuard, but it's got a new twist that should save lots of battery life in the process.
How To: Change Your Android TV's Screensaver
Much like the Chromecast, Android TV devices such as the Nexus Player and Nvidia Shield TV have always had those beautiful background images as their default screensaver. However, unlike the Chromecast, these "Backdrop" images, as they're called, weren't always customizable on Android TV.
How To: Upgrade Your Dock to Six App Icons on the iPhone 6 or 6 Plus
Like most iPhone users, I place my most essential apps in my dock as it allows for easier access to them from the home screen. Unfortunately, iOS restricts the dock to just four measly apps, but there may be five or six that I really want to place in it.
How To: Get Truly Local Weather Readings from Your Galaxy S5's Built-in Sensors
Your Galaxy S5 is jammed to the brim with all sorts of electronic sensors. These are capable of reading humidity levels, ambient temperature, air pressure, and much more. Yet, while this data is constantly being collected by your phone, there aren't any built-in apps that are capable of displaying much of it.
News: Autonomous, Solar-Powered Fijibot Only Lives to Survive Another Day
Aside from being completely adorable, Fijibot is a completely autonomous robot that automatically seeks out light sources to charge his solar-powered battery. He's built from a 1.5 liter Fiji water bottle, packed with an Arduino Uno, 6 volt solar panel, and an Arduino Proto Shield. His other parts are all off-the-shelf gear you could grab at RadioShack, while the wheels are from a discarded RC car. Fijibot isn't a particularly useful robot, but it's still fun to watch him navigate from light ...
How To: Hack a 64 bit WiFi wireless network using Ubuntu v. 9.04
Oh how we love open source software. If it wasn't for Open Office, we never would have been able to write that seven-page English paper while on our friend's Microsoft Office-lacking laptop during an impromptu road trip to Mexico. And Ubuntu, an open source secure operating system, offers you similar convenience. A much more intuitive computer operating software than your standard Windows or Mac OS, Ubuntu is great if you know what you're doing.
How To: Prevent indoor lighting problems
Prevent indoor lighting problems with these great tips. -When a window is behind the object, bring lights closer to object or use a reflector using the light from the window to create a 3 point lighting effect.
How To: Build a hamster wheel to power your PC
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. We will help you avoid pitfalls and get your project up and running fast.
How To: Apply light sources to 3D models in Photoshop
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to apply light sources to 3D models in Photoshop.
How To: Find and eat wild Watercress without being poisoned
Watercress is an extremely healthy plant when consumed, however it can also be deadly if you select the wrong plant! How exciting. This video will teach you how to recognize the good and bad kinds of Watercress in the wild and use them as an effective wilderness food source.
How To: Make charcloth for easy fire starting with a t-shirt and a metal tin
Charcloth is basically charred cloth (surprisingly enough) that doubles an an excellent tinder source for starting fires. This video will show you how to easily make charcloth out of an old t-shirt, a metal tin, and a fire. Now you'll be able to start fires much more easily at home and in the bush.
How To: Test a breadboard using a multimeter
If you want to start making a basic electronics project by placing power sources and such on a breadboard, you should make sure that the breadboard will work first. You can do this by using a multimeter to perform a continuity test on your breadboard, which this video will teach you how to do.
How To: Make a high speed photography trigger with an Arduino
High speed photos are very artistic and look awesome, but taking them without special equipment is nearly impossible. Without this hack and an Arduino, that is. This video will teach you how to use an Arduino and other electronic components to make a DIY high speed photo trigger and take more awesome shots.
How To: Use an Arduino to make a proximity-sensing Jack-o'-Lantern with LED lights
The Arduino Ethernet Shield is a wonderful device for DIY electronics projects, and this project is really creative and awesome. In this video you will learn how to use an Arduino, a promixity sensor, and some LED lights to make a proximity-sensing, LED-lit, evil Jack-o'-Lantern that will terrorize your neighborhood and probably get stolen if you don't watch it like a hawk.
How To: Collect all three Star Coins in New Super Mario Bros Wii World 2-6
Finding all of the Star Coins and other hidden collectibles in Mario games is half of the fun of the title and their main source of enduring replayability. Watch this video to learn how to get all three Star Coins in World 2-6 of New Super Mario Bros Wii.
How To: Make hydrochloric acid from sodium bisulfate and table salt
In this home-science tutorial from WonderHowTo favorite Nurdrage, you'll learn how to create hydrochloric acid using 140 grams of sodium bisulfate, a pH lowering compound available in most pool stores, and 60 grams of sodium chloride salt and an external heat source. Watch for a full demonstration of the process and complete, step-by-step instructions.
How To: Identify the cause of a noise coming from your car
When cars start to get older, their many fragile moving parts start to make noises they never made before. Sometimes, when your car starts making a new noise, it can be very difficult to identify what is causing the noise and what you need to do to repair it. This video offers some great tips for finding the source of different kinds of car noises, from engine noises to suspension noises.
How To: Use gray cards to find white balance, exposures & more on a digital SLR camera
This fantastic, in-depth video dives into the gray card in probably every imaginable way that you could think using the Nikon D3 . Going over various different lighting it can be used for, custom white balance for preset manual, gray source point for white balance correction, accurate exposure in spot metering mode, and adjusting the camera's LCD display brightness, on top of a ton of information!
How To: Manage your contacts on Android cell phones (2.0)
The Contacts application on Android-powered cell phones provides a powerful way to manage your address books and keep in touch with friends and family. You can even add and manage multiple accounts from various sources. Watch these tips from Google to learn who to get the most of the Contacts Android app.
How To: Create animations with objects using Flash CS4
Creating cool animations is the bread and butter of Flash. This video will help you get started making them yourself for your website, video game, or movie. It explains how to animate objects, making them move around however you wish and form the basis of your animation. No source files needed, just make some circles and get started!
How To: Enable multiple key detection with Actionscript 3
Flash Actionscript 3 is a wonderfully powerful, but somewhat obtuse, tool for creating websites. This video will teach you how to use one particular function in the language, creating a class that has multiple key detection enabled. This will allow you to create a website where users can key in multiple inputs and the website will respond appropriately.
How To: Make a collapsible panel with Spry in Dreamweaver CS4
Use Adobe Dreamweaver CS4? See how to create quick-and-easy collapsible panel using the open-source Spry Ajax framework. Whether you're new to Adobe's popular WISYWIG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS4 workflow, you're sure to be well served by this video tutorial. For more information, including a step-by-step overview, watch this free video guide.
How To: Cook roasted branzino with lemons
Bring a genuine taste of the Mediterranean with this killer recipe for branzino with lemoms. The only way to get it more authentic than this is if you get directly from the source. Bring that flavor home with this video from The Food Network.
How To: Get started with VoIP using Asterisk
Kevin Rose is joined by John Todd, a well known, leading Asterisk expert, to introduce you to the amazing VoIP (Voice over IP) world of Asterisk, the open source voip telephony toolkit. In this episode, Kevin and John take you through the installation and configuration of this powerful tool, and show how it can be used to give anyone complete control over their phone experiences, such as voice over wifi, eliminating phone costs, choosing from hundreds of VoIP providers, creating your own voic...
How To: Set up butterfly lighting for photography
Mark Wallace explains how to set up butterfly lighting (AKA Glamour Lighting; AKA Paramount Lighting)with three light sources. This video shows a nice soft lighting underneath the nose. Used if you want to create a strong powerful look, or if your subject has strong cheekbones or jawline. This type of lighting was used in the filming of "Sin City".
How To: Free your iPod with Rockbox
This how-to video will help you expand your iPod library. Rockbox turns your iPod into a FLAC- and OGG-playing, open-source monster. Learn how to install this custom firmware on your iPod to enable it to play all sorts of audio file types and even games. Watch this video tutorial and learn how to free your iPod with Rockbox.
How To: Paint shadow lines on a model car
If you want to paint shadow lines on a model care you should first realize that you can pair this technique up with any other technique you want to for different effects. Shadow lines occur when the out lines get thick and it provides a contrast to make something pop out. Shadow lines will focus on the light source. You want your shadow to be realistic so you want to think about where you light source will be. To paint on shadows lines, focus on where the light source is coming from and darke...
How To: Make a dramatic spotlight from a household lamp
In this video tutorial, viewers learn how to make a guerilla spotlight using household items. Users will simply need a cardboard cylinder and a light source. Te materials used in this video were a toilet paper roll, piece of aluminum, gaff tape and a lamp. Begin by cutting a couple of 90 degrees slots in the middle of the foil, slide in the tube ad secure it with tape. It should be a bit longer than the tube. Now wrap it around the light source. This video will benefit those viewers who produ...
How To: Install Installous on your iPhone and iPod Touch
This video shows the method to install 'Installous' on your iPhone and iPod Touch. The first step involves opening up 'Cydia' on the iPhone or iPod Touch. After opening Cydia go to manage and then go to the option of 'Sources'. The resultant window will show an option named hackulo.us. Add this cydia.hackulo.us to the source. The resultant window which opens shows various sections. Find the section of Hackulous in the window. Go to the Hackulous section and find the option of 'Installous'. In...