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. 3. Select SETTINGS tab from the dialog box appeared.In the ALLOW field select LIST. In the SOURCE fiel ...more
Why type everything twice? If you don't know how to copy and paste you are missing out on an incredible time saver. Check out this tutorial and learn how to speed up your work. You Will Need • Computer • Word processing program Step 1: Position cursor Position your cursor n ...more
Easy steps on how to move and delete items on the LG GW620. 1. To move an item, press and hold the item on your Home Screen. 2. After a second you will feel a slight buzz at which point you can move the item to where you want to put it. 3. Release your finger from the screen t ...more
Clean your basement like a champ. The hardest part of cleaning a basement is working around all that stuff you’ve stuck down there. This game plan will help. Check out this Howcast video tutorial on how to clean your basement. You Will Need * Sponges, both natural and nylon ...more
Welcome to Minecraft World! Check out our advanced tutorials and come play on our free server. UPDATE: Minecraft 1.9.6 has been leaked! It's time for another pre-release folks! This time it's 1.9 Version 5, and it's better than ever. Confirmed changes include: Melons drop ...more
Get the New Google Navigation Menu Although Google introduced the new Google bar last week, I still didn't have the new look yet. I was curious to see if I could find it, and discovered that +Maximiliam Majewski found a workaround to get access to the new Google bar. It's no ...more
In this video from XcodeMod we learn how to make an iPhone app with Xcode. Open up XCode and go to File...New Project. Pick what kind of app you'd like to save it as and come up with a name to save it as and save it to your desktop. Open the Classes folder and go into the AppD ...more
Open the picture you want to edit. Right-click on the main picture layer in the box and then select "Duplicate Layer". Then, in the same box, go to the drop-down menu that says normal, and change it to "Overlay". Then, select Filter>Other>High Pass. In the box that comes up, s ...more
Open your video in Final Cut Pro. Go to Effects>Video Generators>Boris. Then drag the option called Title 3D over your video. Then select Title 3D and go to your controls. Then click on "Title 3D Click for options". Now a new box should be open. Type your text into it. Then, h ...more
This video demonstrates how to change the color of hair, dress, car or any thing of your choice using photoshop. This is really simple. Select the photo in which you need to change the color. Create a new transparent layer. Click on the brush tool and select a brush type with ...more
In this how to video, you will learn how to run Windows programs for free on a Mac using Crossover Chromium. You will need to download Crossover and install it by downloading it and dragging it into the applications folder. You will also need Explorer XP. Go to the application ...more
First create a new 800x600 document and fill it with black color. Then create a new Layer and add a white circle with the hard edge Brushtool Select the 'Eraser tool' and use the same brush (a bit smaller) to erase the inside of that circle. Rightclick an layer 1 and go to the ...more
This was a video on IMovie08 a movie editing program. Inside the IMovie08 program to get started you have to import a video. Once you have imported and opened the video you can begin to edit it. You can easily switch between your event library and the Project library. To play ...more
The Mac OS's Disc Utility allows for the encryption of files. To open Disc Utility click on the magnifying glass (spot light) up in the top right hand corner, and search for Disc Utility. Click on the first result in the list. Once Disc Utility is open, click on "create a new ...more
Did you know that you can zoom in on your Mac laptop just as easily as you can on the iPhone? All you need is your fingers, your mouse and to activate the zoom function on your computer. Check it out! You Will Need * Mac Step 1: Open System Preferences Go to System Preference ...more
Oh no! You've just accidentally deleted an important computer file! Have no fear. When you delete a file on your computer, it is not necessarily destroyed. This video will show you how to search for and restore your file before it is lost forever. You Will Need * A PC or Mac c ...more
To apply this particular Mad Hatter inspired makeup you need to start first by applying a lime green color from the mayron pallet to your lid. Then you just take the brush and feather out the edge you created. Taking sun yellow color from ben nuys, apply it to the inner third ...more
Advance Photoshop shows viewers how to make the Photoshop CS3 icon in Photoshop. First in Photoshop go to File and then click New. Make a new blank at 500 x 500 pixels. Go to your layer button and create a new layer. Next, go to your rectangular marquee tool, hold down shift, ...more
Cross processing is a Photoshop version of slide processing. The result would be you get all these weird color shifts. For reasons best known to people who run the fashion magazines, this look became very popular in the 1990s. Start by adding in a curves layer. Add a new adjus ...more
In this Adobe Photoshop tutorial the instructor shows how to prepare pan and scan images. To prepare an image by panning and scanning is quite different than preparing an image normally for using in your video. These images should be extra sized as you would perform special ef ...more
This video describes how to create an easy glossy button in Photoshop. This is done by "simpleretouch.com" website. First select the "Ellipse Tool" from the Photoshop tool bar and then drag it on the layer; it will give the ellipse shape in the layer. Select the "Blending opti ...more
If you're a Firefox user and frequently use free image hosting services à la ImageShack & Photobucket, then you've no reason not to check out the ImageBot Firefox extension, which does quite a lot to streamline the picture uploading process. ImageBot allows lets you upload yo ...more
Learn how to style a fro-hawk with Petrilude. Petrilude (aka Josh) is a guy that does makeup. You may think taking makeup tips from a guy is strange, but Petrilude is a talented makeup artist. If you are looking for party makeup looks, great for going out to the club, check o ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your octave technique. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all positions, develop confi ...more
Melvin from QZPStudios takes you on a quick tutorial in which he creates an embedded text effect in Photoshop. This could be a useful trick for website designers who want to create banners containing text which have a shadow effect. 1. Create a new photoshop document and unlo ...more
This photoshop tutorial demonstrated by Howard from tutcast.com, teaches you how to do amazing glow effects for your work and projects. Everything you need to know from the background you choose to use to editing out the leftovers. You can use any image that you choose to. Sta ...more
Does your desktop look messy and unorganized?? Are there hundreds of icons in your desktop?? And it takes minutes to just find one?? Try this... See my messy desktop: With a few minutes and a couple of simple and easy steps, you can turn this into a classy and organized vie ...more
Speech recognition software made it easy to search Google on your smartphone, and Google Goggles made it easy to find answers from camera snapshots on your device. But now Google's bringing similar technology straight to your desktop, and with faster results—faster than Google ...more
Need help getting started on this week's WTFoto Challenge? Look no further! In this tutorial, I will teach you how to create simple chalk symbols and writing in Photoshop. So read through this post and try it out yourself—or I'll tell your cousin what you said when you were dr ...more
You've finally got an invite into Google+. Now what? At first glance, things can be a bit overwhelming. We've got some great tips to help you get started. 1. Fill your Circles The circles feature is the core of how Google+ lets you manage your online relationships with your ...more
Do you do last minute cramming before you go to the dentist? No, I don't mean reading up on orthodontia in hopes of having an intellectual conversation about crowns with your dentist (how you can talk at all with all those tools in your mouth is beyond me, though dentists alwa ...more
Photoshop. It’s like a mountain to climb. You can chug up to the top, working hard, never letting up, or you can just go part way up and scoot around the side of the mountain and still get to the other side. Not everyone needs to be a Photoshop guru, or ninja pixel punisher. T ...more
Synopsis: Tell one guy that a girl that one of the other guys knows just had some sketchy demonic encounter/satanic experience at some Wicca gathering she went to last night while she was trying to get answers from the past. Then say she’s incredibly creeped out right now and ...more
The DIY industry is booming, despite the desperate blackmailing of society by finance capitalists. Companies like Adafruit and Makerbot are grossing well over a million dollars a year, and Evil Mad Science Laboratories just recently dedicated themselves to running a full-time ...more
Making your own circuit boards can be a daunting challenge. You have to design a schematic, test it on a breadboard, design the board layout, and then after all of that, you still have to print and etch a board! Luckily, we have Fritzing. Fritzing is a free open-source PCB d ...more
Open windows movie maker and take any video which has the background of same color. Drag and drop the video on to the time line. Then go to tools > video transitions and take the chroma key and drop it between the two videos. The chroma color should correspond to the backgroun ...more
In this Software video tutorial you will learn how to use Daemon Tools Lite to mount an image or ISO file. This is a software that takes ISO files and puts them on a fake hard DVD drive. This is really very easy and simple to do and takes practically no time. Go to start > all ...more
With the LG KU990 Viewty, you can take and view a crystal clear photo. Packed with high-quality camera features, this camera phone enables you to capture a high-definition image using a 5 MP camera lens certified by Schneider-Kreuznach and edit your photo on a large, clear, 3- ...more
There are many video formats and video players out in this world today; and just the same, there are many video converters that allow you to convert your videos to just about any format imaginable. But as you might have already found out, these converters take hours to convert ...more
If you have iTunes and want to dress up your song or album listings with album artwork, this video outlines how to get art for free. Users simply need to select which iTunes they want art for and then do a search in Google for free images. These images then need to be saved an ...more
MySpace is an excellent resource for up and coming musicians. If you just can't do without that hot new jam, then it's time to rip your favorite song using Audacity media player. This video tutorial demonstrates the process of ripping MySpace songs in a few easy to follow step ...more
If you want to improve violin technique then this tutorial is for you. This violin lesson teaches you to play broken third in 1st and 3rd position. This exercise, based on the Yost system, is designed to increase your familiarity and comfort in all positions, develop confidenc ...more
If you want to improve your violin technique then this tutorial is for you. This violin lesson teaches you to play thirds in 1st and 3rd position. This exercise, based on the Yost system, is designed to increase your familiarity and comfort in all positions, develop confidence ...more
If you want to improve your violin technique then this tutorial is for you. This violin lesson teaches you to play thirds in 2nd and 4th position. This exercise, based on the Yost system, is designed to increase your familiarity and comfort in all positions, develop confidence ...more
If you want to improve your violin technique then this tutorial is for you. This violin lesson teaches you to play an advanced thirds exercise. This exercise, based on the Yost system, is designed to increase your familiarity and comfort in all positions, develop confidence an ...more
If you want to improve your violin bowing technique then this tutorial is for you. This violin lesson teaches you a great exercise to improve your spiccato bowing technique. This exercise , based on the Yost system, is designed to increase your familiarity and comfort in all p ...more
If you want to improve your violin technique then this lesson is for you. This violin tutorial teaches you a way to improve ear training with octave exercises. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your octave playing in scales. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all positions, devel ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your octave technique. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all positions, develop confi ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your tenths technique. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all positions, develop confi ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a exercise in broken octaves in first and third position. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in all positions, develo ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your octave technique in first and third position. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to improve your octave technique in thirds in first and third position. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and c ...more
Do you want to improve your violin playing technique? This violin lesson teaches you a great exercise to play your octaves in broken thirds, seconds, and fourths. This exercise is based on the Yost system. This exercise is designed to increase your familiarity and comfort in a ...more
By Louis Tharp RealJock.com is pleased to present this first in a series of articles on improving your swimming form and performance from Louis Tharp, out gay man, swim coach for the Army Triathlon Team at the U.S. Military Academy at West Point, and author of the new book Ov ...more
You may remember my post from a couple weeks ago here on NextReality about the magical scaling ratios for typography from Dong Yoon Park, a Principal UX Designer at Microsoft, as well as developer of the Typography Insight app for Hololens. Well, his ideas have been incorporat ...more
With the software installation out of the way, it's time to build the framework within which to work when building an augmented reality app for Android devices. The journey to learn how to develop software can be a long and tough road. Fortunately, software developers, in way ...more
Apple's Reminders app has never been particularly sexy or appealing, but that changes in iOS 13. Although the productivity tool has always been useful for quick to-dos, it now has an overhauled user interface with several new features, including grouping lists together for imp ...more
There are many things Apple doesn't tell you about its products, and that's definitely the case when it comes to its Messages app. Hidden features lurk in your SMS and iMessage conversations just waiting to be found, and we've unearthed some of the most secret ones. Instead o ...more
Apple's Reminders app on your iPhone or iPad now comes equipped with a new way to organize your tasks: sections. With sections, you can better sort through reminders in your lists by placing tasks into likeminded buckets or even in kanban-style columns for more efficient workf ...more