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 checked. Now, you will not be able to select cells in the worksheet except cells that are unlocked. This is a great way to protect your information, so it won't accidentally get deleted or ruined. You can do this for ent...
Being able to pick a lock is considered to be a rite of passage for boys, especially those with aspirations of becoming a professional pirate/ninja, also known as a computer engineer.
There are many moves to learn in jiu jitsu. The ankle (or leg) lock is one of the most fundamental, and most effective. In this video, Scott Marker of Submissions 101 will be your guide as you learn about the jiu jitsu ankle lock.
This is a straight forward demonstration of how to pick a lock with a 2 in 1 pick. Locksmiths use this tool. This is demonstrated on an old school lock, not a schlage.
Studying to be a nurse? Then a very common procedure in nursing involves removing a saline lock or an IV line. This procedure is also called DC IV, or discontinue an IV. Follow along in this nursing how-to video to learn the proper protocol for discontinuing a saline lock. Before DCing the IV always double check the doctor's orders.
Watch this instructional carpentry video to woodwork a lock miter joint with a lock miter bit and set up block. Join materials at 90° by cutting a 45° miter and a matching tongue and groove glue joint. This joint not only increases mechanical strength, but also increases glue surface area and automatically aligns parts.
This photography tutorial shows you how to make a better shutter release lock for Diana Plus and vintage Diana cameras. This is helpful for low light situations and long exposures. You can make a replacement shutter release lock with a clothes pin and a file. Have fun taking night photographs with this handy tool.
Check out this instructional con video that demonstrates how to make an auto tension wrench that's great for lock picking. Follow the simple instructions outlined in this tutorial video. Make a two sided tension wrench with this video and start lock picking like a pro today!
Here is a shoulder lock from the open guard (basically an ude garami or maki hiji lock) that Frank Mir pulled of against Pete Williams. This is a very helpful and effective martial arts technique.
Watch this video to learn how to pick a trie circle lock with a woman's electric shaver. This lock pick technique only takes seconds.
So, you've found yourself in a hotel room, and for some reason you just have to remove that cable from the wall. However, it is protected by a cable lock. In this instructional video, see how to defeat these using a piece of toilet paper, a pen, and the cable lock itself!
Professor of RVing, Jim Twamley talks about lock security and shows you how to replace an RV entry lock.
Most of you are familiar with using Ettercap for attacking systems, but what about using it to find attackers? This tutorial will cover using Ettercap to find people sniffing on your network. The plug-ins we will be using are search_promisc, arp_cop and scan_poisoner. Have fun detecting network sniffers. Detect hackers on your network with Ettercap.
This tutorial shows you how to use the Pixelchooser feature of the Boris Continuum Complete and Final Effects Complete plug-ins for Premiere Pro CS3. Use the Boris plug-in Pixelchooser in Premiere Pro CS3.
Learn to execute a Jiu Jitsu Omoplata Shoulder Lock, a leg-over-shoulder lock done from the guard position.
Aharon Rabinowitz shows you several popular techniques and tools for creating 3D extruded text in After Effects. Some of the solutions he discusses are the shatter effect, plug-ins like Zaxwerks and another shadow and RGB value method. Create 3D extruded text in After Effects.
In this tutorial, Creative Cow Leader Aharon Rabinowitz shows you how to create the coveted Film Flash transition in After Effects, without the use of any 3rd-party plug-ins. Create the Film Flash transition in After Effects.
In this short After Effects tutorial, Jerzy Drozda Jr (aka Maltaannon) demonstrates creating some cool volumetric lights without any plug-ins. So try it and enhance the "look" and "feel" of your projects by lighting them a little bit. The project files are also available on the site. Create volumetric lights in After Effects.
In this video tutorial, animator Traylor Woodall demonstrates how to create 3D text or logos in Adobe After Effects without 3rd party plug-ins. Create 3D text in After Effects.
This tutorial will demonstrate how to use the tools available in Adobe Photoshop to create fire without having to resort to plug-ins. A lot of tools are needed for this effect and some of them are the liquify command, gaussian blur, wind, rotating canvas back and forth and repeating filters. With so much covered, you'll be sure to learn something new from this video. Create fire using Photoshop.
Learn how to do basic popping and hitting, hip hop style. Direct and easy, this fun tutorial will get you up and on the dance floor.
Many have tried to prove (or disprove) that tennis ball lock picking really works, but it still seems up for debate. Mythbusters have supposedly debunked this technique (watch the video). Someone over at the Auto Blog also has tested this car lock method with failed results (watch the video).
Keep your house safe! Learn how to replace door locks in this free home security video from our professional handyman.
Picture it: you wake up in the middle of the night and check your phone. Maybe you want to check the time (your phone is your alarm clock, after all) or see if that person ever replied to your message. You double-tap or lift to wake it, and the screen lights up. You flinch at the bright light, squeezing your eyes shut. It takes a few moments to adjust, even if your screen's brightness is as low as possible.
Widgets are great ... if you actually use them. A quick swipe right on the lock screen will reveal the Today view and its widgets, and it's very easy to accidentally open. Plus, others can see your widgets without any authentication. You could manually remove every widget, but that wouldn't prevent the right-swipe from opening the Today view. There is a way, however, to disable the page entirely.
If you like having Siri available to answer a quick question every now and again but don't want everyone who picks up your iPhone to also have access to your personal assistant, there's an easy way to disable her from working on your iPhone's lock screen. This is also something you can do if you're always activating Siri accidentally in your pocket.
If you're like me, you probably encounter the lock screen on your Android device more than any other screen. Every time you check for new notifications out of habit, or simply pull your phone out to see the time, the lock screen is front and center.
Leaving your computer unattended, whether at home, work, or a coffee shop, even for just a short while, is enough time for someone to steal it or look at your personal files. While there are ways to deter thieves, it's a little harder to keep snoops away.
Aside from being able to change the wallpaper and add shortcuts, the Galaxy S4's lock screen doesn't offer much in the department of personalization. The lock screen is efficient and practical, but it's also a little bland.
With all of the personal data that's stored on our smartphones, it's of vital importance that we have some sort of lock screen security enabled. One of the Galaxy S5's killer features is obviously the fingerprint scanner. It makes the process of dealing with a secure lock screen a bit easier than typing in a password or PIN.
If you lend someone your phone, even if it's just for a second, there's a chance they can enter an app and see something you'd rather they didn't. Whether it's a personal email or a private photo, there are plenty of reasons why you'd want to keep snoops out of certain apps.
Locking up your iPhone with a passcode prevents mischievous friends from looking at your pics and emails, and makes it harder for thieves to access your data before you get around to wiping it. For even more security, there's the password option, which gives you more than just 4 lonely digits.
The iOS 7 lock screen was made to be just that, a lock screen, so it's pretty limited in terms of functionality. We're able to add wallpapers and easily access the Control Center or Notification Center (unless we disable that access through our settings), but other than that, it's pretty bland.
Nine times out of ten, when you pick up your Samsung Galaxy Note 2, you already know what app you're going to be using. If you only have Swipe to unlock enabled, finding that app is as easy as swiping and locating the app on your Home screen or in the app drawer.
Let's say you forgot the code to your Master Lock combination padlock. What can you do besides buy another one? Well, there's a surprising abundance of ways to open a combination lock other than with just the combination, some of which will even let you reset the code. Of course, these hacks aren't limited to folks just looking to open their own locks, but let's just assume that's what you're here for.
In this tutorial, we learn how to pick a padlock with a single paperclip. First, check your lock to make sure it isn't broken, busted, or damaged. After this, take your paperclip and bend it out. Next, use pliers to bend the paper clip into a loop shape. Once you've done this, stick the loop into the lock in the middle and twist it. Play around with the lock for a few seconds and continue to twist until the lock comes unlocked. If it's not working, create a bigger or smaller loop in the paper...
In this tutorial, we learn how to pick a locked door with a paperclip. First, open up your paperclip and then twist the end of it so it's a spiral shape. Then, scrub over the pins and create a spiral shape with these as well. Try your best to make the shape of the paperclip to look like the unlocking saw. Now, take a tension wrench and force it into the bottom of the lock. Then, stick the paperclip into the top of this and turn upwards several times going quickly. When you hear the lock come ...
In this tutorial, we learn how to pick a door lock with a homemade tool. This tool is made with a hacksaw blade. First, take a locked door knob and try to open it. If you can't stick a pin in the bottom of the knob, then push the saw into the middle of the lock as you are turning it. Continue to do this in a fast motion, making sure not to slip and cut your hands. Within a few minutes, the door knob will come unlocked and you will be able to open the door and go into the other room!
In this tutorial, the instructor shows us how to open up a door with a screwdriver. For this to work you will need a locked door and a screw driver. You first will need to take the screw driver and push it under the two latches on the side of the door on the lock. Keep pulling back on the latches with the screwdriver until the door pops open, this can take a few minutes or a few seconds depending on the lock strength. This will work on most normal door locks. Be careful because this will leav...
This video will show you how-to restore a disabled (aka:locked) iPod or iPhone. Your Apple device won't do you any good sitting there dead, so watch this video and see how to bring it back to life. You'll need to connect ot a laptop that has internet connectivity.