How To Cross Reference And Link Cells Between Different Excel Files

paste_special_excel
Linking two excel sheets so that one can read a value from the other is much easier than it sounds and it's a function that a lot of people need. No one has just one Excel file and while it is easy to add data from file to the other, keeping up with the changes so that they are reflected across all files is both time consuming and prone to error. The following little tutorial helps you link a cell from one Excel file to a cell in a different Excel file such that it updates itself. Read More

Communicate With Hearing Impaired Individuals Without Using ASL On iPhone

iCantHear
Most people at some point will become familiar with a few phrases in ASL but unless you know someone with a hearing impairment and you have to communicate with them frequently, there is only a small chance that you might know enough ALS to have a conversation. Flip the table; if you've got a hearing impairment and find yourself in a situation where you need to talk to someone who doesn't know ASL you have a problem. Fortunately in both circumstances an iPhone and just about any other phone with an internet connection and a browser can help you out with an app and service called I Can't Hear. Read More

Force Facebook To Detect Thumbnails And Links When Sharing A URL

thumbnail Not detected FB
A few months ago, I started experiencing problems with Facebook. Whenever I shared a link from a Facebook page that I owned or that I was managing, there would be instances where Facebook would not detect that I had pasted a URL in the status box. Other times, it simply wouldn't load an image to use as a thumbnail. The latter I attributed to my internet connection acting up but the problem was recurrent even though it didn't reproduce itself 100% of the time. When Facebook failed to detect a link all together despite multiple attempts, it became a problem instead of just an inconvenience. Fortunately, there is a simple solution to it and from what I can tell, this is a problem on Facebook's side. Here's how to fix it for your own Facebook pages. Read More

Add Color Filters To Videos On Your iPhone

Redcam_crop
Instagram made photo filers exceptionally popular and there are now lots of different apps and services that exist solely for adding filters to a photo. These apps set themselves apart from each other with the library of filters they have to offer and some do try to enter the social sphere by allowing users to share the photos they've created to the app's own network. When Instagram launched video sharing it allowed users to add filters to videos as well but the length of the video was limited. If you want a really simple way to add a color filter to a video without adding a watermark or having to cut to the video short, give Redcam a try. This app was originally developed to make recording a video super fast but it's editing options are the real noteworthy feature. Read More

Reduce Data Consumption By Chrome On Your Phone When Not Connected To WiFi

chrome_reduce_data_usage
Using your carrier's network plan to stay online taxes your device's battery as well as your bandwidth. Unless you've got bandwidth to spare or you can afford a plan that is generous in bandwidth, you're probably looking for ways to reduce data consumption. Chrome for iOS and Android both come with a built-in option that lets you manage how the browser loads data though surprisingly you have better control options on iOS than you do on Android. Here's how you can get the browser to eat up less of your data plan. Read More

Archive & Reply To Emails From The iPhone Notification Center With Gmail App

gmail_lockscreen_reply
Gmail's just received an update and it has a few really useful new features that let you archive or reply to emails from your lock screen and the notification center. The update doesn't require you to add Gmail as widget to the Notification center but allows you to instead choose whether you want to reply to an email or archive it from the notification alone. If you choose to reply to an email, it will launch the Gmail app, load the email in question and take you to the 'Reply' screen. Emails can be archived by just tapping on the option in the notification center. Here's a look at the new feature. Read More

Use Custom Templates For Any iWork Productivity App On iCloud

template_rename_file
Apple opened its iWork suite up to everyone last year making it super easy for anyone to use its productivity apps. These apps include Pages (documents), Numbers (spreadsheets), and Keynote (Presentations). Like any great productivity suite, these come loaded with templates from Apple. You can also buy templates which are downloaded to your computer as zipped files. Unzip them and you've got absolutely nothing that can be used from the iCloud web interface. The templates only work if you've got a Mac. This effectively makes them useless because the web version of Pages, Keynote, and Numbers don't let you load a custom template. There is however a simple way to work around this and use a template you've maybe bought and downloaded to your system. Here's how. Read More

How To View Pages File On Windows & Convert It To PDF

iCloud_home
Mac vs. Windows, iOS vs. Android, black & blue vs. white and gold, are just some of the things we like to argue about. They're the finer points of conflict in life that you can bring up when you're bored and conversation is running dry. There does come a time though when the difference actually becomes a problem like when you have to open a platform specific file like a Pages document on your Windows PC. Not only that, you might need it converted to the DOCX or PDF format so that you can view it easily on other non-Apple devices. Here's how. Read More

How To Embed A Video From Twitter To Your Website

embed_video_twitter
Twitter has always supported embedding for tweets. The embed code adds a nice card to your website which updates to show the number of times the embedded tweet has been favorited and retweeted. Any images that have been tweeted appear in said card as well and now Twitter has added video embedding to its interface. Any video that you've tweeted or that has been tweeted publicly can now be embedded directly. Here's how. Read More

Record Screencast On Your Android Phone Without Connecting It To Your PC

One Shot settings
We've covered a lot of screencast tools for just about every platform there is. When it comes to smartphones, screencasts aren't easy to record. In  fact, up until Android Lollipop, there were very few options available for recording a screencast that were super easy to set up, free, allowed unlimited recording, and didn't require a PC or a rooted device to create. If you're looking for a free tool that can record screencasts, supports input from your device's mic, and can be used from just your device alone, give One Shot Screen recorder a try. It fits the bill very nicely. The only annoyance is the marqee like watermark that appears on the notification bar. Read More

This Search Engine Can Find Any Calvin & Hobbes Comic Based On Keyword

Calvin & Hobbes Search Engine
Calvin & Hobbes are possibly one of the most famous comic strips to run ever and easily stack up well against other popular names like the Peanuts strip. Calvin & Hobbes are of course not just limited to running in newspapers. The many strips and stories have been compiled in book form and make for great reading if you have kids. That said, if you've got a favorite strip from this title but can't find it anywhere, there's a nifty little search engine that will let you look up any strip with a simple keyword search. Not only can you read the strip from the results but you can also see if it's ever been included in a book title. Read More

Customize What Page Or Website The Chrome Home Button Opens

Settings - Homepage_change
Chrome has a Home button. I don't know why it has this button since its purpose by default is to open the New Tab page which is pretty easy to do with a keyboard shortcut (Ctrl+T) or with the new tab button that sits comfortably next to the open tabs. Unless you like using it for reasons of your own, the button is more or less just there because browsers have always had a home button. That said, Google and the team behind Chrome isn't one to comply with convention so the Home button it makes sure you have an alternative. The home button doesn't have to always point to the New Tab page. You can have it open any one website of your choice, without even needing an extension. Read More

Control Music Library From iPhone Notification Center

Musica_widget
I've never considered replacing the default Music app on my iPhone with a third-party one. You may or may not agree that the app is perfect but it gets the job done. You can still find a lot of music apps in the App Store and some of them are exceptionally popular. That said, even if you're perfectly satisfied with the default music app, you might want to give Musica - Widget Player a try. It's a free iOS app that, as its name implies is first and foremost a widget. The logical question to be asked is, do we need a music widget in the Notification Center when we can already play/pause songs, skip to the next or previous ones, and control volume from the lock screen and control center. The answer is yes because this widget-app puts your entire music library, all your playlists, and the shuffle and repeat song controls in the Notification Center. Before iOS 8, you could only get something like this on your iPhone if your device had been jailbroken. Read More

New Features In Firefox 36 For Desktop And Android

ff-banner36
Firefox 36 is out and this version is easily one of the least exciting versions ever released if you're an end user. It's got bug fixes and the usual security improvements but little else. The one major security improvement is that the HTTP/2 protocol is now fully supported. It has been implemented for both the desktop and Android versions of Firefox. The mobile version has also gotten a new tablet interface. The desktop version will now sync tiles for frequently visited web sites that appear on the new tab page across devices. For mobile users running Android Lollipop, Maithili language is now supported, and for desktop users support for the Uzbek language has been added. Read More

Open The Run Command Box From The Start Menu In Windows 10

run_win10_start
In Windows 10 the first thing you'll notice once you're done admiring the new Start menu is the absence of the search field that was a part of the Start menu in Windows 7 and part of the Start Screen in Windows 8. It's gone now and instead you have the Search bar. The Search bar isn't your average local search; it's also where Cortana resides and it also searches Bing for anything you might type in it (we're still looking for ways to get it to use Google instead). If you get used to the Search bar and the speed at which it generates results doesn't bother you, you can use it to open the Run command box but if you prefer the conventional way of opening the Run box, i.e. from the Start Menu, here's how to do it. Read More

Find What Regional Restrictions Have Been Applied To A YouTube Video

YouTube restriction
The internet is for everyone unless you live in the wrong part of the world in which case not all of it is for you. Copyright among many other things results in online content being restricted geographically. A very obvious example is Hulu which limits its services to the USA and understandably so. YouTube also allows users to restrict the content they upload to certain geographical areas. Sometimes these restrictions don't make sense especially when you're residing in the United Kingdom and can't see a video uploaded by the BBC. That said, there are plenty of ways to circumvent these YouTube restrictions but before you go looking for a proxy tool, it would help to know which regions a YouTube video is restricted in. YouTube Region Restriction Checker is a simple tool that tells you just that. Read More

View EXIF Data From Inside The Photos App On Your iPhone

viewexif
Extensions and widgets on iOS 8 have not been getting the attention they deserve. They are a whole new way to interact with apps without having to go through the home screen pages and they're flexible. Apple's opened up more of its exclusive and reserved areas to developers and told them to go crazy. A while back we reviewed View Source an app-cum-extension that lets you view the source of any web page in Safari. Another similar app/extension is ViewExif that lets you view EXIF data for a photo from the Photos app. Although it's a paid app, it is free for a limited time. Read More

How To Set Up Parental Controls On The YouTube Kids App

youtube_kids_PIN
YouTube Kids has just been released and its purpose is to help parents control what kids watch on YouTube. The content filters come built-in meaning YouTube decides (based on video rating and content) what types of videos are appropriate for young viewers. What it leaves in the hands of the parent is how long a child may use the app, and whether a child can freely search for videos. The settings are secured behind a PIN that will fool kids so long as they can't read numbers. Here's how the parental controls work in the new app. Read More

Stop GIFs From Playing Until They’ve Fully Loaded [Chrome]

gif_delayer
The internet has a love-hate relationship with GIFs; we can't wait for them to load and the longer they take, or the more they lag when playing the angrier we get. On the other hand, one good GIF can say what a thousand well-thought out comments cannot. It's safe to say that Imgur is the only one that understands our needs for great GIFs but even with its new GIFV format, users still experience that dreadful load delay and the choppy playback that is a result of a file still loading. Gif Delayer is a Chrome extension that stops a GIF image from showing until it is fully loaded. Meant specifically for users who are not willing to wait a few seconds for it to finish loading, the extension doesn't speed up the loading time but makes for a less frustrating experience. Read More

Search For Stickers In The Facebook Messenger App

sticker_pack
Facebook Messenger doesn't just try and capitalize on Facebook being a popular chat platform, it also tries to set itself apart from other services in the instant messaging niche. The stickers for one are really nice and the sticker library itself is pretty huge. It's almost like having a nice GIF keyboard. Given the rather large library and the fact that the galleries aren't exactly based on a single theme, or emotion, it's hard to find the right one when you need to. Here's how you can make it easier to quickly locate the right sticker during a conversation. Read More