This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
This video shows you how to easily turn JavaScript on in Firefox. The first thing you have to do is open Firefox, click the Tools tab in the upper menu and then choose Options. After this, you have to select the Content tab. Then, simply check the "Enable JavaScript" box. Remember to click the OK button in the window. Next, you only have to restart Firefox by closing and re-opening it. You can now enjoy the benefits of JavaScript! Good Luck!
This video shows you how to disable the automated spell checker in Mozilla Firefox. The spell checker is supposed to be a great feature in Firefox, but lot of people find it annoying. The spell checker helps you correct your writing mistakes by underlining the misspelled word with red. You can easily disable it by opening the Tools tab in Firefox and selecting Options. Then, go to the Advanced tab in the popped-up window and uncheck "Check my spelling as I type". That's it! Good Luck!
Formatting the hard drive on Windows Vista is easy. First click Start, then Control Panel, Administrative Tools, Computer Management. When that opens up, click Storage Disk Management. This will open a window showing all the computer's partitions. It isn't possible to format C: because that is where the operating system is installed. We will format disk 2. Right click on that, and select New Simple Volume. This will open the wizard. Follow the prompts through the wizard to Finish. The compute...
This video is about creating sunbursts using symbols in Illustrator.
Google Homepage’s Theme is available from Google for customizing your Google Homepage. So, here’s what to do:
The most recent version of the iPhone Software (iOS 5) has the ability to utilize emoticons by use of the native keyboard and software, no third-party app or jailbreak required. Just follow these simple steps for unlocking the emoticon keyboard:
If you loved The Da Vinci Code by Dan Brown, then listen up— there's been a new discovery found hidden within Leonardo da Vinci's most famous painting— the Mona Lisa.
This how to video shows you how to restart Windows without rebooting the computer. Press control, alt, and delete on the keyboard at the same time. Your task manager program will open. Select processes and click image name to sort it. Select explorer.exe and press end process. Click yes in the warning dialog. Your start menu will disappear. This is usually bad considering you cannot do anything when this happens. Go to file and select new task. Click browse and click on any folder and right c...
In this video tutorial, viewers learn how to check the engine fluids of a car. Begin by checking the engine oil. Begin by finding the engine oil dipstick. Then wipe it down and return the dipstick. Recheck the dipstick and oil level. Now check the automatic transmission fluid. Find the transmission fluid dipstick. Then wipe it down and return the dipstick. Recheck the dipstick and oil level. Only check automatic transmission and not manual. Then check any other important fluids in the engine....
Miis are tiny versions of you that live inside your video games. On the Nintendo Wii you can personalize all of your games and add a little bit of your personality and appearance to the screen. Check out this video tutorial, and learn how to create a Mini Mii on your console for gameplay.
Learn how to create shiny, reflective and vector text in Adobe Ilustrator. Open a new file in Illustrator. Select pixel dimensions and orientation. Select the text tool and enter desired text. Ungroup the text. Select a portion of the text. Use the gradient editor to select a swatch and change the angle. Adjust the drop shadow. Create a reflection of the text using the horizontal reflect command.
Around 1000 cases of vulval cancer are diagnosed every year in the UK, mainly in women who have been through the menopause. However, there are also a range of other vulval conditions that affect all women – highlighting how important it is to self-check your vulva. Although it may seem daunting if you haven’t self-checked before, Dr Dawn Harper’s guide will show you exactly how to conduct the check – so grab that mirror! Watch this video tutorial and learn how to perform a vulval self-examina...
It happens to almost everyone. You wake up one morning, check your phone, and realize your alarm never went off. Now you're late to start the day, and you spend every night onward paranoid it'll happen again. But if you have an iPhone, there are two things you can check to make sure the alarm always goes off on schedule.
You no longer have to completely convert your default or primary system language to change the language of a single app on your iPhone. Thanks to iOS 13, each app can now have its own language settings: if you want Spanish for WhatsApp but English for Instagram & Twitter, you can do that.
Can you be too lazy for video games? That's how I feel sometimes. I want to play the latest PlayStation has to offer, but I can't be bothered to get out of bed. As if Sony read the minds of lethargic gamers everywhere, the company has released an amazing thing — PS4 Remote Play allows you to play your PS4 on your iPhone, no TV required. The best part? It's 100% free.
While many of Facebook's tools are well received as they enhance the experience, one which is often complained about is the Marketplace. The Craigslist-like feature which offers a way to facilitate transactions between users can be a little overbearing with its alerts. However, you can change that.
According to App Annie, the average person's phone contains 60–90 apps. Such a large amount can easily crowd an app drawer, especially since the same source states that only about 30 are used in a month. Having a way to organize apps in the app drawer can help you avoid wasting time searching.
Android has gotten significantly better at handling intrusive ads over the years. Things have gotten to the point to where these nuisances are largely a non-issue for most of us. However, there are still a few ad-laden apps that fall through the cracks — particularly the kind that bombard your lock screen with ads.
When WhatsApp first came out in 2010, it quickly gained notoriety as a great way to meet new people all over the world thanks to group chats, which allow multiple admins for each group that can all add participants from their own contacts lists.
Whether scheduling meetings, events, tasks, or even keeping tabs on the weather, a good digital calendar can help you stay on top of your game in ways that a normal calendar could never do. Indeed, there are many calendars to choose from, but Google Calendar is one of the best due to Google's excellent cloud service, feature-rich web-client, and their easy-to-use Android and iOS applications.
Many users across the web have reported issues with receiving notifications from the Gmail and Hangouts apps on Android. The problem is most prevalent with users running Marshmallow, and the gist is that notifications from these apps are extremely delayed or don't come through at all.
As Android owners, we ultimately have to look at our device and ask the difficult question: "Where the hell did all these applications come from?"
After I traded in my Samsung Galaxy S5 for an iPhone 5S, the one feature I truly missed was the Smart Remote app. My television remote was broken and the S5 saved me from, you know, actually having to get up and change the channel.
One of my favorite new additions to iOS is the ability to view battery usage stats on a per-app basis, which is helpful in knowing exactly which apps are taking up all of my iPhone's battery life. If you jailbreak iOS 8 on your device, you can take Apple's stock battery stats feature even further to give you details on how those apps are actually using the battery.
Believe it or not, but people are actually texting less than they did before, and that's all thanks to Facebook Messenger, Snapchat, WhatsApp, and other split-second communication services. However, one communication method that is still going strong—and dominating—is email.
Apple just unveiled iOS 8 at the Worldwide Developer's Conference, and it has a lot of exciting features to play around with. Unfortunately, it won't be available to the public until this coming fall—but that doesn't mean you can't get it right now.
It was just released a few days, but Facebook Paper has already taken the world by storm. CNET said it was a better way to use Facebook. TIME said it's the future of Facebook. The Verge called it the best Facebook app ever. There's one problem, though...
If you have friends like mine, letting them check out one photo on your phone means they're going to check out all of the photos on your phone. Before you realize what they're doing, it's too late, and they're sending out perverted emails to your coworkers, making you look like a newb at Candy Crush Saga, and viewing your Snapchats for you.
While there are many customization options available for the Samsung Galaxy Note 2, they aren't always easy. The large selection of custom ROMs and difficulty implementing certain hacks and mods can be a nightmare for anyone not well versed in all things Android. But the good news is, it doesn't always have to be complicated.
Whenever a friend borrows my Samsung Galaxy S3 to browse the web or make a quick call, I always pause to make sure there's nothing incriminating on it. I'm no superfreak, but some of my friends are, so I have more than a few photos on my device that I wouldn't wish upon anyone. I like to avoid these kinds of looks.
In a previous softModder tutorial, we installed CyanogenMod on our HTC Ones to approximate the look and feel of the Google Edition HTC One. Unfortunately, this rendered Beats and HTC's ImageChip (among other things) useless.
Select the image whatever you want from anywhere. For example, choose Google search and type high res yoda and select IMAGES choose the picture and save in your computer. Enter into rasterbator software. From the dialog box select the language what you know. Select the image using 'BROWSE..' button and we have to select '3D-Yoda.jpg' and click open button, and then click the CONTINUE button. We have to choose the standard paper size. Next press the CONTINUE button. In this dialog box we have ...
Frederic Patenaude demonstrates selecting and cutting a fresh pineapple. To select a fresh pineapple, he discusses that the color is not a great indicator. Instead he suggests looking at the bottom of the pineapple to make sure the base is yellow, indicating ripeness. He also smells the pineapple to make sure it smells ripe. he also checks for bad spots, softness or leakage around the whole fruit. He communicates that any tests with leaves are also not indicators. One way to cut a pineapple i...
Step1. First of all you need to remove all the borders. Scroll up and then select all the text lines that have 'border' mentioned and then delete them.
This video demonstrates how to change a drive letter to a certain drive in your Windows 7 computer. On you Windows 7 computer, go to Start > Control Panel. In the Control Panel, select System and Security then open the Administrative Tools. Look for and open the Computer Management tool. On the left side pane of the Computer Management window, select Disk Management. Look for and right click on the drive you want the drive letter changed. Select 'Drive Letter and Paths...'. Click change and s...
Yes, you can use GarageBand's Auto Tune to sound like T Pain and Kanya West. To start with, in GarageBand, click the plus sign in the bottom left hand corner to create a new track. A window will pop up, Real Instrument Track should be selected by default. Click the Create button. In the Track Info window check to make sure your Monitor is set to On. In the bottom left hand corner, click on the button with the scissors in the middle of the sound wave. This is the Edit Track button. Click on Ad...
Are your high resolution photos taking too much space on your hard drive? Tired of getting file too large error when emailing photos? Don't worry Photoshop Samurai will help you batch resize your photos as fast as a ninja! You will need: Photoshop (Not Elements version), photos that need to be resized Go to file, then scripts and select image processor. Select the source folder (where your pictures are stored on your computer). Then select a destination location (where you would like the proc...
This video tutorial by Tasktutorial shows you how to create a simple swatch in illustrator. Select the star tool, draw a star and select the path and scale it down as shown. Change the fill color to white, the stroke color to black and the stroke weight to 2 points as indicated. Select the rectangle tool and draw a background for the star, bring to back, change the fill color to blue and de-select the stroke as directed. Align the shapes using the align tool and select both paths and bring in...
Learn how to blend shapes and colors in Illustrator with this tutorial. Open Illustrator and put the circle with color which you want. Put the square on the color you want. Select the object, go the title bar select the object and then select the blend. You will be shown the result on the screen. Select the square and circle where you place the object by click and drag method. Go to the object and select the blend and choose the blend options. Change in specific steps which you want in the sc...