Creating a drop down list in Google Sheets using data validation is pretty simple. When a cell has data validation applied to it, people who use your spreadsheet will be able to select a value for the cell based on a list that you create. You can refer to the content selected in other cells, which gives you a lot of freedom for dynamic spreadsheets.
Category Google Sheets
Your files are important, so a periodic backup of your data is highly recommended. This is because storage devices are always at the risk of being corrupted, damaged, lost, or stolen. Performing backups from one storage device to another ensures that you have copies of your files. When relating this to your phone, it is of the same importance to back up your iPhone to a computer so that you can recover files that may get lost due to uncontrollable circumstances. This backup method differs from the iCloud backup because it does not require any internet connection. Learn how to back up your iPhone to a computer here.
Apple’s iOS has taken messaging to a whole new level. Aside from being able to send messages with effects, you can now play games on Messages for iPhone iOS 10. Battle against your friends to find out who is master of the mini-games. This tutorial explains how to use the App Store for Messages to download and install the games.
For most people, a smartphone is essentially a storage device for their digital files. Whether it be that baby picture taken a year ago capturing your little one’s first smile, music and video files of your favorite artists, or an important file for work, ensuring that your data is stored securely is crucial. This is the reason why you need to back up your iPhone to iCloud. Regularly backing up your phone will keep you from losing of all your files whenever your iPhone is lost, corrupted, or stolen. You can back up your iPhone to iCloud and save your important data online. Here’s how.
The iPhone’s call forwarding feature is basic. You simply flick a switch to enable the feature, and then enter the phone number where you want your calls to be diverted. Our tutorial on how to forward iPhone calls should get you started. However, you may be wondering why iPhone has stuck to such a basic forwarding feature while early Nokia phones have advanced call diverting features which allow users to forward calls when the phone is busy, left unanswered, or when you are unreachable. The answer is that the iPhone also has those features, but they are hidden. This tutorial will show you how to find and use conditional call forwarding on iPhone.
Apple has released the latest iOS update for 2016. Considered the biggest update to Apple’s most popular operating system, iOS 10 has many changes, improvements, and features included in the package. You can now add more drama and emotion to your messages on iPhone by sending them with effects. The feature is one of the more noteworthy improvements to the Messages app on iOS 10. This tutorial explains how you can send messages with effects on iPhone iOS 10.
Category Apple iPhone
You can use your iPhone as an audio recorder with the native Voice Memos app. Aside from using Voice Memos to make audio recordings on your iPhone, you can use the app to edit and share them. This tutorial explains how to record, listen, edit, trim, share, rename, and delete voice memos on your iPhone.
A big part of what makes Pokemon Go so universally loved is that it gives players the ability to see Pokemon appear in the real world through augmented reality. In fact, Pokemon Go is the game that is introducing the concept of augmented reality to the masses. You can find plenty of articles like this one which show Pokemon appearing in humorous places. However, there is a downside to using this fun feature in the game: It is harder to catch Pokemon and win gym battles while augmented reality is turned on. The steps in this tutorial explain how to turn it off.
Smartphone performance appears to have reached a plateau. With manufacturers trying to win the specs war, most of the flagship phone’s have reached a point where there is little to improve. The game has risen to a whole new level with a focus on features, aesthetics, and battery life. As developers are pushing smartphones to their limits with powerful apps, games, and features, batteries are taking quite the blow. Battery draining apps that update frequently require power – more power. Samsung has offered features to save more battery life and to optimize the battery life of its devices. Now, in an effort to give consumers even more control over their phone’s batteries, Samsung has introduced App Power Monitor. Using this new feature on the Samsung Galaxy Note7, you can keep an eye on battery draining apps and control when they use power. This tutorial will help you extend your Note7’s battery life.
With the introduction of the Note7, Samsung has focused more on phone security. Boasting the industry’s first iris scanner, the Galaxy Note7 simplifies how your unlock your phone while keeping your phone secure. In addition to the much anticipated iris scanner, Samsung has introduced Secure Folder. Secure folder stores and hides your personal content such as apps, media content, and other files. These are all hidden from anyone else who might use your phone. This tutorial explains how to set up Secure Folder on Samsung Galaxy Note7.