Spreadsheets can quickly become difficult to read as you add a lot of information. It becomes even more complicated when the information in your columns is very similar to other columns. One way to simplify this is by creating a header row. By entering a description of the type of information that is contained within a column it becomes easier to edit, and the information is easier to read. Once you’ve added those descriptions, you can then choose to freeze that header row at the top of the sheet....

Fortunately this is possible by adjusting a setting in the Spotify Preferences menu. Our tutorial below will help you find this setting so that you can minimize Spotify to the tray instead of closing it when you click the red X at the top-right corner of the Spotify window. How to Keep Spotify Open When You Click the Red X The steps in this article were performed in the Spotify app on a computer using Windows 7....

It’s possible that you have already explored the different tabs in the navigational ribbon at the top of the Word window and discovered various things like the WordArt tools that the application offers for customizing the appearance of the text on the page. But you might be unclear on which of these tools to utilize if you simply want to apply a colorful border to some of the text in your document....

Block the App Store on the iPad 2 Note that enabling this setting is going to temporarily remove the App Store for all users, including you. If you need to access the App Store in order to download or update an app, then you will need to return to the Restrictions menu and re-enable the App Store using the password that you will choose below. Step 1: Touch the Settings icon....

Microsoft Word is an impressively versatile program, and one of the more common ways that I find myself using it is to print address labels. While the labels that I am printing in Word may not always necessarily be address labels, the method for creating them is identical. Return address labels can be a lifesaver when you need to do a mass mailing. However, if you have never done it before, or if it has been a long time, then setting them up correctly might be a bit of a challenge....

One option that is available to you involves a noise cancellation feature. This will help to reduce the ambient noise on calls so that you can better hear the voice of the other contact. Our tutorial below will show you how to reduce ambient noise on iPhone 5 phone calls by changing a setting on the device. How to Enable iPhone 5 Noise Cancellation Our guide continues below with additional information on how to reduce the ambient noise on an iPhone phone call, including pictures of these steps....

The ability to add layers and make high resolution images in Adobe Photoshop CS5 is great when you are designing images. If that image is then going to be printed, then you probably will not need to worry about the file size of the design that you are creating. However, if you need to email your design to someone, or if you need to post it on a website, then the file size of a JPEG image that you create must be taken into consideration....

Some Microsoft Word users will choose to highlight parts of a document to draw attention to it. This is helpful if edits need to be made to a section of a document while you are collaborating on edits with another person. But you may find that the highlighting color is still in the document after you have made the changes, so you are looking for a way to remove it....

But if you have a small child, or live with someone that has access to your phone and might not use a lot of discretion when it comes to making purchases on your device, then requiring a password authentication before any purchases can save you from some unexpected purchases. Our tutorial below will show you where to find and enable this setting. How to Prevent Unauthorized Purchases in the Google Play Store in Android Marshmallow The steps in this guide were performed on an Samsung Galaxy On5 using the Android Marshmallow operating system....

Fortunately your Netgear N600 router has a feature that lets you reserve an IP address for a device so that the DHCP feature on the router will assign that same IP address to the device. The device is identified via its MAC address, but you will be able to select it from a list of devices attached to your network, which will also list the device by its device name....

Your iPad actually has an entire menu devoted to different types of resets, and one of the options is to reset all of the settings on the device. This will restore device settings to the default options that would be found on a new iPad, but it will leave the apps and media that have been installed on the device. Our guide below will show you how to do this....

You may already be familiar with the handles that appear around an Excel image, which you can click to activate, then drag to resize the picture. Handles on the side and top will stretch or shrink the image, while the corner handles will resize while maintaining proportions. Those handles are identified below. But what if you need a picture in your spreadsheet to be an exact size? Fortunately there is a way to do that in Excel, too, which we will outline below....

There are a lot of things that you can do on your iPhone when you do things like swipe or use a long press. Our tutorial below will show you how to save a picture from a Web page on your iPhone 5 so that it will be in your Photos app and you can do the same things with that image that you would do with pictures that you take yourself with the Camera app....

Whether you are trying to share a picture with someone via text message or iMessage, you might be looking for a way to use less data when you are performing this type of sharing, as sending all of those images over a cellular network can add up quickly. One new feature of iOS 10 is hidden away at the bottom of the Messages menu. This setting, called “Low Quality Image Mode”, provides a way for you to reduce data usage when you send pictures to your iMessage contacts....

No matter what you use Microsoft Excel for, there’s a strong possibility that you will need to print something from it at some point. This is often a tricky proposition, however, as the default spreadsheet settings in Excel typically won’t result in a great printed document. This is especially true for multi-page documents. One way that you can simplify these printed spreadsheets, however, is by configuring the spreadsheet to print a specific column on every page....

Change the Default Font in Word 2010 The steps in the tutorial below are going to change the default font for every future document that you create in Word 2010. Old documents that you previously created, or which were created by someone else, will use still use the font with which they were created. With that in mind, follow the steps below to set up your default Word 2010 font....

if you are accustomed to unzipping these types of files after you download them, then you might be confused why they are already opened or unzipped on your Mac. This is because there is a Safari setting that causes the browser to unzip files automatically. If you don’t like this behavior then you can follow our tutorial below and find out how to make your Mac stop unzipping files automatically....

Additionally you may find that your phone is prioritizing LTE connections over 3G connections, even if the LTE connection is weak. Fortunately you have control over the types of networks to which you are connecting, so you can elect to stop connecting to LTE networks on your Marshmallow phone and instead force it to connect to 3G or 2G networks instead. How to Only Connect to 3G and 2G Networks in Android Marshmallow The steps in this article were performed on a Samsung Galaxy On5, in the Android Marshmallow operating system....

How to Stop the iPhone from Answering with Speakerphone Automatically Our guide continues below with additional information on how to stop when an iPhone answers on speaker by default, including pictures of these steps. If your clock is blue on your iPhone and you aren’t sure why, then you can read this article to find out why it’s happening and how you can fix it. Answering with the speakerphone option on your iPhone is convenient if most of your phone calls are done in private, or at a location where you need to have your hands free....

Luckily this feature is one that you can turn off if you do not want to use it. Our guide below will point you in the direction of this setting so that you can switch it off. If you are a Google user then find out how to access Google’s calendar on iPhone without the use of the default iPhone Calendar alternative from Apple. Turn off the “Events Found in Mail” Feature on the iPhone Calendar The steps in this article were performed on an iPhone 6 Plus, in iOS 9....