Repair Cell Search Results

How To: Restore a crashed system

In this video tutorial, viewers learn how to restore a crashed system in Windows 7. This task is very easy, fast and simple to do. In Windows 7, users are able to create a repair disc. To do so, open the Start menu and type "system repair" in the search bar and select "Create a System Repair Disc". Then just follow the instructions to create the repair disc. It will take less than 5 minutes. This video will benefit those viewers who use a Windows 7 computer, and would like to learn how to res...

How To: Name cell ranges with relative references in MS Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

How To: Repair and assemble a V-Cube 6 puzzle

The V-Cube 6 puzzle is a uniquely designed and constructed skill game. V-Cube 6 is a multi-colored, multiple-layered cube, rotating smoothly on based axes. The player is required to discover a strategy to achieve uniform color sides on her or his V-Cube, but in this process, the Rubik's Cube-like puzzle may break, especially if you're in the process of speedsolving.

How To: Lock & unlock cells in Excel

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...

How To: Create a system repair disc in Windows 7

This video teaches you how to create a system repair disc in Windows 7. Go to Start-All Programs-Maintenance-Create a System Repair Disc. This will help you boot Windows to repair or recover your system after a serious error. Once you click that, Windows 7 will prompt a new window telling you to put a blank disc in your disc drive. Make sure that you do have a blank DVD to insert, for the Windows 7 to create that System Repair Disc. Wait for the process to finish and you have yourself a syste...

How To: Use Excel spreadsheet setup & cell references

In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...

How To: Repair your Xbox 360 'red ring of death' at home

First of all you have to check the three red lights as shown because it indicates that the Xbox is broken and needs repair immediately. However if you open the Xbox the warranty is invalid and it takes six weeks to get it repaired. So go to eBay and buy the repair kit with printed manual for ten dollars. Remove the top and the bottom covers. It shall make a loud slap and it should be expected. Now use a key to unscrew the top cover and then remove it. Now remove the white color fan part. Now ...

How To: Repair a windshield wiper arm on a Saturn S-Series car

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...

How To: Make a dye-sensitized solar cell with titanium dioxide and anthocyanin

Discover the power of raspberries! Literally. In this NurdRage science video, learn how some crushed raspberries and some titanium dioxide (TiO2) can create a powered dye-sensitized solar cell. Inside a raspberry is something called anthocyanin, which is a flavonoid pigment. Commercially purchased solar cells are way more powerful than this DIY solar cell, but with a little improvement, who knows. Nurd Rage also lets you know how this works.

How To: Repair a Playstation 3 Blu-ray drive laser & mechanism

Since the Playstation 3 and Xbox 360 rivalry began, Sony fans have always turned to one simple feature the PS3 dominates over the 360: Blu-ray. Yes, Xbox took a gamble with HD DVDs and since their demise, the PS3 has dominated in the video department. But of course like any bit of technology, things can break. So if you have a messed up PS3 blu-ray player, this tutorial series may be the answer you are looking for. Find out how to repair or replace a PS3 blu-ray drive laser and mechanism. Rem...

How To: Repair the PS3 Blu-ray drive laser

The Sony Playstation 3 is a powerful video game console that can rival any console out there. It has a great collection of video games, can access the internet, and one of the best features is that it plays blu-ray dvds. But of course, like any electronic device, nothing is perfect, and neither is the PS3. In this video tutorial series, you'll find out how to repair the PS3 blu-ray drive laser. Warning: opening up your PS3 may void your warranty and cause more damge to your system. So be care...

How To: Replace the LCD screen on the LG Xenon GR500

Repairs Universe demonstrates how to replace the LCD screen on the LG Xenon GR500 cell phone. First, remove the battery and the SIM card from the phone. Then, use a small phillips head screwdriver remove six screws from the back of the phone. Next, use a safe pry tool to release the clips by running it along side of the phone. Remove the back layer. Remove the two screws on the inside of the phone. Also remove the volume key, the hold button and the camera button. Slide the phone to the side ...

How To: Repair a crashed 3D helicopter

In this video, we learned how to repair a crashed 3D helicopter. If you have a crashed helicopter that isn't flying or is flying off center, repair it. You will have to have some knowledge of how to repair helicopters, and know which part is broken. Repair the parts that are broken and when you are done you will need to replace all the parts that you previously removed. After you are done with this, you will be able to turn the helicopter back on and test its flying abilities. If the helicopt...

How To: Use System Repair Engineer to combat viruses & malware

Your Windows computer may be experiencing some issues, and those issues may be a direct result of computer viruses and malicious software from the internet. One of the simplest ways to find these issues and repair them is by using a freeware program called System Repair Engineer (SREng). But that's not all it can do… check out the video to see a basic overview for using SREng.

How To: Name a Microsoft Excel cell after its content

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).

How To: Sweat solder copper water tubing for plumbing repair

This is an instructional video to help demonstrate how to sweat solder copper water tubing in plumbing repair. If you can't be bothered to hire a professional plumber for all plumbing repairs, this video guide shows you how to do the work yourself. You will need a gas or propane torch, copper or brass fittings, copper tubing, gloves, solder paste, solder, pipe cleaner, and a pipe cutter. Learn how to sweat solder copper water tubing for plumbing repair.

How To: Make repairs on miniatures

Do you actually play with your miniatures? Well, if you do they probably take a little wear and tear. However most miniatures can be easily repaired. If your model has a pink/blue foam base you can usually repair it with some spray glue and a hidden toothpick brace. With these simple tips you can repair miniature dioramas, architectural models, doll houses Warhammer pieces and game terrain.

How To: Sand and Repair Drywall

In order to sand and repair drywall, you will need the following: 100 grit sanding sponge. After you have applied mud to the walls evenly, you will need to sand the walls until they are smooth. Hopefully, you minimized or mitigated most of the need for sanding in the application of the mud, by using feathering and thin layering. When the mud is completely dry, you will need to choose a good sander. It is recommended that you use a 100 grit sanding sponge. Place the sponge against the wall, an...

How To: Repair damaged molding

This video shows the viewer how to repair a section of damaged molding surrounding a door or window. The method shown uses WD40 and polyester resin. Firstly an undamaged section of the molding is sprayed with WD40 and then covered in resin. Once the resin has hardened the WD40 allows it to be removed and used as a mould. The mould is then sprayed with more WD40 and is filled with new resin. This is allowed to harden and then removed. The resin replica of the molding is then sanded and cut to ...

How To: Remove the front bumper on a Saturn S-Series car

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...

How To: Replace the PCV valve and grommet in a Saturn S-Series

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...