How Do I Unsubscribe From an App? If you’ve subscribed to an app on your Android phone, it’s useful to also know how to unsubscribe if you’ve changed your mind or simply want to pause the subscription for a time. Here’s how to do so via your Android phone. How Do I Manage Subscriptions on Android? If you’d prefer to keep an eye on your Android app subscriptions, it’s also possible to view the subscriptions you have set up....

How to Setup a Nest Video Doorbell Setting up the Nest Hello doorbell requires the Nest app, which you can download for Android and iOS. If you already have a Nest product, you’ll use the same app to manage all Nest devices. What You Can Do for Free With Nest Hello Doorbell Nest products that record video, such as the Hello doorbell, have two different levels of functionality. You can use the device for free, but with limited capabilities, or you can pay for Nest Aware and give your Nest camera a productivity boost....

What Is Aero Shake? First introduced with the Windows 7 operating system and available on all versions of the operating system since then, Aero Shake minimizes all open windows on your desktop except one. As the feature’s name implies, the one you want to remain visible is the window you “shake.” Get Shakin' Aero Shake is easy to use: grab the window you want to isolate by selecting its title bar at the top of the window, which usually has a red “X” in the upper right corner....

Set up Your Sonos and Apple TV If you want to use your Apple TV with your Sonos Playbar or Sonos Arc, you’ll need to hook up the systems via your TV because the fourth-generation Apple TV and the Apple TV 4K don’t have optical audio-out connections. Here’s how it works. About the Sonos and Apple TV Setup You need to use your television to set up the two systems because the fourth-generation Apple TV and Apple TV 4K have a high-definition HDMI output and no optical audio-out connection....

How to Set Up Fitbit Pay To use Fitbit Pay, you need a compatible Fitbit device, which includes the Ionic and Versa smartwatches and the Charge 3 fitness band. To set up Fitbit Pay, follow these instructions: How to Change the Default Payment Card During setup, you must choose a default card, but you can change that at any time. How to Pay With Your Fitbit Once you’ve set up Fitbit Pay, you can use it whether you have your smartphone on hand or not....

How to Turn On Fortnite Parental Controls Fortnite parental controls have to be turned on from inside the game, so you’ll have to get your hands on one of your child’s devices to get everything set up. If your child plays on multiple platforms, like both PC and Nintendo Switch, you can set up parental controls on one platform and they will work on every other platform. What Can Fortnite Parental Controls Do?...

If you’ve ever written SQL queries to get data out of a database, then you’ll recognize the QUERY function. If you don’t have database experience, the QUERY function is still very easy to learn. What Is the QUERY Function? The function has three main parameters: =QUERY(data, query, headers) These parameters are fairly straightforward. Data: The range of cells that contain the source dataQuery: A search statement describing how to extract what you want from the source dataHeaders: An optional argument that lets you combine multiple headers in the source range into a single header in the destination sheet...

How to Turn On and Turn Off Scroll Lock in Excel If you prefer to keep your hands on the keyboard, this option is helpful. All you need to do to turn it on is press the Scroll Lock key (which might appear as the “ScrLk” key or the “scr lk” key), which is typically at the top of the keyboard. When you enable the Scroll Lock, a notification appears in the status bar at the bottom-left side of the Excel window....

What is the MID Function? The MID function allows you to extract text from the middle of a string. Like other functions, you use it by entering a formula in a cell that contains the function and it’s parameters. The following represents what a typical MID formula looks like: The formula’s parameters break down as follows: The first parameter (“A1” in the example above): This is the target of the function, and should represent some text....

How to Zero-Fill a Hard Drive With the Format Command Since you can write zeros to a hard drive with the format command both from within Windows 7 and Windows Vista and from outside the operating system, we’ve created two ways to proceed through these instructions. This process could take several minutes to several hours. With all the data replaced by zeros, there’s no longer any information to be found on your hard drive by a file recovery program....

What Is the Indirect Function? The indirect function is a way to convert a text string into a reference. That is, it draws information from a reference to another cell or range. It creates a reference from text, and doesn’t change when cells, rows, or columns are altered, added, or removed from a cited range. The references it creates are evaluated in real-time, so the reference is always accurate to the data it’s drawing from....

How to Use the Microsoft Family Safety App The Microsoft Family Safety app is Microsoft’s answer to Google’s Family Link app. It provides insights into how your child is using their phone, their location, and even lets you set time limits on app use and game time. Using Microsoft Family Safety has a few prerequisites. You need to have a Microsoft Family Group, your child needs to have Microsoft Launcher and Edge installed on their phone, and you need to add your child as a member of your family group....

How Do I Use the S Pen With My Galaxy Book Pro 360? Samsung’s Galaxy Book Pro 360 is compatible with the S Pen, a digital stylus you can use to draw on the 2-in-1’s touchscreen. The S Pen is included with the 2-in-1. Here’s how to use the S Pen with your Galaxy Book Pro 360. The S Pen that ships with the Galaxy Book Pro 360 does not use Bluetooth and does not rely on an internal battery....

How to Enable Offline Files to Use Sync Center Before Sync Center can sync any network files to your device, you must enable offline files: What Is Sync Center? Sync Center is a feature that was introduced in Windows Vista. Its main purpose is to synchronize your files with a network server so that you always have he most updated copies when you need them. How to Use Sync Center in Windows 10 Once you’ve restarted your computer and launched Sync Center again, you’ll have three new tabs in your Offline Files settings:...

Does WhatsApp Work on iPad? The WhatsApp iOS app doesn’t work on iPad. It’s only available on the App Store for iPhone users. It won’t work on any iPad right now, until WhatsApp decides to launch an iPad version of the app. However, you can get WhatsApp to work via the web interface and a small workaround method that works via the iPad’s Safari browser. It’s not perfect, but it’s an option....

Before You Start To get started, have Chromecast installed and streaming your content. Then, make sure your Chromecast is updated to the latest firmware. Your Chromebook should also be updated to the latest version of Chrome OS. Having a Chromecast already connected to your TV also means you don’t need to physically connect your Chromebook to view media. Without a Chromecast, you’re forced to drape an HDMI cable from your Chromebook to your TV....

Use a Proxy This method will trick the website into thinking it’s your first visit. This works only for sites that blur the text after you’ve reached their limit of free articles. There are many ways to do this—including just erasing your browser cookies and trying again—and there are even entire services built around it. The last step provides a few alternatives, but we’ll show how this works using the Internet Archive....

How to Stream the US Open from ESPN If you have a cable or satellite subscription, but you want to stream the US Open on a computer or laptop instead of watching on your television, you can use the WatchESPN live streaming website. This site provides free access to sports events broadcast on ESPN and ESPN2. You can use WatchESPN on your Windows, macOS, or Linux computer or laptop, as long as you have a web browser like Chrome or Firefox that supports streaming and a high-speed internet connection....

If you use Apple Wallet and stay at one of six (to start) Hyatt hotels, you can now access your room and other locked areas with your iPhone or Apple Watch. The new program, which was just announced today, is intended to offer hotel guests a faster, contactless option. According to Hyatt, you can use the World of Hyatt app to make a reservation, check in, and add your room key to your Apple Wallet—once the room is ready....

Types of External Enclosures This category includes a wide variety of enclosures, from small USB flash drives, which can serve as temporary storage or as a permanent home for apps and data that you need to carry with you, to large drive arrays that hold multiple storage devices in one case. USB flash drives: Small, portable, and relatively inexpensive, these house capacities ranging from 2 GB to 2 TB. The downside is their slowness, especially when you’re writing data to them....