Locating Hidden Search Results

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Install a hard drive in a 2009 Mac Pro

First of all the tutor suggests that this tutorial is easy and you can complete it only fifteen minutes. However you need to use proper anti-static precautions when you are performing this upgrade. You have to ensure to discharge static electricity before beginning. You must also work on a static free surface. You need a "#00 Philips screwdriver" which you can find in the “Newer Technology” 11-piece tool kit. It is available from macsales.Gather all your materials and then shut down your comp...

How To: Build APRS on the cheap

Long-time packeteer Bob Bruninga, WB4APR, developed the Automatic Packet Reporting System (APRS), which allows packet radio to track real-time events. It deviates markedly from the usual message- and text-transfer activity. Instead, APRS concentrates on the graphic display of station and object locations and movements.

How To: Treat bed bugs & get rid of them

In this video tutorial, viewers learn how to find bed bugs and how to get rid of them. When users are aware that their home is infested with bed bugs, it is critical for users to locate all of the bugs. There are many areas where bed bugs inhabit. Bed bugs can be found on the bed, headboard, electrical sockets and telephone jacks. Bed bugs may also be found in cracks. The best treatment to remove bed bugs is to use Delta Dust, bed bug spray or any other bed bug products. This video will benef...

How To: Change the cabin airfilter on a 2004 Honda Civic

You may not realize it, but is more than one air filter attached to your car. Not only do you have the filter near your engine, but there is also one located within the vehicle itself. This is used to collect any dust or other particles that are in the vehicle. Many people don't realize it, but these need to be replaced every year or two. So in this tutorial, you'll find out how to locate and replace the cabin airfilter on a 2004 Honda Civic. good luck and enjoy!

How To: Export MP3 files out of Audacity

In this video tutorial, viewers learn how to export MP3 with Audacity. Users will need to download the Lame_enc.dll encoder. The download link is located in the video description. Once downloaded, open Audacity and find the song that you want. Once you have found your song, simply drag the song into the program. Now click on File and select Export As MP3. It will then ask you to Lame_enc.dll file. Click on Yes and locate the file. Now wait for your file to finish encoding. This video will ben...

How To: Connect to Xbox Live with a laptop

In this video tutorial, viewers learn how to connect to XBox Live with a laptop. In your task bar, locate your connection and double-click it. Select Network and Sharing Center. In the tasks, select Manage network connections and select your wireless connection. Click on Adapter Properties, located in the tab above and select the Sharing tab. Check both the boxes and Press OK. Now plug the Ethernet cable between the Xbox 360 and laptop. Turn on the console and test the connection. This video ...

How To: Hide hard drive icons in Windows with NoDrives Manager

Video demonstrates tutorial of how to hide the logical drive icons in Windows. In the demonstration there is two partitions C and D and also there is a DVD drive, DVD Rom and DVD Writer. Here drives C, D and F from My computer is going to be hidden with help of utility called “No Drives Manager”. If you don’t want your young ones to access some of your important data you can hide it. It will just be hidden. This means if go to the address bar and types the name of the drive you can go to that...

How To: Easily use a clock as a compass

This how to video explains how to use a clock as a compass if needed. To start, simply place a clock on a flat surface and place a match in the very center of the clock so that the shadow of the match is even with the hour dial. North will be located at the midpoint between the 12 on the clock and wherever the shadow of the match is cast. The video then shows an example of the application by using a piece of paper and a pin. The narrator shows how the user can go about finding where north is ...

How To: Block websites on Windows through Notepad

This video tutorial shows you how to block any website on a Windows xp operating system by simply using notepad. First the URL to the site that needs to be blocked should be located by visiting the website form your browser and copying the URL from the address bar. Next close the browser and locate the "hosts" file and open it with notepad as indicated. Make the necessary changes to the "hosts" file and save it. Now the selected website is blocked on your computer.

How To: Play NES on an iPhone or iTouch

User FL1PPY explains how to play an NES on an iPhone. First, log in to your iPod with Win SCP. Locate the Applications folder. Drag the NES.app folder into the 'Applications' folder. Open the NES folder and find the NES file. Right click, choose 'properties', and set permissions to 777. Restart your iPhone. The application should appear on phone. Next, to install games, log back into to Win SCP and locate the mobile folder. Open media folder and create 2 new folders called "ROMs" and "NES". R...

How To: Hide short yarn tails

After you finally finish crocheting your piece, what are you supposed to do with that tail? This how-to video demonstrates a trick for hiding the end within the stitches of your project. Watch this video crocheting tutorial and learn how to hide short yarn tails.

How To: Hide or unhide rows and columns in Excel 2007

In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This instructional video shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.

How To: Add, hide, and show columns in Project 2007

Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. Take a look at this instructional video and learn how to create a column, hide a column, and show a column that you previously hid.

How To: Permanently Remove the 'No SIM Card Inserted' Notification on Your Samsung Galaxy — No Root Needed

Your Galaxy's lock screen already lets you know there's no SIM card installed if it's missing on your device, so there's really no need to have a persistent icon for it on the status bar. If you want to hide the pesky symbol and accompanying notification for good, there's a nifty app you need to check out right now.

How To: Hide That Pesky NFC Icon from Your HTC One's Status Bar (Root Required)

If you turned on your HTC One for the first time and wondered what that weird icon that looks like an N is, it indicates that NFC is on. It seems strange to me that HTC wanted to waste Status bar space on an NFC indicator, but sometimes we just have to deal with it. However, if you're a softModder, you don't have to just deal with it. The icon can't be removed permanently, but there is a very easy way to hide it forever.

How To: Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...

How To: Insert a picture or clip art in MS Word 2007

For inserting a picture, from the INSERT Tab click picture. Then the insert dialog box gets opened. From there you can locate the desired picture. Locate the picture to be inserted and double click it. We can also replace the picture selected. For replacing any one of the following can be done: Under PICTURE tools, on the FORMAT tab, in the ADJUST group, click Change picture OR right click the picture to be replaced and click CHANGE PICTURE. Locate a new picture, and double click it.

How To: Perform Dsi hidden mario secrets and tricks

Locked away in the Nintendo Dsi are a bunch of hidden tricks and secrets. If you don't know what they are, check out this video and see what they are. Watch and learn how Mario will jump on his own to custom music, how he'll change color and more. Everyone loves a secret, and every Dsi owner should check these out to see what the clever people at Nintendo have hidden away here for you! You'll love the hidden Mario theme song trick!

How To: Reveal hidden MySpace profile content with FireFox

In this video tutorial, viewers learn how to reveal hidden MySpace profile content using Mozilla Firefox. Begin by clicking on View, go to Page Style and select No Style. This will take out all the styles that are applied on the page, and reveal all of it's data. Now users will be able to view the specific content on the profile page such as friends and page comments. This video will benefit those viewers who use both MySpace and Firefox Mozilla, and would like to learn how to access hidden M...

How To: View a hidden friends list on MySpace

MySpace gives users the ability to hide their friends list. This video walks you step by step through being able to view this list. First, go to the desired profile. You'll see the hidden friends list. Now, click on "Edit with notepad" and code will pop up on your notepad. Because the list is on the page, editing the source code will make the list appear on the page. Next, type the command >table border=0 cellspacing=0 align="center">. Now you'll be instructed on how to delete the source code...

How To: Install a hidden hitch on a 2005 Toyota Sienna

If you're looking to go out on the road and bring along your boat or trailer, having a hitch is needed. But what if your vehicle doesn't have one or you wish you could have it, but not show? Well this tutorial may be what you need. In this two part video tutorial, you'll be finding out how to install a hidden hitch on a 2005 Toyota Sienna. It may seem easy to do, but it can take a good number of hours to complete. So good luck and enjoy!

How To: Make a hidden compartment using CDs

Looking for somewhere to hide your things so that no thieves will take them? Why not try hide them inside that old Hanson or Backstreet Boys CD? If you have out of date CDs that you are no longer listening to, check out this tutorial. In this video you will learn how to use ordinary CDs and turn them into mini-safes for your valuables. These are easy to make and are great for security. So, whether you are hiding things from your parents, siblings, roommates or strangers, have a look at this s...

How To: Hide a file inside an image with Winrar and 7-Zip

In this how-to video, you will learn how to hide a file inside an image file. You will need a program like WinZIP or WinRAR to do this. First, create a new zip folder. Drag the file you want to hide into the zip folder. Open the command prompt. From here, type in the location of your file. Now, type in COPY /B followed by the name of the image, a plus, and the name of the zip folder. Press enter to do this. Now, you can delete the zip folder. The image will now actually be a zip folder. This ...