How To: Create an in-cell dropdown menu in Excel 2003
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.
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.
In this video from cdrhead we learn how to save money by staining your own concrete floors. First vacuum the floor and under the sheet rock removing as much dirt and dust as you can. Place plastic on all walls and unfinished wood trim. Now use a 4 inch scraper to remove any remaining materials. Now scrub with a broom with water or buffer. Spray a mild acid detergent on the floor as well now and scrub with a buffer. Now vacuum the floor with a ShopVac. Now spray the acid stain using a handheld...
This video is about how to paint short nails with a white flower art design. The first step that you will have to do is to apply any background color on you nail. After applying the background nail polish, get a piece of paper and place the white nail polish on. After wards, use the dotting pen to start dotting the nail. Make four dots in the middle of the nail forming a flower. Then, just simply add another 3 more dots to both ends of the nail. After adding all the dots on the nail, the next...
S2Pandapple shows viewers how they can get Kim Kardashian Inspired curls! First, you should wash and let your hair air dry. Make sure you spray heat protector in your hair before curling! Next, make sure you brush your hair thoroughly getting rid of tangles. Separate your crown and the bottom of your hair. Twist and pin the top up and put the bottom in a ponytail. Now, unclip the top of your hair and begin to put your hot rollers in. Spray each hair section with volumizing spray! You will wan...
First you must take inventory of all items in order to be able to create your bag. Make sure all labels are in the correct order. Lining should be ready before attempting to begin construction. The stay should be 10in long and 4in wide. Pocket the stays and glue the stays to the outside fabric. Use the notches to line everything up. Take the magnetic snap and attach it to the front and back. Take a knife and cut holes for the magnetic snap. The magnetic snap comes with a washer. Use cardboard...
The materials you will need to add snow and other details to the base of your miniature game figure are white tacky or craft glue, super glue, a few small rocks or pebbles, coarse turf, a small paint brush, and baking soda. Begin by using the super glue to apply a few rocks to your base. You don't want to apply too many as the main focus will be on the snow. Add white glue to the base being careful not to get any on the figure itself. Use your paint brush to spread the white glue around until...
In this Arts & Crafts video tutorial you will learn how to make a stained glass mirror. This video is from Artists Resource. You will need a Marabu GlasArt kit, some spirit, a china graph pencil, scissors, a ruler, masking tape, a container to mix your paint, an object to draw an oval shape, Marabu outliner paint, a mirror and peel off dolphin stickers. Take a few dolphin peel offs and stick them on the face of the mirror; on the edges, to form a design. Place the oval shape object in the cen...
This is for an ankle that has been rolled to the outside of the body. Start by cutting a piece of rock tape that is about the length of the distance from the mid arch to right below the kneecap. To tape the ankle sit on a table put your heel on the edge of the table with your toes pointed down. With an ankle sprain this will be very painful so go really slow. Pull an inch of backing off the tape and anchor it about mid arch and then pull the backing off of the rest of the tape. Then with your...
To remove the scratch in acrylic you need to first use Silicon Carbide water proof paper of 600CW grade. Turn over the paper and rub the scratched area of acrylic in a circular motion. You will see the scratch disappears after few minutes. Thereafter use the Silicon Carbide water proof paper of 1200CW grade which is more fine. Again rub over the scratched area in circular motion. Then wipe off the area and you can see after some time of rubbing the scratch is completely disappeared. But it le...
In this beauty tutorial, learn how to get the dramatic eye synonymous with Ed Hardy-Inspired makeup. The first thing you will need to do is apply a foundation over your entire eye area. Because so much makeup is being used, you really want to make sure there is a foundation in place to keep all of the color in place. Then, with a no. 217 brush, sweep a dark navy blue color over your entire lid as well as the crease. Line your lower lash line with a dark blue cream eye shadow and also fill in ...
In a recent poll taken by an online recruiting company revealed that 37 percent of all hiring managers do not hire someone based just on the way they dress, more than half said they'd hold it against a candidate if they hadn't worn a jacket and seventy percent said that they wouldn't hire anyone wearing jeans, a leather jacket or a polo shirt to the interview. The rules for office dress code have changed, more and more companies offer their employees a business-casual dress code which makes i...
This video describes how to prepare for and execute painting your home. To begin, you should power wash your house to remove any dirt, dust, cobwebs, etc. These would prevent the paint from setting properly, unless it was new wood. If it is new wood, you should put on a beige coat first. However you begin, you should let either method dry before moving to the next step. After it dries, you should apply a weatherproof and paint-over caulk to the cracks to keep out moisture and insects. After t...
The video shows us how to create bevels in Xara web designer. Firstly using the rectangle tool hold down the Ctrl key to create a square. The problem with the Xara web designer is that it hasn't got a convert to edit the shape features which actually means that you cant select individual nodes with the shape editor tool which may create some other line. However you can select individual nodes by going to arrange/combine shapes/add shapes with selecting the rectangle. And by doing changes the ...
Learn how to create a cell phone icon in Photoshop with this video tutorial. Draw a rectangle of radius 30 pixels by holding shift key. Right click on the toolbar and select Stroke button. It will open Layer Style dialog box. Set stroke color and set size to 2 pixels. Select Stop Color set little light red color and click on OK. Now, check on Inner Color option change size to 4 and Capacity value to about 60%. Now select Ellipse tool which will draw a ellipse and cover half of rectangle. Sele...
This is a demo of showing how to dye your hair colorful. This is what you will need! I use Turquoise hair conditioning dye. Next you need is a hair dying brush with a container which we can use to paste the hair dye. Then, you also need a hair brush. Then, you need a dark or old towel which can be wrapped around your shoulder and breasts so that dye will not fall on your skin and stain it. Then, you need a hair clip to keep the towel in place. Simply wet your hair. To apply the dye, part your...
This tutorial is about how to create Avatar inspired makeup. Go in with a white full coverage makeup and go over with a light layer all over the face. The white is going to give the blue something to stand out in front of. Don't forget to do your neck and ears. For the blue, you can use a powder or cream or liquid. Use a baby blue and with a big fluffy brush start applying it all over the face. Go in with an invisible setting powder to set the blue. In order to be Avatar you want your nose to...
Understand basic video tricks. A great way to prop up your camcorder when you don't have a tripod and you want a low angle shot from the ground is to use a rubber doorstop. It stays put and you can move it up and back to set the shot higher or lower.
Cut out the old caulk with a utility knife. Trim along the sink where the old caulk was located. Scrape out stubborn caulk with a putty knife or a paint scraper.
This video is about how to create a twisted geisha makeup look. - Step one is to cover your eyebrows and to cover the entire face in white makeup.
Paint your nails with hearts for Valentine's Day. This easy to follow video shows how to get a great Valentine's Day look with just five simple steps:
Ever heard of the Blink Card Trick? Well, it's an easy way to impress your friends, without having to know much about card tricks. Learn how to perform this card trick, step by step, in this tutorial.
Ever wanted to know how to smell good naturally with natural elements? You can save the earth without offending those around you when you go au natural.
Clueless when it comes to styling those unruly bangs of yours? Face fringes are cute and fashionable but need extra attention to keep them looking fresh. In this video, learn how to style those bangs easily and with style.
Are your sinuses killing you? There are ways to relieve this pain by applying pressue. Learn to apply pressure to points of the body with your thumbs or fingers to relieve sinus pain.
Looking to brighten up your hairdo? Add pizzazz to your hair by giving yourself highlights—at home. In this video, learn how to give yourself the perfect highlights.
Thinking it's time to deep condition your curly hair? Curls can lose their luster and texture if they lack moisture. Here's how to keep curly locks shiny and healthy with the rules of deep conditioning.
Looking to appease your creative side? Paint with oils! You Will Need:
Do you always get razor burn? Razor burn can be painful, irritating and lower self-esteem. Follow these simple steps to get a smooth shave without the irritating bumps and burn.
Neck pain can be the worst. Be aware of daily habits that may be causing your chronic neck pain and replace them with healthy choices. In this tutorial, learn how to soothe chronic neck pain.
Whether you're hanging out at the beach, laying by the pool, or walking around in sandals, having nail fungus is not the most attractive thing to flaunt.
Check out this simple Adobe Illustrator CS4 tutorial to learn how to create a skewed checkerboard pattern. This technique will save you the trouble of having to use the Option and Drag method multiple times. Veerle Pieters expertly takes you through this easy pattern technique. For more Adobe Illustrator tutorials, search for Illustrator on WonderHowTo.
Make greasy, limp locks come to life with everyday ingredients. You Will Need
While drywall is an inexpensive building material, it's not the sturdiest. Luckily, repairing the inevitable holes is a quick and easy process.
Death by stingray is extremely rare, but getting hit with their barb still hurts like hell – which is why you need to learn how to play footsie safely with these sea creatures.
Cold sores are highly contagious. Follow these simple steps to prevent them. You Will Need
Make your eyes look bigger and brighter by lengthening your lashes. You Will Need
If you've got an oil slick on your head by noon most days, try these strategies to keep grease under control.
Everybody into the pool! Or the ocean! But not before you take measures to prevent your hair from getting fried.
With a torque wrench, you can set a bolt to the proper tightness and cut down on wear and tear. You Will Need
Improve your skin’s appearance by choosing the right foundation formula and shade. You Will Need: