How to stop downloading FB Profile Picture

Facebook allows his users to quickly share the information, messages and photos with others. Your Facebook friends allows to downloading the profile photo at his device. But if you want to stop them, you can easily stop downloading FB profile picture. You can prevent any visitors to stop downloading Facebook profile picture. To do this job, you must have to change the simple thing in privacy setting to protect your Facebook profile picture. Read More

How to disable Mirror image in a selfie camera

Do you know during taking the selfie from the font camera off your smartphone image is reversed or mirrored? When you take all the selfies have been saved just like a mirror images on your smartphone. Do you know how to disable mirror image in a selfie camera on your phone? Read More

Autosave Excel file using code to protect file

Lot of time many peoples facing these issue like computer crashes, power goes out, accidentally close any file without saving and many more. In that situation you may lost of your working data, and you need to know how to autosave Excel file. There are lot of ways to auto save Excel file either using Autosave feature or using the code. Read More

Lookup Multiple Fields of Data with Excel VLOOKUP

With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More

How to show an Emergency contact number on your Smartphone

Approx 80 to 90% smartphone users lock his smartphone due to different reasons. But sometime in case of emergency you must add or show an emergency contact number on your smartphone locked screen. But if you don’t setup emergency contact number on your phone then nobody call to your family members in case of any emergency. This is very essential and
helpful feature for us. We must add an emergency contact to our phone’s lock screen. Read More

How to divert mobile phone calls to any number

Sometime when you are on the tour and your phone battery is going to die in that situation there is no way to get the call on your phone. But in that case you can easily divert mobile phone calls to any number using the secrete codes. Many time when you are doing some important things and you will be disturb due to receive any call or downloading will be stop. Read More

How to use LEFT Function with Find Function

Sometime we need to extract few characters of a string with the help of Left function. In this guide we have to discuss how to use Left function with Find function to extract the worlds. Excel allows you to use a user defined function to split a text string as per your need. To quickly split text string at specific character then you must have to know how to use Left function with Find function. Read More

How to turn on or turn off scroll lock key

Sometime you feel that you can no longer moving around the workbook area properly due to the scroll lock key. Most of the person facing lot of issues to turn on or turn off scroll lock key at his system. During working on excel sheet When you press any arrow key you feel column or rows are moving at the place of cursor moving to another cell. Read More