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.
This video tutorial from Magix presents how to burn (S)VCDs and DVDs using Magix Movie Edit Pro 15 application.First you need to group videos you want to burn.If you want to play movies using remote control you have to place chapter markers. You can set markers manually or choose automatic? marker setting which places markers before each new scene.Once all chapter markers are placed, click Burn button.Here you can choose Start Menu Templates. To change movie titles and chapter headings double...
In this video we are shown an easy way to draw a fox using Photoshop. First, start with a rough sketch on a separate layer. Rough in the head, ears, snout, and eyes. Make a new layer and outline your previous drawing. In this layer put in more detail such as the jagged outline of the fur and the details of the face. To colorize your fox, put in a new layer under the outline layer. The fox should be colored a dull orange, with dark brown shadows for the ears and white under the muzzle and on t...
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...
To remove the vocals from a WAV or MP3 for free the best way is to use a program called Audacity. First, open the program. Go to file, and open your song. The program will import your song. When it's open you'll see your two stereo tracks.
First of all you have to watch the screen for two bars. One bar is situated in the right side of the screen and the other bar is on the bottom of your screen. First you have to start by following the ‘side bar’ which has the four strings separated by different sections. It also shows red color buttons which are depicting the movement that you need to do by pressing the strings with your fingers. At the start you have to press the second section of the second, third and the fourth strings. The...
This video demonstrates how to prepare Masala Paneer (Indian Cheese). For this recipe, you will need the following ingredients: whole milk and vinegar.
How to make deep fried pickles
For the fairy sized princess tiara you will need 32 gauge silver wire, silver ball beads, seed beads (your choice of color) and 4 mm crystal beads. Start with about 6" of the wire. String a seed bead to the center of the wire- and twist one or two times to secure it in place. Then bring both ends of the wire together- and clip so that they are even. Next string a 4 mm crystal bead over both pieces of wire and press snugly next to the first seed bead already strung. Then add a silver ball bead...
This video shows us how to make lilies for a dollhouse just in time for Easter. First you take a toothpaste cap and some copper metallic paint and paint it. This is your flower pot! Make the flower heads and set aside. Take some clay and stick it into the flower pot. Then take some wire, the length of what you want for stems, and stick one end into the flower bloom and the other into the cap. To make these flowers, you take some clay and roll it into a ball. Lengthen your ball into a cone lik...
This video in the Software category will show you how to use multitrack live recording in Logic Pro 9 . This video is from Lynda. Say you are going to record a 4 piece band; drummer, base, guitarist and a singer. Use separate mikes for all four. First you make 8 different mono audio tracks. Go to track menu and click new. Type in 8 for number, select audio, format will be mono. Now you click the ascending box, order the inputs from one to eight and click create. Now you have 8 audio racks. Cl...
The video demonstrates the process of planting corn in a small soil-patch in your garden. The lady presenting you the video uses a 75g packet of Corn Honey & Cream Bicolor seeds from Heritage Gardens. Be aware that the corn cross pollinates very easily and hence you have to separate the different types of corn by planting time or by distance. The video says that 150 feet distance between different corn types is recommended but in smaller gardens, spacing can be achieved by different planting ...
To start with you have to write the author's name, with the last name entered first followed by first name and then the period. Title of the article should be in quotation marks. Do not use italic format. Title of the actual journal must be written. After this there is a series of numbers the volume number, issue, year, pages number separated by a colon. Don’t write 'p' for pages as the number itself is a standard for it. Write the period and also the dates.
This video teaches how to make a Chinese style chicken and sweet corn soup, with the optional addition of noodles. In it Caroline suggests you take some leftover chicken, ginger, onion for flavor and garlic. Cut the ginger into little chunks and skin the garlic. Put the leftover chicken bones into a pan, or simply put some chicken legs into the pan. Then add about 3 liters of water, which should just cover the chicken. Add the ginger chunks, then the garlic, then cut the onion in half and sim...
Take shower at night before, don’t brush your hair and sleep with wet and messy. If you have curly hair brush it and put rollers or a hair dryer if it is needed. Heat the hair curler. When you wake up it should be one inch and half thick of a curler. It is going to be a mess. For this separate your hair in half straight in the middle and hold one side with a hair clip, while the other side you slice your hair into sections. Start from the bottom and hold the other using a hair clip. Use hair ...
To make salmon patties, heat up regular oil in a skillet, just enough to coat the bottom. Turn the stove flame to medium high. Open two cans of salmon. Remove the juice, bones and skin. Flake up the salmon. Add one cup of instant mashed potatoes to the bowl. Dice one medium onion and add it to the mixture. Chop parsley and add it to the salmon. Next, add the juice of a lemon to the bowl. Then, add four eggs to the patty mixture. Beat two more eggs in a separate bowl for an egg wash. Then, sea...
This video tells us the procedure of making strawberries and cream croissants. Take two refrigerated crescent rolls and separate them into triangles. Put the triangles at the edge of your pan with the longer end inside the pan and the tip outside the pan. Overlap the adjacent triangles and flatten them with your hand. Lift the longer ends a little bit above the pan. Spread 8 oz of strawberry cream cheese above the triangles. Spread 16 oz of frozen strawberries over the cheese. Fold the triang...
This video from Drawing Now outlines how to draw Mike from Monsters, Inc. There is no audio in the video. To being, draw a tear-shaped oval with a rounded top. Draw a half moon that faces down, with the top of the rounded end of the “moon” touching the top of the tear shape. This will be the eyelid. Below the eyelid, draw a big circle for the iris, with a smaller circle inside it for the pupil. To start the arms and legs, add them in stick form. The arm has two segments and the hand and the l...
Cocorais shows you how to style your short hair into a crimped wavy look with a step by step example doing her own hair. You'll need a heat-protecting spray, a curl-boosting spray, a rat-tail comb, some sectioning clips, hair wax, and a flat iron. Apply heat-protecting spray and then (a lot of) curl-boosting spray. Pin up your hair so you can work with really thin sections of hair. Take one section, and pulling it straight, take your flat iron and move the flat iron back and forth. Iron layer...
This is a step by step tutorial how to Partition & resize your hard drive with EASEUS. To resize hard drive Open EASEUS Partition Manager. Click on the drive you want to resize. Then click Resize/Move. Go to the end and left-click with your mouse dragging in the direction you want to go. In the display you can see the size that's being created. When you have the size drives you want, just stop and click OK. If you shrunk one drive you can now create a new drive using the unallocated space. Th...
In this video you can learn how to make an Italian pot roast. Put 1 cup of water into crock pot or large cook pot and add Italian seasoning. Slice the baby carrots in thirds or the regular carrots into thin (1/8 inch) slices. Slice the squash and zucchini into thick (1/4 inch) slices. Cut the onion into eight pieces and separate the layers. Peel the potatoes and cut into bite size chunks. Toss it all together and put half of everything into the crock pot or kettle. Add the wine and vinegar. P...
To change a dirt bike tire follow these instructions. First use the crescent wrench set to loosen, and remove the axle bolt from the wheel you are working on. Then, slide the wheel out of the stays and lay it flat on the ground in an open area. Use the screwdriver to let the air out of the tire by depressing the valve stem with the blade. Now place the palm of your hand on the tire next to the very edge of the rim, and forcefully push downward. If all of the air is out of the tire and you do ...
This video by Wowzzydot shows us an easy way to silk screen/stencil a garment. Using either a t-shirt or baby onesie, you can decorate it in the style of our choice. She clearly tells you the supplies you will need, embroidery hoop,sheer fabric, such as a curtain panel, paint and stencil brushes, scissors, Mod Podge or any water solvable glue. Also textile paint or ink and of course, the garment to be decorated. The first step is to cut the sheer fabric about an inch larger around than the ho...
This video teaches you how to use substitution to find the point on a graph (the x and y coordinates) where two separate equations would cross. Substitution is a trick of algebra that allows you to find this point without making a graph. The first step is to isolate one of the variables (x or y) in one of the equations. That way, you know that that variable is equal to everything on the other side of the equals sign from it. You can then take that whole side, and substitute it into the other ...
How To Make Christmas Artichokes94 year old Clara teaches you how to make bread crumb stuffed artichokes for the holidays. Cut off thorns on the tips of each leaf with scissors. Start at the bottom and work your way up. Cut off the stem on the bottom at the base to prepare the filling, mix bread crumbs, salt, pepper, and garlic powder to taste. Open up the artichoke at the top, and separate each leaf enough for filling to fit in. Use a spoon or your fingers to fill each hole with the bread cr...
This video teaches you how to make an arrowhead friendship bracelet. The first step is to pick five colors of string. Then cut 2 pieces of string of each color. All 10 strings should be of the same length. Lay out strings adjacent to each other on the table in this color 1, color 2, color 3, color 4, color 5 and then repeat in the same order. Then knot the strings evenly. Now tape the knot onto a hard surface. Separate the strings into two sections, each section should contain 1 of each color...
Ingredients: 2 lbs well cleaned intestine (from pig or cow)
Procedure: First we need to add one cup about 1 Kg of chopped, frozen cooked chicken and mixed frozen vegetables consisting of cauliflower, carrot and some other vegetables of our choice into a pan, then add two tins of cream of chicken soup, then stir the mixture, then add 2 1/2 teaspoons of chopped onions, 1 teaspoon of garlic paste, add some mixed dry herbs (1/2 teaspoon) and stir the mixture, then add 1/2 cup of thickened cream and stir the mixture, then transfer the mixture to a baking t...
1. To tie a bow tie, one end should be longer than the another one. 2. Take the longer end above the smaller one.
Begin by painting your full nails orange. Any orange will work for this design; just keep in mind that more than one coat of nail polish may be needed to get a bold and opaque shade. I did two coats of orange to get the coverage shown in the photograph.
Combine the vinegar, salt, and ground black pepper in a large bowl then marinate the goat meat for at least an hour (This should eliminate the gamey smell and taste of the meat) then separate the meat from the marinade.
This how-to video is about how to bake and frost a carrot cake. Ingredients required:
In this video the author gives an HTML Website Design tutorial showing how to make a side menu bar. He goes on to show how to write the HTML page, explaining about the different HTML tags like <html>, <head>, <title>, <table> etc., He shows how to set page color and add styling to the page. He shows how to align the page elements and does the font settings. He goes on and makes a HTML table. Next he shows how to make a menu bar using the table element and shows how to do the various settings ...
Do you win the prize for messiest room in America? That's a difficult contest, but how about messiest room in your house? It’s time to clean your room, so do a good job in the shortest amount of time and get your parents off your back.
This step by step instructional video walks you through how to make delicious chocolate cupcakes. Using a few ingredients such as chocolate, cocoa, water, flour, vanilla essence, granulated sugar, confectioners sugar, baking powder, eggs, salt, and butter. First start by combining the flour, baking powder, and salt into a bowl. In a separate bowl mix the water and cocoa powder. Next you mix the butter and granulated sugar and use a mixer to blend it together. Once this is mixed you slowly add...
For all origami enthusiasts, here is something new. This video details how to make your own origami enigma box. As with all origami pieces it can be made using just a single piece of paper. The paper is first folded, taking from two separate parallel ends, in such a way that both sides meet in the middle of the paper. This will make four rectangles when unfolded which are to be further folded into half to make eight. Now, the paper is to be taken from the other two ends and folded to meet in ...
To make this jelly you will need a food puree-r. Start with a large bowl of blueberries. Take a small amount of the blueberries and put them into a separate bowl and mash them up. You don't want to puree all the blueberries. Dump the rest of the blueberries into the puree and start pureeing them into the bowl with the smashed blueberries in it. Turn the handle a few turns and then add the grapes into the puree-r with the blueberries. Puree the rest of the of the grapes and blueberries until t...
Biscotti are easy to make and you can have them with different things. They soften up when you dip them in something.
This is a good dish to make it doesn't take that much time, and is something that you will like if you like shrimp.
Here, Rich Pin demonstrates how to troubleshoot the door check link by working on the Saturn S series. Typical example is the popping sound you hear when you open and close the door.