Wide Range Search Results

How To: Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Make a notebook with ribbon binding

This video demonstrates how to make a notebook with ribbon binding. Take a stalk of plain white paper and it would be 5 1/2" long and 8" wide. Fold it in half. Trim off the excess with a ruler. Then align the edges of the white paper. Put this in a cardstock which is 8 1/2" wide and 5 1/2" long. Cover rapid around the white paper stalk to make sure that it the spine is bounded. Take the grid ruler and center it and mark the center and also 1" from the center at each side to the left and right...

How To: Combine images to create HDR photos in Photoshop

Yanick's Photo School demonstrates how to use Photoshop to make HDR images in Photoshop CS3. This tutorial first explains that HDR means "High Dynamic Range" which is a process to get details from a photo from both the highlights and shadows of a particular scene. The first thing that is necessary is to take multiple views of the same image with different exposures. To start off, you will take three exposures: one that is two stops down, one that is normal exposure, and one that is two stops ...

How To: Cross process your photos in Photoshop

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 adjustment layer for curves. If you've never used curves before it is recommended that you take a curves tutorial first as for this effect we will need to adjust individual color channels. It is not difficult but if you don't...

How To: Prepare an easy lobster appetizer

Watch this video to learn how to prepare an easy lobster appetizer. Your guests will gobble them up in no time! Ingredients four (1 lb) lobsters six cups mesclun (baby greens) one cup lobster stock one shallot, peeled and finely diced cup vinaigrette one tsp fresh lemon juice Freshly ground white pepper to taste Fine sea salt to taste one bunch fresh chervil for garnish Preparation Cut shelled claw meat into inch wide strips. Cut the legs and shell that covers the tail meat. Cut the tail meat...

How To: Select different items in Finder in Mac OS

In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...

How To: Carve a net needle out of wood

Carving a net needle from wood is probably easier than you think as long as you have your trusty Swiss army knife at hand. It has a wide array of available tools in a small unit. First you will need a piece of balsa wood. It should be 1/8 of an inch thick by 3 inches wide and 8 inches tall. Using the sharp narrow blade of the knife, you will cut 3 reference holes in a triangular pattern. The points of the triangle should be 1 inch apart at the bottom and the triangle should be 2 inches high. ...

How To: Knit one-row button holes

Knitting button holes doesn't need to be a pain. With the tips in this how-to video, it can be quick and easy. If the button you're using is 4 stitches wide, make a 3-stitch buttonhole (as demonstrated). For a 5-stitch-wide button, make a 4-stitch buttonhole, etc.

How To: Get bigger biceps by lifting weights

How do you get bigger biceps, the age-old quest for bigger guns. Well, first things first, more is not better. Hefting around 50-pound dumbbells as opposed to 20-pound dumbbells is not necessarily going to build you bigger biceps because what's probably happening, you're probably not using full range of motion, you're jerking a lot, you're not focusing on that muscle alone. Practice lifting weights to get bigger biceps. Learn how to increase arm strength and size in the biceps with weightlift...

How To: Make All Your iPhone Apps Work with iOS 13's Dark Mode

The biggest feature in the iOS 13 update is a new system-wide Dark Mode. It's a simple switch that you enable to turn system menus and Apple apps dark, but it can also darken third-party apps if their developers elect to support it. Trouble is, most haven't yet, so half of your apps likely still have a blinding white background.