Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orie ...more
It's always tempting to grab yesterday's shirt and toss it on in a fit of laziness, but before you do and venture outside, it's probably wise to freshen it up a bit first. The most obvious way to do that is with some Febreze, but if you don't have any around, your liquor cabin ...more
Amazon's Fire TV set-top box has been out for over a month now, and the hacks are starting to come together. Sure you can play your Amazon Instant Video, Hulu, and Netflix content without any issue, but what about your personal media, like movies and music? Today, I'm going t ...more
If you have a modern iPhone, you have an excellent video recorder at your disposal. Every iPhone since the 6S has the ability to shoot in 4K resolution, and each new iteration has brought new capabilities to the table. But even the best mobile shooter can use a little extra he ...more
Every phone powered by a Qualcomm processor has a built-in WCD9xx Audio DAC, but it's rarely configured to be used to its full potential by OEMs. This might not seem like a problem to some people, but if you're a music lover, or you simply enjoy high-quality sound, it's an iss ...more
If you're going to build yourself a water gun to cool down this summer, or maybe just a useful water pump, you'll need some check valves. However, the most expensive parts of a water pump or DIY super soaker are usually the check valves. So, let's make some from scratch for as ...more
Privacy and security go hand in hand, especially for smartphones. When it comes to privacy, you decide what personal information about yourself is out there to discover. Security, on the other hand, is all about enforcing those privacy decisions. Sometimes privacy and securit ...more
There are plenty of apps on Google Play for customizing your Samsung Galaxy S3 with wallpapers and new lock screens, but to be honest, you're not really customizing until you root. Once you're rooted, you have unlimited mods and hacks to choose from to make your device run be ...more
In this tutorial, we learn how to get a free soft drink from a vending machine. First, you will need to find one of those old vending machines, not one of the new and high tech ones. From here, you will need to sit down and lift the hatch up from the machine. Then, reach up in ...more
Nothing has stopped you from taking a screenshot of a funny moment in a FaceTime video call before, and nothing probably will. But screenshots are old news. Apple has made it even easier to take capture FaceTime moments on your iPhone, and the results are more lively. Unlike ...more
It recently came to light that a number of Android phones are unable to stream HD video through services like Netflix, Google Play Movies, and Amazon Prime Video. If you're worried that your phone may be affected, there's a simple tool you can use to find out for sure if you c ...more
Like looking for lost treasure? There's no need to break the bank for a high-end metal detector — just dig through your junk drawer! In this video tutorial, KipKay shows you how to make a metal detector from a calculator, an AM or FM radio, a standard CD case, and some velcro. ...more
When learning Wi-Fi hacking, picking a compatible Wi-Fi network adapter is the first step to learning to crack Wi-Fi passwords. Many compatible adapters have swappable antennas, and there are several different kinds of specialized antennas you can add to a network adapter to ...more
While photography usually gets all the love, our phones have gotten really good at capturing video. Think about it — when was the last time you needed a camcorder for a vacation? With mobile cameras getting better each year, we're now at a point where smartphones can be used f ...more
Surveying a target's Wi-Fi infrastructure is the first step to understanding the wireless attack surface you have to work with. Wardriving has been around since the '90s and combines GPS data and Wi-Fi signal data to create accurate, in-depth maps of any nearby Wi-Fi networks ...more
This video tutorial is for educational purposes only. See how to pick a normal lock with a tension allen wrench and a small screwdriver. "Lock picking is the act of unlocking a lock by analyzing and manipulating the components of the lock device, without the original key. Alt ...more
If you're like me, then you were a little disappointed after updating your Nexus 7 to KitKat and realizing that not much has changed. The old Jelly Bean look still occupied your home screen, and there wasn't really anything noticeably new overall. All of that waiting and antic ...more
Update (March 18, 2014): Skype has issued an update to their Android app, and among other things, has "fixed" the runaway camera process issue by creating a workaround...and that's about all we know. No details were provided, but with the considerable uproar over the bug, let ...more
CityVille Guide So you want to win CityVille, or maybe just pass up your friends? Here are a few simple tips to help get you the results you want! Scroll to the end for charts (you know you love charts!!) This information subject to change at any time. CityVille is a brand ...more
Planning on getting the iPhone 5, but want to keep your SIM card? The new nano-SIMs that manufacturers are adopting will be even smaller than the micro-SIMs that most of us currently use. It's fairly easy to cut a regular SIM down to a micro-SIM, but because the nano-SIM will ...more
Check out this home repair tutorial video that demonstrates how to fix and diagnose your appliance. These videos are for information purposes only. A qualified and proficient engineer should be employed to replace any faulty parts on your domestic appliance. Checking to see i ...more
Smartphones have put an end to camcorders. If you want to capture memorable moments in high quality, look no further than that technological marvel in your pocket. Recent Galaxy phones are shining examples of how far we've come — but the more capable a camera gets, the more co ...more
This video gives detailed instructions for removing a hotspot or flash reflection in a photo by using layers and masks. Start by adding a new blank layer and naming it something like Flash Suppress. You will use a special blending mode for this layer called darken. With your p ...more
With the recent death of Osama bin Laden near Islamabad, the whole world has gone crazy for Navy SEALs. Everybody wants to know what it was like for SEAL Team Six to carry out their heroic mission last weekend. Others want to know what it takes to become one. Navy SEALs are t ...more
The agents of empire do not always arrive with warning. When you are besieged, surrounded, and infiltrated, imagination is often your best weapon against the oppressors. If all you have at hand is some duct tape and a disposable camera, fear not, you have the makings of a powe ...more
Though nobody's going to hide the fact that they're getting sloshed on major holidays, you might want to be more discreet when it comes to your morning pick-me-up or lunchtime tipple during the rest of the year. It used to be that having four martinis at lunch was acceptable a ...more
Harvest the sun! This easy step-by-step tutorial will show you how to build your own solar heating/hot water system. Green energy is the wave of the future. Stop high oil and gas prices. All we need is 160°. No drilling, no rigs, no refining, no transportation, a no-brainer. ...more
Keeping your supplies of caps and ammunition high in Fallout 3 is one of the game's biggest challenges. No more! This video will teach you how to use a glitch in the game's shopkeeping interface to attain unlimited caps, ammunition, and free item repairs. You should have no tr ...more
Got a bunch of old, chunky sweaters accumulating in your closet? Of course you can donate them to Goodwill, but we're betting that you can get a lot more mileage out of those babies than you think. Simply take a look at this fashion design tutorial to learn how to turn a Mick ...more
Just happen to have some video footage in AVCHD format? That would be "Advanced Video Coding High Definition"—you know—HD video files. If you've got some of those MTS files (like from a Canon HG10 camcorder) you want to open in a program that doesn't support them, like QuickTi ...more
Many people don't realize much better audio can sound on their phones. While it's solid to begin with, Samsung has included several options in the Galaxy Note 10+ that will upgrade your listening experience to profound status. While sound quality is somewhat subjective, there ...more
A car is stolen every 33 seconds in the United States, and from that, the percentage of vehicles recovered in the first day is a whopping 52 percent. Over the next week, that number rises to around 79 percent, but after those initial seven days are up, it's unlikely the vehicl ...more
Though making hot chocolate out of instant mix is pretty easy, there is no comparison when it comes to making your own homemade hot chocolate out of quality dark chocolate bars, whole milk, brown sugar, and your own favorite fresh spices. Simply chop up a bar or two of your f ...more
Whether you call it chicken-fried steak, country-fried steak, Milanese, wiener schnitzel, or breaded cutlet, there's something irresistible about a piece of meat that's been treated until it's thin and tender, dredged in beaten egg and flavorful bread crumbs, then fried until ...more
I've been a fan of potatoes ever since I can remember... but mainly because they weren't a big part of my daily diet (which usually consisted of rice). And because my experience with potatoes was so limited, I only knew of two varieties growing up: big, brown Russets and sinew ...more
If you have a good food processor or blender, there's no reason not to make your own nut butters, whether you like almond, cashew, sunflower, or the perennial classic, peanut. Not only can you control the taste, sweetness, crunchiness, and oiliness of the butter, you can also ...more
Play the greatest tower, turret defense game ever... Warzone Tower Defense. And learn how to hack Warzone Tower Defense with tricks and cheats. Watch this video tutorial to learn how to cheat Warzone Tower Defense with Cheat Engine (09/16/09). Description of the app on Newgro ...more
Piezoelectric Energy In this article, I'll show you how to make a small, wallet-sized device that generates electricity from kinetic energy. The concept is simple: Piezoelectricity is the charge that is produced when certain solid materials (commonly ceramic and crystal) in r ...more
In this video, learn how to set-up a Canon EOS 7D camera for slow motion. Learn about the settings you need to use to prepare to shoot in one of the high speed modes. To see more of the videos on this subject, check out the parts below, especially on processing the slow motion ...more
This is a short video describing where to place a capo on a standard tuned guitar to make it playable in the same positions and notes as a ukulele. Basically, you place a capo on the 5th fret and only play the bottom four strings. It's difficult to avoid the top two strings, ...more
So you've been playing Call of Duty Mobile for some time but can't seem to get MVP at the end of the battle. Well, since the game is a competition of players and bots, you're in an uphill battle. But you don't have to languish at the bottom. With the help of these tips, you mi ...more
If you ever wanted to tether your iPhone but found your carriers’ prices ridiculously high, then meet HANDYLIGHT. This $0.99 iPhone app has a nice hidden feature. It will allow you to connect to the internet using your iPhone (i.e. tether). There’s no guarantee that this app w ...more
I love to cook. There are few things more relaxing for me than spending an afternoon in the kitchen, and one ingredient that I throw into just about everything (seriously, everything) is garlic. It can instantly add a whole new level of flavor to a dish, and there's not much t ...more
For so many of us, bakeware is bakeware. As long as it's oven safe and able to tolerate the high heat, it's fine to bake in, right? Wrong! Don't Miss: 7 Must-Know Guidelines Bakers Swear By There's more to bakeware than we realize: the different casserole pans, baking sheet ...more
In Minecraft, many people enjoy "Faction" aka "Raiding" multiplayer servers for their unique gameplay and survival aspect. Plus, it's always fun when you find a chest full of somebody else's free stuff. In this guide, written from years of experience with PVP and base creatio ...more
For many, phones are starting to replace televisions as the primary device for watching videos. Thanks to their portability and easy to use apps, it's often simpler to watch Netflix, Hulu, YouTube, or Prime Instant Video on the smaller screen. But not every phone is suited to ...more
Check out this video tutorial on how to make cheap dragon wings, controlled by body posture. You can do this project for $18 if you use plastic garbage bags and Scotch tape for the membranes. You'll see how to make very light and strong costume wings. How strong? That strong. ...more
Wi-Fi devices are continually emitting "probe frames," calling out for nearby Wi-Fi networks to connect to. Beyond being a privacy risk, probe frames can also be used to track or take over the data connection of nearby devices. We'll explain how to see nearby devices emitting ...more
To flip, or not to flip, that is the real question. When you're nervously standing over the stove or grill, what do you do with that steak before you? I always believed that to have a perfect medium or medium-rare steak, I needed to let a thick cut of meat sear on one side fo ...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
I feel like doing a bit of chemistry today, how about you? To my knowledge, thermite is the hottest burning man-made substance. Thermite is a pyrotechnic composition of a metal powder and a metal oxide that produces an exothermic oxidation-reduction reaction known as a thermit ...more
In the recent hit movie Furious 7, the storyline revolves around the acquisition of a hacking system known as "God's Eye" that is capable of finding and tracking anyone in real time. Both the U.S. spy agencies and an adversarial spy agency (it's not clear who the adversary is, ...more
In this article, I'll show you how to make an awesome "Death Ray" using the large magnifying lens from an old projection TV. The lens is called a Fresnel lens; a device that employs several ridges to focus light, rather than a complete curve. When sunlight passes through the ...more
For a photo- and video-sharing app based around privacy, Snapchat sure has a lot of security holes floating around. At one time, you were able to take screenshots of Snapchats in iOS 7 without the sender knowing, which is something that you can still do on rooted Android devic ...more
BEATS by Dr. Dre started making their studio-style headphones and speakers over four years ago, which claim to help listeners actually "hear" music as it was intended by the artists, since commodity headphones and earbuds are known for producing lackluster results. But you can ...more
How do you know if the Beats By Dre Studio headphones that you are about to buy online are genuine? Always ask the seller to use the youVerify app before you buy. Smarter Selling, Safer Shopping. Video: . Step 1: The Retail Box Check the Color of the Headphones on the Box Mat ...more
Tea has been around for thousands of years, and as a result, tons of customs and ceremonies have sprung up around its consumption. Some cultures take their tea plain, while others put things in it. Sometimes there are special tea-holding vessels, other times not. Maybe there w ...more
If you're always taking blurry and underexposed pics with your mobile device, try using some of the tips below to turn your phone into a valuable photography asset. It doesn't matter if you have an iPhone, Android smartphone, or even a first-gen camera phone... you can still t ...more
While change is good, it isn't always welcomed. All software updates with radical redesigns and brand-new features bring at least a few complaints from those accustomed to previous versions. iOS 7 got a lot of flak from iOS 6 users, as did iOS 8 from iOS 7 users. When it come ...more
Like a car, your Mac needs to be monitored and cared for to keep it running as smoothly as possible. While your vehicle comes with a ton of gauges to keep track of your oil, temperature, and in some cases, even tire pressure, your Mac has no easy way to watch for low memory or ...more