Automatically Moves Search Results

How To: Merge spreadsheets in Excel

If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.

How To: Set Google Online Timer

This video will describe you how to set Google online timer. Now you don't have to bother about the timer or stopwatch. You can bring a timer in your Google.com home page. You have to type a command "Google timer 50 seconds" and a timer will start automatically. You can stop and reset the timer whenever you want. Watch the video and employ it yourself.

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: Use the Nikon SB-900

Now that you've got your Nikon SB-900 professional-grade speedlight, make sure that you get the most out of it with this free photographer's guide, which will walk you through the flash unit's basic features and functionalities.

How To: Connect on the internet using a PS3

Learn how to connect to the internet using your PS3 using an Ethernet cable. What you will need: 1. An internet modem or hub. 2. The details required to connect to the internet (password etc.). 3. A PS3 and an actual internet connection e. g. BT or AOL. Once you have those just follow these steps: 1. Take your Ethernet cable and plug it into the back of the PS3 into the socket labeled Ethernet. 2. Plug the other end into your internet modem. 3. Turn on your ps3 and go to "network settings" un...

How To: Create a data disc in Windows Vista

This video shows us how to burn files to a disc using Windows Vista. Insert the blank disc in your computer's recordable disk drive. Autoplay will automatically appear. Choose "Burn Files to disc using Windows". Click next when "Burn a disc" dialog box appears. Empty folder window appears. Choose files that you want to copy and drag them to the window. For example, if you want to copy a photo, click Start menu and open the Pictures folder. Select photos and drag them to the window. Photos are...

How To: The Fastest Way to Share Your Location via Messages on Your iPhone

Apple makes it simple to share your location with your family and friends using tools built into the "info" page for each conversation thread in Messages. With those tools, you can send your current location or share trackable real-time coordinates. But iOS always has a few hidden tricks to make things easier than they seem, and that's precisely the case if all you need to do is share your current location.

How To: Stop Group FaceTime Tiles from Auto-Resizing & Moving When People Speak

When using Group FaceTime with more than a handful of people, all of those participants in one chat can be difficult to follow. That's why Apple automatically enlarges the tiles for people who are currently speaking, bringing them into the forefront. However, all of that zooming in and out can get pretty distracting, and now there's a way to disable it whenever you need to.

How To: Apple's Mail App in iOS 13 Has New, Faster Ways to Select Multiple Emails

Normally, when you want to select multiple emails in the Mail app, you'd hit "Edit," tap all the bubbles next to the emails, then mark them, move them, or trash them. But in iOS 13, there's a much faster way to do it on your iPhone.

How To: Use the Word Lens iPhone app for real-time translations

Augmented reality takes another step forward with the new Word Lens iPhone application. This nifty little application is compatible with the iPhone 3GS, iPhone 4, and iPod Touch. This is how it works - just take a snapshot of any text, and it'll automatically translate it from English to Spanish and vice versa. Take it with you when you travel! This video shows you the best way to use it.

How To: Double space a paragraph in MS Word in 2 clicks

In this video, we learn how to double space a paragraph in MS Word in 2 clicks. If you've needed to double space a paragraph, but didn't want to do it manually through each sentence, this will make it a lot easier. All you have to do is highlight the paragraph you are working with. After this, press the control button and the number 2. After this, the paragraph will automatically come up and show that it is double spaced. You can use this on your entire paper or just for a part of a paragraph...

How To: Adjust the mirrors in a 2010 Toyota Prius

In this tutorial, we learn how to adjust the mirrors in a 2010 Prius. The interior rear view mirror will dim automatically if it sense a glare coming into it. You can turn this function on and off by pressing the buttons on the mirror. There are also outside mirrors that have controls to the left of the steering wheel. Press the buttons to adjust the area the lens is at. There is also a defroster that will activate when you turn on the front or rear defroster. This will loosen any ice from th...

How To: Create your own unlimited water source in Minecraft

In Minecraft, survival is key, especially at night when the creatures of the darkness come out to play. If you're doing a lot of crafting work at night, one big pain is going out to get water and trying to find new sources of water. Wouldn't it be great if you could create a pool of water that automatically refilled itself all the time? It's really simple and fast to make! All you will need is two buckets of water and a shovel! In this great video you will watch as he designs the pool and cre...

How To: Use clip playback in Ableton

In Ableton, you can set follow actions to tell clips to do something on a timed basis. The time can be immediate or random, but it is automated. This is more efficient than doing the follow actions manually. Go to clip view, type "L". This launches the settings which gives the space of time in which the follow action happens. You can set more than one follow action. You can determine when and how often the action will take place. You can determine when the clips occur automatically. The clips...

How To: Create custom brushes and patterns in Photoshop

Importing custom brushes and patterns into Photoshop is not too complicated, you can probably handle that already. But what if you want to create your own? This video will teach you how to create your own custom brushes and patterns within Photoshop, which you can then use yourself or make available to others on the web. The former will save you lots of time when you find yourself making the same pattern over and over again because you can make a brush that will draw it automatically. How handy!

How To: Upload large files online without size limits

In this video tutorial, viewers learn how to upload large files online for free. The website recommended in this video is Load2All It does not host any files, but it provides a interface to upload the file to several other sites at once. If the file exceeds the limit for any given site, Load2All will automatically split the file into RAR files, upload it into several mirrors and provides one download link. This video will benefit those viewers who have a large file...

How To: Model a strand of Christmas Lights in Blender 2.5

This clip demonstrates the process of creating a model of a strand of Christmas lights in Blender 2.5. The tutorials covers modeling and how to use array and curve modifiers to create a strand of lights that will automatically lengthen as needed. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial fro...