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...
Check out this tutorial for a cool magic trick that you can easily perform for your friends. All this trick requires is a little preparation and you will be wowing crowds in the bar in no time.
In this video tutorial we learn how to assign a macro to a button or a check box in Excel. The first thing you want to do is to place the macros you want to use in the spreadsheet. You can assign a macro to any object within Excel. Next draw the shape in the spreadsheet that you will want to assign the macro to. Then, right click on the shape that you've drawn. Then go down to assign macro and select your Macro in the pop up box and click OK. Now, anytime you click on the button the Macro wil...
First type your word and set the font. Now select the word and break it apart by pressing the ctrl+B twice. Now select the erasing tool and erase the letters in reverse order like when you write that word, you write it in a order but you need to erase it just reversal of it as you can see in the video. Now press the F6 button, it will create a keyframe, select
Editing photos can be tedious, especially if you are using a similar theme for all of your photos. It takes time to select every tool, play with the bars, and find an adjustment that you're happy with. Luckily, there's a faster way. Adobe Lightroom for Android and iPhone allows you to save your favorite editing presets so you don't have to change every photo every time.
Apple has finally addressed and issued a fix for Error 53, a "safety" mechanism that would prevent your iPhone from booting if you had certain repairs done outside of Apple's official channels.
If your smartphone is ever lost or stolen, it's a terrible experience. If you file a police report, chances are the responding officer will need your device's IMEI or MEID number if you want to stand a chance of getting it back. Same goes for making an insurance claim on a lost or broken phone, so it's definitely important to have this unique identifier handy.
Work, school, and everything in between keeps us pretty busy—so much so, that sometimes we run out of the house with our shirts on backwards, our headphones misplaced, and our computers running all day long.
As it is right now in iOS 7, there is no quick way to delete all of your message threads in the Messages app at the same time. They can only be deleted one by one. If you followed our guide on jailbreaking, you could add a "delete all" option, but this is no longer necessary with the iOS 8 update.
Much like the Pen Window feature in Air Command, Multi Window is extremely useful in its functionality, but bogged down by serious restrictions. While you can open and use two apps at the same time, you're limited to only a handful of apps that can utilize the feature, leaving all the other ones shit outta luck.
This how to video shows you how to do a live trace in Adobe Illustrator. First, open the image you want to use. From here, zoom out. Go to the corner of the image and hold shift and drag to shrink it. Zoom back in and then click the arrow beside Live Trace. Go to tracing options and click okay. Check ignore white so that you will not get a box. Click trace and then select expand. Click out of the image and click control y on your keyboard to show the outline of your file. If you did not check...
This video shows us the method to make simple GIF animations in Photoshop Elements 6. First we have to make a file with different layers. Click on the icon below the 'Layer' option to make a new layer in the file. After finishing the file, go to 'File' and the 'Save for Web' option in it. On the right side of the window, select 'GIF' as the file type. Check the 'Animation' option. Check 'Loop' to play the file again and again. Click 'OK' and the window to ask you the name of the file will be ...
This video illustrates the method of Removing Ubuntu Linux installation and the GRUB Loader. The process is composed of the following steps -Step 1Insert the Ubuntu Linux Live CD. Boot from CD and select the install option.Step 2Click on install button and wait until the next screen appears. Now , you would be presented with two options that would enable to either "Uninstall Ubuntu" or "Install it again".Step 3Choose the Uninstall option and check the Remove GRUB loader option. Also check the...
In this video you will learn how to remove the Trojan .dnschanger virus with Malwarebytes. To see if you got a Trojan .dnschanger virus go to your network connections right click on Local Area Connection, select proprieties, click ok internet protocol, click again proprieties and if you got an ip address at preferred DNS server that means that the Trojan entered a fake ip address. You can remove the Trojan. To do this first run the Malwarebytes application, click on the update tab, click on c...
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
This video tells about the screen resolution of your monitor. In this video it is said that we can check our screen resolution by opening the site www.whatismyscreenresolution.com .While you get into that site our screen resolution will be displayed in the screen. But the screen resolution can be checked easily by clicking the right button of the mouse in the desktop and then selecting the properties button. In the small window that appears click on the settings tab. In that window we can see...
Step 1 In the Adobe Flash program, select “Flash File (Actionscript 3.0)” from the “Create New” menu. Switch the workspace layout by clicking on the dropdown menu in the upper left of the top menu bar, and selecting “Designer.” You can adjust the size and color of the document by adjusting the settings in the Properties panel.
In this video the instructor shows how to check if your computer has a home group setup or setup one if required. Home group is Microsoft's new way of making networking easier with computers. They allow you to share documents, pictures, videos and all kinds of media between computers that are a part of a home group. Go to the start menu and go to Control Panel. In the Control Panel select the Network and Internet link. Now in the Network and Internet window select the Home group. In this page...
During the dead of winter when it's 20 degrees below freezing and you can barely feel your own eyes you really don't care that much about the style and fit of your coat. You just want something warm, thick, and cuddly and you want it FAST.
Are you the next Michelle Phan? Or have an itching desire to outdo Rebecca Black with an even more awesomely horrible autotuned prepubescent anthem? Then you are the perfect candidate to upload stuff onto Google Video. Like YouTube, Google Video allows you to share your videos with everyone, no one, or a select group of friends and family.
This video demonstrates how to run a scandisk in Windows XP. To do this, just right click on your c: drive and select properties, click the tools tab, hit check disk and click ok.
First of all you have to start by terracing all the lands. Now select the varieties of trees that you want and start planting them in your garden. These trees shall help you in checking soil erosion. You may also use rocks fro land scalping and also checking soil erosion. Now you can plant ‘daisies’ all around the garden. These grow very fast and then they help to bind all the soil together. However you have to check their growth because they compete with other plants for the nutrients. They ...
One of the downsides of living in an unprecedented age of connectivity is the near-constant bombardment of information. WhatsApp, the go-to messaging app for people the world over, is just as susceptible to buildup of useless media files, thanks to awesome features that allow us to communicate in multiple ways, such as broadcasting to friends and family. Luckily, the app makes it easy to remove old and unwanted data from your iPhone or Android.
The Google Play Store may have fewer restrictions that its iOS counterpart, but that doesn't mean that all apps make the cut. Ad blockers and Xposed modules that bypass paywalls have never had a place on the Google Play Store, which makes tracking their app-updates a painful process.
While having a ton of friends on Snapchat does wonders to stroke my ego, sending content to all of them at once becomes a hassle when I have to go one by one, checking each contact individually.
Call it OCD if you will, but I make it a priority to have a clean Notification panel. Like a chalkboard that isn't wiped spotless, I get an unsettling feeling that something in the universe isn't complete when there's unnecessary clutter in the drop-down. For this reason, I loathe the fact that I can't remove the "Wi-Fi connected" tile from my "Notifications."
LG has really made their new G3 handset something to drool over. The hardware and software behind it can be considered as good, or even better than most flagships out there, and it has left me second guessing my decision to stick with the M8.
Multi Window, a feature that was greatly improved with the release of the Samsung Galaxy Note 3, is still quite limited on the older Note 2, allowing only the use of a few stock applications to multitask with.
Whether you have the original Nexus 7, or the 2013 Nexus 7 tablet, rooting it will give you access to tomorrow's features, today.
When you enter the softModder realm by rooting your Nexus 5, you open up an exciting world of possibilities and deep customizations for your device. Among other things, it gives you the ability to flash custom ROMs which, individually, act as entirely different operating systems that can vastly alter your user experience.
There are several ways to get around location restrictions on subscription sites like Netflix and Hulu using apps, extensions and proxies, but they tend to only work on laptops and computers. Users who want to access content from mobile devices and gaming consoles are usually out of luck.
At some point, we all need to back up our device. Maybe it's time to take it in for repairs or maybe you're just cautious and paranoid. Maybe you're trying out a new ROM on your Nexus 7—then you definitely need to back up. The most secure way would be to use a custom recovery like ClockworkMod or TWRP, but if you're not rooted or planning to root, then you'll need an easy alternative.
Regular wallpapers are like so 2012. That's where live wallpapers come in, bringing your background to life like a static wallpaper never could, with colorful animations, customization, and even interactivity. I've already shown off some of my favorite interactive wallpapers, but these type of apps are released at a rapid pace, making it difficult to choose just one that best fits your needs.
Communication is the key to any healthy relationship, and when I say any, I mean human and non-human. Previously, one of the biggest culprits for not understanding what you meant was Siri, but now it looks like it has some competition with the new Kinect system, which can control practically everything on your Xbox One—if it can understand you.
Unlocking your Samsung Galaxy S4 so you can use a different SIM card isn't the easiest thing in the world. In the states, unlocking cell phones was actually illegal, despite the White House's disapproval, though, a recent bill has making its way to the House floor and has made it legal again.
I've been a Sprint customer for a long time. Normally, Sprint (flagship) phones come with some useful apps, such as Sprint TV, Sprint Zone (for payments, updating PRLs, and account information), and NBA Game Time. In other words, relatively free of bloat.
In this tutorial, we learn how to get Games on Demand on Xbox LIVE (Xbox 101). You will find all the newest games as well as classics and downloading is easy. It's the same process as downloading the demos. Just head to the marketplace and select from the title choice. You have the option to charge the title to your credit card or using points to purchase it. Each game is several gigabytes in size, so give it lots of time to download. To familiarize yourself with games, go to the website for ...
In this video tutorial, viewers learn how to hack the flash game, Age Of War 2. Users will need to download the Cheat Engine program for this process. Begin by starting the game. The game should start with 2500 gold. Then pause the game and open Cheat Engine. Click on the Process computer icon and select the current web browser. Now type "@500" into the Value box and click First Scan. Then deduct your amount of gold, type in the new value and click on Next Scan. There should only be 1 result ...
In this Computers & Programming video tutorial you are going to learn how to export LinkedIn contacts to an address book. LinkedIn is great for keeping your contacts in your professional network. To export your contacts go to home page and click on ‘contacts’. Now your full network of contacts will be displayed. On the right hand bottom, click on ‘export contacts’. On the next page select where you want to export the contacts, type in the security code and hit ‘export’ and all the contacts wi...
This video tutorial from tarunkumarsinghal shows how to change Mac address on Windows XP. Click Start menu and then Control Panel. Make sure control panel window is in classic view mode. If not, change it to classic from the left pane.