You can help make it easier to read by using column and row headings, but endless cells of data all containing similar values are just difficult to read. And if you need to print that spreadsheet for someone to view on paper it can be even worse, especially if the spreadsheet is more than one page in length. The default setting in Excel 2013 will only display your column headings on the first page, and anyone reading a printed version of the spreadsheet would need to manually match up each column with that column heading....

While your initial reason for purchasing a Nikon D3200 might have been for the excellent images that it can produce, you might need to know how to use the Nikon D3200 video mode if you find yourself in a situation where a video is better than a picture. The Nikon D3200 is a popular DSLR camera. It is affordable (as far as this type of camera goes) and is user-friendly for people that are just becoming familiar with this type of device (myself included!...

Our guide below will show you how to enable Low Power Mode, as well as two other settings that you can consider disabling to try and improve the life of your battery. Extend Battery Life in iOS 9 Device used: iPhone 6 Plus Software version: iOS 9.1 The steps below will show you three settings you can use to make your iPhone battery last longer on a single charge. 1st Option – Enable Low Power Mode This option was first introduced in iOS 9, and will simultaneously reduce or turn off some of the utilities on your iPhone that are consuming the most power....

While the page break function in Word Online works fine when you don’t have specific elements that you need to appear on specific pages, you may find that certain documents require the addition of manual page breaks to achieve a desired format. But manual page breaks can be difficult to work with if you are still editing or adding information to your document, so you may find that a page break that was previously in the right place is now incorrect....

Fortunately borders can be removed in Google Sheets, in a manner similar to how they were originally added. Our tutorial below will show you how to get rid of borders on a selection in Google Sheets and restore the selection to its original border-less state. How Can I Delete Cell Borders in Google Sheets? The steps in this guide were performed in the desktop version of Google Chrome. You can also complete these steps in other desktop browsers like Edge or Firefox....

Fortunately this is a formatting option that can be switched in Microsoft Excel 2010 with only a few steps, and you can choose from one of many other formatting options based upon your needs for the situation. Our tutorial below will show you how to select and modify cells that currently include percentage formatting. How to Switch from Percentage Formatting in Excel 2010 The steps in this article were written using Microsoft Excel 2010....

Fortunately your playlist names aren’t etched in stone, so you have the option of renaming them if you want to use a more helpful method for naming them. Our tutorial below will show you how to rename a playlist in the Spotify iPhone app. How to Change the Name of a Spotify Playlist on an iPhone 7 The steps in this article were performed on an iPhone 7 Plus in iOS 11....

Google Chrome is probably one of the most used applications on your computer if it’s your default browser, so you may find yourself troubleshooting it pretty heavily if you are having a problem. Our tutorial below will show you how to reset Google Chrome to default settings if nothing else has worked and you are ready to start fresh. How to Restore Chrome to Default Our guide continues below with additional information on how to reset Chrome to default settings, including pictures of these steps....

One way that you can fix this behavior, however, is to completely reset the keyboard dictionary on your iPhone. This will restore the dictionary to its factory defaults, allowing the device to “unlearn” any of the incorrect information that it now contains. If you need to reset more than just the dictionary, then our factory reset iPhone 11 guide can show you what to do. Resetting the iPhone Keyboard Dictionary in iOS 8 The steps in this article were written using an iPhone 6 Plus, in iOS 8....

How To Restore WhatsApp Messages On Android Phone? Google Drive backup remains one of the most reliable ways of restoring WhatsApp messages for Android users. However, in order to successfully retrieve a Google Drive backup, you will need to use the same phone number as well as the same Google account that you had used while creating the backup. Thus, you may want to save the latest backup before uninstalling app from your old phone too....

Fortunately it is possible for you to also search for cards that you don’t own if you are building a deck and either want to use wildcards to craft new cards, or if you simply want to see some more available options that fit certain search parameters. Our tutorial below will show you how to add a filter that lets you search for cards that aren’t already in your collection....

Do you want an easier way to access your Google Calendar? Then our add Google Calendar to home screen guide can show you how. How Do I Search My iPhone 5 Calendar I like to use my calendar because it doesn’t force me to remember all of my upcoming plans, which can easily be forgotten. But it also puts you in a kind of “set it and forget it’ frame of mind, where you enter an event then almost immediately forget about it....

How to Check a Cell’s Format in Excel 2013 Our guide continues below with additional information on how to see formatting in Excel, including pictures of these steps. Different types of cell formats will display your data differently in Excel 2013. Changing the format of a cell to best suit the data contained within it is a simple way to ensure that your data displays correctly. For example, a date that is formatted as a “Date” cell might display as “6/27/2016....

Unless you have recently been trying to figure out this information, it’s likely that you might not even be able to make an accurate guess. Aside from simple curiosity, it can be a good idea to get a rough idea of this information so that you know when it’s time to make a backup or delete some apps that you haven’t used in a while. Our guide below will show you where to go on your iPhone to view counts of the various types of files on the device....

Fortunately, there is a tool in the application that lets you do just that. Our guide below will walk you through making a selection, then how to select all matching text in Google Docs. How to Select All of One Word in Google Docs Our guide continues below with more information on how to select all matching text in Google Docs, including pictures of these steps. Do you use Microsoft Word, too?...

Perhaps the item that you received was a picture, which may have left you wondering how to send videos on iPhone messages. Luckily this is something that you can do, too, and it’s very similar to the process of sharing pictures in messages. How to Send Videos on iPhone Our guide continues below with additional information on how to send videos from an iPhone, including pictures of these steps. Sharing pictures and videos is a common aspect of social media, and your iPhone is a great way to create and store your pictures and videos....

Our guide below will show you how to accomplish this by changing a setting on the Apple Watch itself. You will be able to specify a number of minutes by which you want to set your watch time ahead. I will be using 5 minutes in this example, but you can choose any number of minutes between 1 and 59. How to Set the Time Forward on an Apple Watch The steps below were performed on an Apple Watch 2, in Watch OS 3....

Alphabetically Sort a List in Word 2013 For the purposes of this tutorial we are just going to be sorting a short list of names that are each on their own line. The default sorting options will work perfectly for this purpose, and will result in a list that has the first alphabetic name being switched to the first line, and each additional item sorted correctly in its place. But if you have different needs you can adjust the options on the Sort window to meet them....

The iPhone provides you with a couple of different options for sorting your contacts, and one of those options will adjust the sorting to alphabetize your contacts by first name rather than last name. if you are in the habit of using the last name field as a way to add additional information about a person, or if you have trouble remembering people’s last names, then being able to find someone by the first name instead can be very useful....

Properly formatted data can make it much easier to complete tasks in Excel 2013, but it is rare that the data we have is ideally suited for the work that we need to do. This is common when working with names in Excel, as many companies and individuals will store full names in one cell in their spreadsheets, either naturally, or with the aid of the concatenate Excel formula. Unfortunately this can be problematic when you need a separate cell for the first name and a separate cell for the last name, and the prospect of manually splitting those names is not something that many people would look forward to....