In excel a left click is made on box A1 and the X title is typed in as year. In A2 the year 2001 is typed and in A3 the year 2002. Both A2 and 3 boxes are highlighted and the bottom right hand corner is used to drag the work into a copied sequence down to A12. In B1 "populatio ...more
Need a unique gift idea for the techy person in your life? Look no further than that phone they always have in their hand. There are plenty of great accessories, apps, subscriptions, and other smartphone-related goodies that will improve their quality of life, and thoughtful g ...more
Watch this instructional video on how to coat detail work around boxes and pipes with joint compound. Spackling drywall is a delicate art, but anyone can create a perfectly smooth surface with a metal putty knife and a fresh bucket of spackle. Learn how to lay dow thin coats o ...more
LEDs have slowly become the standard for DIY lighting projects because they consume less power and last way longer than regular light bulbs do. Light-emitting diodes have no filament, meaning they generate their light solely by the movement of electrons in a semiconductor mate ...more
Whatever the occasion, a multicolored rainbow cake is sure to delight everyone! Luckily, the recipe is easy and this tutorial will show you how to create a colorful dessert step by step. You Will Need • A large mixing bowl • 6 small mixing bowls • Two 9-inch round cake pans ...more
Although they're often times the primary source of income for websites, on-site advertisements can annoy even the most tolerable reader. That's why ad blockers have been some of the most popular downloads on Firefox and Chrome for some time now, demonstrating that when it come ...more
Everyone is drawn to a box of pizza- the possibility of fresh, hot, cheesy goodness is simply too great to be ignored. So if you are looking to pull a prank on someone, the pizza box is the perfect lure.
Ready or not, the USB-C cable is about to take over your electronics. The new industry standard is fully reversible and packed with enough power to serve as a laptop charger or an HDMI cable, so it actually has the potential to replace every cord, wire, and connector in your ...more
Merge VR, a company mostly known for its virtual reality experiences, is moving into and creating an augmented reality experience that combines an iPhone or Android smartphone, a set of goggles to put your phone in, and a box about the size of a Rubik's Cube which looks more a ...more
This Adobe Illustrator tutorial demonstrates the basic shape modes in path finder (add, subtract, intersect, and exclude), and shows how to use the direct selection tool and expand features of Illustrator. Finally, a bubble box is created (for the Yahoo Map project) with the a ...more
IFTTT is an application that allows you to automate certain tasks on your iPhone or Android. It can communicate with a myriad of apps and services on your phone by creating applets that perform actions automatically — actions you'd normally have to do manually. Finding those a ...more
There's a new macOS vulnerability that hackers within physical reach of your computer can use to gain root access to your system and accounts. Just by using "root" as the username and a blank password on a privilege escalation prompt, someone can install malware on your comput ...more
It is finally happening. After not having a major update since August of 2016, HoloLens owners everywhere will soon get a number of new features added to their devices. At least if they are members of the Windows Insider program. Throughout 2017, the Mixed Reality Team at Mic ...more
Just as the Transformers animated TV series of the '80s were basically half-hour commercials for toys, a new Transformers AR app for iOS similarly functions as a promotion for the latest installment in the film franchise. Paramount Home Media Distribution has published an ARK ...more
Choosing the right gift for your friend or girlfriend is obviously the most important part of gifting, but you can make your gift extra special by wrapping it in a lovely package. Watch this tutorial for a demonstration of how to make a paper gift box. This tiny origami-like ...more
There's a never-ending selection of app launchers that want a permanent spot on your Android device. While some keep the stock-Android look with beefed-up versions of Google's launcher, Blur is relatively new on the scene, with a unique approach to app management that sets it ...more
In this video, we learn how to get rid of bed bugs using a steam cleaner. First, you will need to purchase a simple steam cleaner, which will produce steam that is hot enough to kill bed bugs. Now, take your steam cleaner and let it heat up for twenty minutes. Remove all your ...more
Gboard is often considered the best keyboard for iPhone or Android. Google made sure to jam-pack it full of features, and you should expect nothing but the best when it comes to Google's own first-party software. But with so many capabilities, a few things might slip through t ...more
This video gives a ten minute tutorial on how to achieve the superimposition effect for web videos with a little props and software. You will need to get Wax, a free nonlinear editing system for Windows that includes the chroma key effect. You will also want to get the codecs ...more
If you have any little ones in your life (or you're simply a grown-up kid yourself), Just Bento has has posted Maki's Top 10 Bento Rules for Back-to-School. Rules listed below, click through for full explanations. If you're inspired, explore Just Bento or another WonderHowTo ...more
This video is about singing better by optimizing your voice's resonance. The resonance in your body is determined by the cavity that resonates. Relax your voice box and let it resonate with an open space. The bridge-to cross the bridge, use the sound "Na". Na, na, na, na, na, ...more
You never know when the mood for a party will hit, and lazy summer days are perfect for hosting impromptu gatherings in the backyard. That's why it's always important to be prepared with plenty of drinks, cool snacks, and ingredients for crowd-pleasing appetizers. Keep puff p ...more
Check out this video tutorial on how to transfer music and video media from iTunes to your device with Nokia Media Transfer. Before you begin, make sure that you selected "Enable iTunes Folder Transfer" during the Nokia Multimedia Transfer setup. If you did not, you can selec ...more
We're officially seeking Null Byters on a weekly basis who are willing to take the time to educate the community. Contributors will write tutorials, which will be featured on the Null Byte blog, as well as the front page of WonderHowTo (IF up to par, of course). There is no ne ...more
Mirig Golan demonstrates how to make a box in origami. To start, you take a piece of paper and fold it, so that it is in the shape of a triangle. When your box is in the shape of a hexagon, you fold the triangles in.
Music is definitely more immersive when it's accompanied by a bit of visual stimuli, which is why CyanogenMod and other custom ROMs have started integrating music visualizers into elements of the Android system UI. It's a great effect, but it's not necessarily something that's ...more
WonderHowTo is made up of 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: A phoneography challenge on silh ...more
Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down bo ...more
Introduction to the Basics of Off-Camera Flash There are a lot of resources on the web for using your flash. For Nikon shooters, the Strobist and Joe McNally are the best resources. For Canon shooters, maybe Syl Arena is the best. It doesn’t matter because if you are a Canon ...more
Use a box of self adhesive vinyl tiles to make a mosaic counter top for a wet bar. This is a great way to spice up an old formica counter top without spending a lot of money. Each box of vinyl tiles comes with 225 tiles.
Sometimes going ghetto is the best route, especially when you can save about $1200 big ones. Just ask the guys over at 1 Block Off the Grid. When they needed a fancy Mac to run Adobe After Effects, they decided to Hackintosh it. Meaning they built a Mac in a box -literally (a ...more
Every fall, we can expect a few things: leaves changing colors, cooler temperatures, and Samsung and Apple releasing new phones that fanboys and fangirls will argue about until the following year. This year, Samsung is mixing it up, releasing two phones in the Galaxy Note seri ...more
While Sony as a company is well-known in the United States, it smartphones are not. For years, Sony has stuck with a boxy design with sharp edges and large bezels — however, they're finally getting with the trends. As a result, the Xperia XZ2 Premium offers a rare combo: A sup ...more
If you are so good at solving Rubik's Cubes that your cube is starting to show signs of wear and tear for your excessive, fast solving, give yourself a pat on the back. You are really smart. But not your cube is sticky and the stickers are falling off! Don't let your pride and ...more
This video tutorial will show you a detailed way to make fire with steel wool and a battery. This is a great way to start fires on camping trips or for emergency situations. Just makes sure you carry some steel wool and a 9V battery on you at all times, or maybe just in your r ...more
Apple Card has generated quite the buzz since its March 2019 announcement. The iPhone maker's new credit card pairs with Apple Wallet on your device, is simple to sign up for, includes enhanced security over other cards, has zero fees, and provides daily rewards right to your ...more
In this tutorial, we learn how to make last minute Halloween costumes. To make a Kraft singles costume, you just need a large foam mat, then spray paint each half yellow. Cover it with a tarp, then add on a Kraft logo. You can also place a box over a girl, to be a chick in a b ...more
When I watched the first Cincinnati Bengals edition of the HBO series Hard Knocks back in 2009, among wide receiver Chad Johnson's bravado and attention-grabbing antics was a segment on backup quarterback Jordan Palmer and his newly-developed app, which was still in its infanc ...more
If you have never dealt with wire color-coding then Old64goat takes you through a very elementary tutorial that will give you the helpful aid needed to deal with common household wires. The first cord that is reviewed is the three pronged cord. The color wires contained within ...more
In the U.S., smartphone users spend more time on Facebook and Instagram than on any other app. If this sounds surprising for any reason, it shouldn't. Anyone that's browsed Instagram in a moment of boredom knows that a few minutes can quickly turn into an hour down a rabbit ho ...more
This video tutorial shows how to fold a square box using Origami techniques and paper. Learn how to use the traditional Japanese art of origami to fold a simple, square box.
While some of the additions to the emoji keyboard in iOS 8.3 have been criticized for actually doing the opposite of their intended purpose, they've been well received overall. But the biggest winner of the new emojis was one that actually wasn't even released—the "Vulcan salu ...more
We've seen all the Magic Leap One glamour shots, and we've even shown you a bit of what it looks like to view augmented reality on the device. But there's something else us super geeks appreciate more than anyone else: the grand unboxing! I met Magic Leap's Enjoy representati ...more
In this video, we learn how to create a modern bokeh effect in GIMP. First, start a new image and then change it to the size that you want. From here, click on the paint can and then fill your box up with a color. Then, create a new layer and name it "bokeh background". Click ...more
This video shows you how to easily set up Bluetooth on your Motorola Droid phone and use it with a Bluetooth headset. The first thing you have to do is go to Settings and then go to Wireless and Networks. In the pop up menu, you have to go to Bluetooth settings and check the f ...more
In order to unlink your Google account and your YouTube account, you will need to go to Google. Click on My Product. Then, click on Edit. Next, click on "Close the account and delete and all services linked to the account". Check the box that says YouTube. Scroll down to the p ...more
Getting a professional to properly measure your feet is typically part of the bespoke footwear buying experience. If you are buying shoes or boots online, however, you will need to take accurate measurements of your own feet with the help of a friend to ensure a proper fit. H ...more
Pancakes are a favorite breakfast item so why not learn how to make them from scratch. Toss out the store bought box of pancakes and make your own batter. Watch this how to video to learn how to make basic pancakes from scratch.
Learn how to use the smoker box feature on your Lynx Grill. The Lynx grill has many innovative features and understanding how to use each grill feature can make you more proficient user of the grill.
I've possibly been really out of it for a long time not to have realized that Instagram has a bunch of hidden filters. Clarendon seems to be by number one filter for pics and videos, but maybe that's exactly what I've been doing wrong. To access these wonderful secret filters ...more
A Christmas present is not the only thing you can get crafty with. Why not put that mix tape into a homemade origami box for a truly personal touch? This tutorial shows you how to origami a six-pointed star box. The shape is perfect for both Hannakuh celebrations and Christma ...more
Since the Razer Phone's announcement in 2017, we've seen a new subgroup of phones emerge. Gaming phones are now a thing, leading to companies like ASUS creating phones that are thoroughly optimized for the mobile gaming experience. And with their second iteration, they perfect ...more
Straight, sleek hair is forever gorgeous, but sometimes you have to think outside of the box and stand out from the sea of girls wearing pin-straight hair. For days when you feel like putting some actual effort into your hairstyling and looking put together, try this voluminou ...more
How to Make a Firecracker Out of Things That Any One Can Get. First Gather Your Equiptment, You Will Need: Matches and a Match Box or Flash Powder, Hot Glue Gun, Sparklers, Paper, PVA Glue, Container, Masking Tape. Step 1: Video: .
How much you've actually spent and how much you think you've spent are usually two completely different results, and is especially true on Amazon when it's so easy to click and buy. You might think you've given Amazon a couple thousand over your lifetime, when the fact is that ...more
If you didn't get the memo, passwords aren't enough protection for your online accounts. Even a long and complex password offers only one line of defense which can falter. Two-factor authentication adds an additional layer, bolsters your defense, and decreases the risk of your ...more
Learn how to enable Java script and Cookies in Konqueror in simple steps. First open the respective webpage and go to 'Settings' option and select the last option in it. Now select 'Java and Java Script' option found in the left corner of the page and click in the enable check ...more
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 use the keyboard on the Apple iPhone 3G. The iPhone redefines what a mobile p ...more
A long time ago, we recommended the Hover Zoom extension for Chrome as an easy way to blow up small image thumbnails without actually have to "click" on the images themselves. Over the past year, there have been reports that Hover Zoom now collects and sells your browsing data ...more
Slack is meant for business, but it's inevitably used for personal reasons too, or even just to goof off with colleagues. However, you never know who's looking over your shoulder (nosy coworker? boss?), and you could get in trouble for something sent to you. That's why you mig ...more