Fortunately it’s possible for you to do this by pressing the Shift key twice. This will put a horizontal line under the Shift key to let you know that the keyboard is in “Caps Lock” mode. However, this setting can possibly be turned off, so follow the steps in the tutorial below to find the Caps Lock setting for your iPhone keyboard so that you can enable it and stop using this handy little feature....

The Formula Bar is not completely necessary when using Excel 2013, and it can be hidden by users that wish to minimize the amount of clutter in the Excel window. So if you are looking for the Formula Bar but do not see it on the screen, then you can follow the steps below to display it. Display a Hidden Formula Bar in Excel 2013 The steps below will assume that your Formula Bar is currently hidden from view, and that you wish to re-enable it so that you can use it to enter formulas....

Some of these options can serve an important organizational function as well, such as the fill color tool in the application. Our tutorial below will show you to apply a fill color to a cell in Excel so that you can start to color code similar data for your readers. How to Change a Cell’s Background Color in Excel Our guide continues below with additional information on changing the background color Excel setting, including pictures of these steps....

Fortunately you can manually change a cell’s formatting to whatever you would like, and one of the options is to format a cell for a number. Our guide below will show you two different methods for switching a cell to the Number format. Change a Cell Format to “Number” in Excel 2013 The steps in this article will show you how to select a cell, or cells, and change the formatting to the “Number” option....

Fortunately all of the contact information that has been saved for a contact is editable, including that contact’s phone number. Our guide below will show you how to edit a contact’s phone number on your iPhone in iOS 9 so that any time you call them, or they call you, the contact labeling will be applied to their new number. Change the Phone Number for a Contact on an iPhone 6 Device used: iPhone 6 Plus Software version: iOS 9....

In Microsoft Excel the orientation setting is fairly accessible, so it can be confusing in Google Sheets when you need to switch the orientation of your printed spreadsheet. Fortunately this is something that you can do, although the method for doing so is actually found during the printing process. Our tutorial below will show you how to switch between portrait and landscape in Google Sheets. How to Change Google Sheets Landscape to Portrait Our article continues below with additional information on changing orientation in Google Sheets, including pictures of these steps....

If you have ever tried to make your fractions or symbols look better on your slides, then you may have looked into ways to add those symbols in a way that makes them look better. Some of these characters or strings, however, are going to convert automatically when you type them into one of your slides. While this may the desired outcome in certain situations, it can also be unwanted....

Luckily this is a setting in the application that you can control, so it is possible to disable the automatic hyperlink feature in Excel 2013. Our tutorial below will direct you to the menu where this option is located so that you can turn it off. How to Stop Excel 2013 from Automatically Turning Web or File Addresses Into Hyperlinks The steps in this article are going to change an AutoCorrect setting in Microsoft Excel that causes the program to automatically format network paths or URLs as hyperlinks....

Our guide below will show you where to find and enable the dictation feature so that you can start using it on your iPhone, too. How to Enable Dictation in iOS 10.3.3 The steps in this article were performed on an iPhone 7 Plus in iOS 10.3.3. This guide assumes that dictation is currently disabled on your device, and that you would like to turn it on. Step 1: Open the Settings menu....

But rather than create two separate presentation files, you might find it easier to simply hide and unhide the individual slides in the slideshow as you need them. This lets you keep your work available in case you need it, but also lets you omit information that isn’t relevant to particular groups. Our tutorial below will show you how to hide slides in Powerpoint 2013. Check out our tutorial on how to hide a slide in Google Slides if you would like to hide slides in that application as well....

One such setting involves configuring a row so that it is always visible. This makes it much easier to identify cell data. Our tutorial below will show you how to do this by learning how to lock a row in Google Sheets. How to Freeze a Row in Google Sheets Our article continues below with additional information on how to lock a row in Google Sheets, including pictures of these steps....

Sometimes things go wrong with Pokemon Go and you need to take some steps ot try and resolve those issues. Or perhaps you share a device with a child or family member and you would like to be able to sign out of your account and sign into theirs. Regardless of the reason, you may need to know how to sign out of a Pokemon Go account. Our guide below will show you how to log out of Pokemon Go....

If you are creating a document that requires a smaller margin than what you are currently using, then it’s possible that change the margin on the document to meet the specifications that you need. Our tutorial below will show you where to find the Margins setting so that you can choose from one of the default options, or specify custom margins. How to Decrease the Size of the Margins in Word 2013 The steps in this article were performed in Microsoft Word 2013, but work in other versions of Word as well, such as 2007, 2010, and 2016....

But the most important part of the video may actually be the video itself, and you may find the audio to be distracting, unnecessary, or potentially harmful to your presentation. Fortunately you are able to mute the audio in the video, which is helpful if there are other sounds in the presentation that you do want. How to Turn Off Sound in a Google Slides Video Our article continues below with additional information on how to mute audio on YouTube videos in Google Slides, including pictures for these steps....

While the primary way that you share your pictures might be digitally, either by texting them or sending them through email, you can also print pictures from your iPhone 7. Our tutorial below will show you how to quickly print a picture from your iPhone 7’s Photos app to a Wi-Fi printer that is on the wireless network to which you are currently connected. iPhone 7 – How to Print a Picture The steps in this article were performed on an iPhone 7 Plus in iOS 12....

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....

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 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....

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....

But while this behavior is often welcome, there are situations where you would prefer to display the address without automatically turning it into a clickable link. Whether these reasons are merely aesthetic, or your school or organization discourages you from adding links to a document, you might be looking for a way to stop it from happening. Our guide below will show you how to stop Google Docs from automatically turning Web addresses into clickable links....