Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Mac ...more
Want to stay up to date with the emails in your inbox? Most mobile phones, like the Samsung Instinct, have an email feature and internet capability to keep you connected. Watch this video cell phone tutorial and learn how to send and receive email on a Samsung Instinct. Check ...more
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great featur ...more
Prank Calls, Masked NumbersWho is calling your phone or your child's? Pranksters use a lot of tricks to make sure they can get on your nerves. Being able to trace prank calls is important because you're not going to learn much from your Caller ID, since most prank callers use ...more
Want to stick it to your mobile carrier by porting your cell number to Google Voice? Now you can! On Wednesday, January 19th, Google Voice began allowing select users to transfer their personal numbers to Google Voice for a one-time fee of $20. Though the feature is still in ...more
Sputnik, Apollo and the Space Race. If you watched the State of the Union address last night, you probably heard President Barack Obama mention those three things. The Space Race was an informal bout between the Soviet Union (USSR) and the United States (USA) over the ascenda ...more
Did you know that you can use Gmail to make free phone calls to anywhere in North America? We're not talking computer to computer, but actual free phone calls to cell phones and home phones. All you need is a Gmail account, a microphone, and speakers plugged into your compute ...more
There’s a good chance that you’ll be alone in life one day, and no... I’m not talking about a couch-bound, dateless loser with a pocket pussy and a bag of potato chips. I’m talking about alone. In the wilderness. Hungry. Cold. Lost. You can’t stay in one place too long, so it ...more
For me, the idea of a smartphone with internet access was overkill for a cell phone. Wasn't that what my computer was for? Do I really need immediate access to the web? Must I update my Facebook every hour, from the palm of my hand? Do I need turn-by-turn directions from Googl ...more
In a recent arbitrage tip, we showed you the secret to making money fast by buying and selling the same thing over and over again on eBay. But there's one thing you need to know about the buying part—get the lowest price possible! This article aims to show you some of the best ...more
Battery life is a constant problem with cell phones today, and the Droid smartphones running Android software are no exception. If you want to learn how to get the most out of your Droid battery, then check out this helpful video that provides 8 tips on cutting battery-eating ...more
Check out this video tutorial on how to take apart the HP iPAQ hw6515 Mobile Messenger cell phone to remove the screen for replacement or other minor repairs. See how to completely disassemble the cellular phone for all of those down and dirty fixes you need to repair.
In this tutorial, learn all about Swype. Swype is an app that you can add to your cell phone to make texting and e-mailing lightening fast. Say goodbye to tap texting - with Swype you just let your finger glide on the keyboard until it creates your desired word. Check out this ...more
Swype is a brand new way to send text messages and e-mails from your cell phone. In this clip, learn how to use this new tool to send the world's fastest messages. With Swype, your fingers will never leave the keypad so you can type in half the time. Check out this tutorial fo ...more
Want to protect your investment and add some personal style to your cell phone, but aren't quite sure how to install that cool new skin? We've got you covered - just check out this quick video on how to install and remove an iPhone case. If only getting ready for work could be ...more
Check out this Greener Business Show video tutorial on how to make a portable solar powered USB charger with an LED flashlight inside an Altoids tin can. You will see in this episode how to modify a solar path light into the Altoids tin so that you can have a nifty LED flashli ...more
Not all of us were born with Covergirl skin. In fact, we can bet that even most Covergirls (that's right Drew, even you) weren't born with perfect, front over skin. While we can use products that help exfoliate away dead skin cells and create a brighter glow, sometimes our ski ...more
Traveling often is super fun, but sitting through 13 hours on the flight from California to Bangkok is killer on your skin, especially since the airplane recycles air and therefore dries out your skin. To learn some tips on how to keep your skin fresh and hydrated on the plan ...more
Pectin, which comes from the cell walls of plants, is used as a primary gelling agent in many james and preserves. Most jam makers go to grocery stores to purchase pectin in powder form, but it's much healthier to make it yourself. Check out this video to learn how to produce ...more
We all have our reasons for erasing personal data from a phone. Whether you just ended a bad relationship whose face you never want to see again (lots of text messages) or just want to restore your privacy on the cell phone, erasing may be your only option. But make sure you' ...more
You might be confused when using Swype and need to use punctuation marks. Have no fear! It is actually quite easy. Swype is a revolutionary new app that is available for lots of newer smartphones that allows you to type messages without ever lifting your finger from the keypad ...more
In this clip, learn how to tether your rooted Droid to a WiFi network and use it as a modem for your other Wireless devices. This process is pretty easy and only requires a network and that your phone be rooted. Step 1: Just download the Wireless Tethering APK to your compute ...more
Snake cams have become the epitome of high-tech gadgets on television and in movies. In 24, Jack Bauer is always using a snake camera to check for terrorists on the other side of the door. The video game Splinter Cell has made the snake cam an integral part to Sam Fisher's ars ...more
G-mail can do a lot of things. It is a state of the art, awesome e-mail system, and to top it all off now you can learn to send text messages through it - for free! In this helpful tutorial, learn exactly how to use your very own e-mail account to keep in touch with your frien ...more
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in ...more
An emergency battery charger for your mobile phone comes in handy, but it's not the ultimate solution; once it's dead it's useless (what a waste). If you want to really get off the metaphorical grid, you can follow the steps in this video to construct a more robust circuit tha ...more
Check out these educational videos for veterinarians and curious eyes on the anatomy of the male reproductive tract in the bull. Here you will see, in three parts, the scrotum of the bull, which contains both of the testes. The scrotum is a thinner skin area of the rest of the ...more
No matter how careful you are and no matter how steady your hands, it's inevitable that you'll drop things you don't want to drop. Your cell phone, your keys, your wallet, and sometimes your portable video game device are all liable to get floored - and scratched. But sometim ...more
Kipkay is at it again with his pranks. In this video, he shares four fun and easy pranks that anyone can do to drive their friends (or victims) crazy! Their all very simple. They include a cell phone prank, a floss prank, and more! #1 - Confetti Kablooey For this prank, you ...more
So, a lot of people seem to be having trouble rooting their Motorola Droid X smartphone from Verizon Wireless using ADB (Android Debug Bridge). Well, there is an alternative for those having problems with the ADB version. You will need to have a Wi-Fi or Bluetooth widget handy ...more
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. Search Systm on WonderHowTo for more DIY episod ...more
Make sure you use FLASH Player 9 First: Deinstall Flash Player 10 -- http://kb2.adobe.com/cps/141/tn_14157.html Second: Install Flash Player 9 -- http://kb2.adobe.com/cps/142/tn_14266.html How to hack Coins & Gourmet points in Restaurant City? Step 1: Let all your employees be ...more
One of the coolest feature of the 3G iPhone is the high speed, always on, Internet connection. Having a constant connection to the Internet is pretty much a must have for any dot com mogul. The main problem with the iPhone is the screen is too small to do any serious Web surfi ...more
Check out this interactive video tutorial from Verizon Wireless on the Samsung i730 mobile phone. If you have just purchases this sleek cell phone, here's your chance to learn everything you can possibly know about it. The versatile Samsung i730 is the ultimate multitasker. I ...more
Check out this educational science video tutorial to learn the steps to properly culture myeloid dendritic cells from bone marrow precursors. Myeloid dendritic cells (DCs) are frequently used to study the interactions between innate and adaptive immune mechanisms and the earl ...more
Are you getting that nasty "Application access set to not allowed" error on your Nokia 5300 cell phone? Unfortunately, it's a problem for most Nokia 5300 owners, ones who wish to use 3rd party applications on certain carriers, like T-Mobile, who restricts the uses for branding ...more
Introduction In this article you will find instructions to replace a broken LCD screen of a LG KF600 phone. To execute these steps a new replacement LCD should be bought beforehand. Stores that sell replacement KF600 LCD screen can be found on the Internet. These instructions ...more
The PlayStation Phone is almost here, and the hybrid device from Sony Ericsson is rumored to have Android 2.3 (Gingerbread) as its mobile OS. YouTube user xxmajstor managed to get his hands on what is said to be the Sony Ericsson Zeus - Z1 PlayStation Phone. Below is the spy v ...more
The DROID 2 from Motorola came out last August, but it's just now exploding— literally. The 33 News reported yesterday that a Motorola DROID 2 smartphone exploded in the hands of Aron Embry from Cedar Hills, Texas. He was making a phone call outside his home when he heard a PO ...more
First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more
It's 1976. The hottest arcade game on the market is Blockade (or Blokade), an 8-bit maze game for 2 players. You and your opponent must move your characters around the screen in 90-degree angles, leaving a solid line behind them. Whoever runs into one of the solid lines first, ...more
Don't make people around you wish that cell phones had never been invented. Mind your manners by following a few simple rules. You Will Need * Consideration * Common sense * Consideration * Common sense Step 1: Don't answer your phone Don’t answer your phone and start chatti ...more
Ever wished you could check your cell's voicemail online? You can, for free, with the YouMail web application. In this tutorial, you'll find step-by-step instructions for signing up the the YouMail service. For more, or to get started signing up for you own YouMail account, ta ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
First, we'd like to congratulate Marek Antozi, the winner of our very last Giveaway Tuesdays! Photo Challenge. Thankful for Dialogue is a concept most family members can relate to—the occasional stressful Thanksgiving bickering and inevitable resolution is not uncommon, after ...more
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His exa ...more
Blackberry pioneered the idea of taking email with you wherever you go, as long as you're shackled to that Blackberry. Checking email is so easy from your Curve, so you can send and receive messages anytime, anywhere. Watch this video cell phone tutorial and learn how to send, ...more
Take a look at this video if you've ever been curious on how people send video messages via the iPhone. This is the source you need to get in Cydia iphonevideorecorder.com/3 This is the Unlock code for the app: xumiqdikni Here is a list of some Cellphone email address forma ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
By now, many of you may have heard about iPhone tracking and recording your location data, but is there anything else being extracted from cell phones without our knowledge? If you're a Michigan state resident, the answer is an alarming "maybe". Michigan's police department h ...more
In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one ...more
In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be ...more
WonderHowTo is made up niche communities called Worlds. If you've yet to join one (or create your own), get a taste below of what's going on in the community. Check in every Wednesday for a roundup of new activities and projects. This week: Create a redstone calculator in Min ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation t ...more