How to Sort Data in Excel for Mac 2011 Sorting data in Excel for Mac is a very efficient and helpful tool. I find that it is among the tools I use most often in the program. Whether you need to group similar data, or you want to be able to look at a list of products by their item number, effectively sorted data can be a real time-saver. So continue reading below to learn how to sort in Excel for Mac 2011....

But if you have been using the screenshot tool in Powerpoint, you may have noticed that some of those screenshots automatically include a hyperlink. If this is a feature that you don’t want to use, then you can follow the steps in our guide below to turn off that setting. How to Stop Powerpoint from Automatically Hyperlinking Screenshots The steps in this article were performed in the Microsoft Powerpoint for Office 365 version of the application....

One of the types of content you can stream is television shows, which usually involve a number of separate episodes. If you are using the Prime Video app on your phone, then you might have found that it’s trying to help you out by downloading the next episode automatically. But you may be trying to figure out how to stop Prime Video from downloading the next episode on an iPhone if it’s using a lot of storage space, or if you hadn’t disabled the option that let it download over cellular....

But if you have a Google Docs file that you had previously shared with someone else, such as a Google Docs newsletter created with a template, you may find yourself in a situation where you want to remove their ability to edit that document. Our tutorial below will show you how to remove sharing for a user in a Google Docs file. How to Remove Sharing Permissions from a File in Google Docs The steps in this article were performed in the desktop version of the Google Chrome browser, but will work in most other modern browsers as well....

But, depending on the way that you use your iPhone, this might be more of a hindrance than a help. Fortunately you can disable the Reachability setting on your iPhone and stop the iPhone screen from sliding down whenever you press the Home button twice. What is Happening When the iPhone Screen Slides Down? Some iPhone models have gotten pretty large. And while many people can still hold the device comfortably and use it without any changes, there are others who might have trouble reaching items at the top of the screen with one hand....

Watch an iTunes Movie or TV Show Without Downloading It I love the Apple TV for its’ ability to stream iTunes content directly to your TV, but its not the only device that is capable of accessing your iTunes content in the cloud like this. So read below to learn how to stream iTunes content to your computer. Step 1: Click the iTunes icon in the dock. Step 2: Click iTunes at the top of the screen, then click Preferences....

One way around this is to use a setting on the device called “Easy Mode.” This mode changes the way that the device presents your apps, plus it makes icons and text larger and easier to read. If you would like to try out Easy Mode on your Galaxy On5 to see if it is preferable to the default standard mode, then you can follow the steps below. Get Larger Icons and a Simpler Interface With Easy Mode on the Galaxy On5 The steps in this article are going to enable a setting on your Galaxy On5 that is called Easy Mode....

How to Tell If Someone Saved a Snapchat Open Snapchat. Swipe right on the camera to go on the chats page. Click on the chat you want to view the saved messages for. Swipe down on the screen to look at previous chats. Look for messages that have a grey background. If a message has a grey background, then it’s been saved by the other person. This will also be the same for pictures videos, text and links....

It provides the users the platform for using Chrome as well. Over the years, users can purchase movies, books, and music as well on Google Play and the purchased content can be accessed by the same account users via different devices and through iOS also. What is Google Play balance? A huge number of applications are available for download via the Google Play store either for a cost or free of charge....

But some of the default apps on your iPhone may have access to other default apps enabled in an effort to let you use those apps as intended. Much of this access can be disabled, however, including Safari’s access to your camera and microphone. Our tutorial below will show you where to find and turn off this setting if you would like to prevent Safari from using those features. How to Disable Safari’s Camera and Microphone Access in iOS 11 The steps in this article were performed on an iPhone 7 Plus in iOS 11....

Usually, the watch screen stays off, but the first time it stayed on all night, I knew that I needed to find out how to turn off nightstand mode on Apple Watch. How to Stop Apple Watch from Lighting Up at Night Our guide continues below with additional information on the WatchOS nightstand mode, including pictures of these steps. Your Apple Watch has a lot of interesting features that longtime watch owners still find out about even after they’ve had the device for years....

Disable Notification Sounds on the iPhone’s ESPN Fantasy Football App Note that if you were using the ESPN Fantasy Football app last year, then you may currently have two different apps on your phone. Be sure to follow the steps below to disable the sounds for the new app, then you can follow the steps in this article to delete the old app. We are also only going to be disabling the notification sound....

Fortunately this setting, called Predictive, can be turned off on your iPhone or iPad in iOS 9. Our guide below will show you where to find this is the settings menu, as well as two other ways that it can be turned off or minimized directly from the keyboard. Here is how to disable the predictive text setting on your iOS 9 keyboard – These steps are also repeated below – Step 1: Tap the Settings icon....

However, you may not feel confident storing your credit card information in your browser, and decide that you no longer want Safari to ask to save that information. Our guide below will walk you through the steps required to turn off the Credit Card option of the Safari AutoFill feature. Stop Safari on Your iPhone from Asking to Save and Autofill Credit Card Information The steps in this article were written using an iPhone 6 Plus in iOS 9....

Do you want to watch Netflix on your TV? Find out about one of the cheapest and easiest ways. Send and Receive Picture Messages on the iPhone 5 Sending and receiving picture messages can count against your monthly data allowance, which is something to consider if it’s a feature that you plan to use a lot. Additionally, those images are stored in the Messages app, which can cause it to use a lot of storage space....

Fortunately it is possible to unhide only the first column in your spreadsheet by following the procedure outlined below. Unhiding the First Column in Excel 2010 The steps in this article will assume that you have hidden the first column in your Excel spreadsheet. The procedure below will only unhide column “A”. If there are other hidden columns, they will remain hidden. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here....

Take Netflix Off of the iPhone 5 Uninstalling Netflix on your iPhone is the same as uninstalling any other app on the device. If you change your mind later, however, you can always re-download the app from the App Store and start using it again. So follow the steps below to uninstall the app. Step 1: Navigate to the screen on which your Netflix app is located. Step 2: Press and hold your finger on the app icon until it starts to shake and look like the image below....

In a recent Froyo, Android 2.2.1 update, Samsung released a faulty version. This resulted in many problems for some, and few for others. Resoundingly similar though is that the video camera either stopped working or became extremely unstable for users with the Epic 4G variant. Thankfully, Samsung released a camera-specific firmware update that should mostly correct this issue. I say “mostly” because the camera is still a little slow, but I confirmed that it does work now....

The Focused Inbox feature works alongside the Other Inbox, which allows you to view “other” non-essential messages. These are considered to be less important and may include emails that are sent in bulk (eg. email newsletters) or those that are generated automatically. By using the Focused Inbox in Outlook on Mac, you can tend to the emails that matter most to you first before you tackle any non-important emails in the Other Inbox....

Fortunately there is a simple way to view the formulas in your table so that you can confirm that they are working correctly, or in case you need to troubleshoot a formula that is not outputting the correct result. Microsoft Word has a few different view options, but if you haven’t used them before you might not realize they are available. Our how do I get my Word document back to normal view article can provide additional information....