A spreadsheet with a lot of data can easily become unruly. While you may have previously experimented with hiding and unhiding rows and columns, but that can be tedious when you need to constantly change the viewability of rows or columns. Luckily there is an option in Microsoft Excel that lets you group a set of rows. This adds an extra section of controls to the left of the spreadsheet that you can use to quickly hide or show a selection of rows....

But if you’ve found the Page Setup menu in Google Slides, you may have discovered that there isn’t a default option that lets you switch to the portrait orientation. Fortunately you do have the option to create vertical slides, but you need to use a custom setting. Our guide below will show you how to make Google Slides vertical. How to Switch to Vertical Slides in Google Slides The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop Web browsers like Firefox or Safari....

Our tutorial below will show you how to find a setting that tells Outlook to send emails immediately if you are online. Then you won’t need to worry about going into your Outbox after every written email to manually send it to its recipients. How to Send Messages Immediately in Outlook 2013 The steps in this article were performed in Microsoft Outlook 2013, but will work in some earlier versions of the program as well....

But there are some other actions on your cell phone that can use a lot of data, such as downloading your emails. If you have checked your cellular data usage on the Settings > Cellular menu and found that one of the biggest users of cellular data is the Mail app, then you might be interested in stopping that. Our tutorial below will show you how to turn off this setting and block the Mail app from using any data when you aren’t connected to a Wi-Fi network....

Windows 10 has combined these two options and now offers users a choice between the two. If your Windows 10 Start menu is currently expanding to take up the entire screen, then our guide below will show you how to stop that behavior. How to Open the Windows 10 Start Menu at the Bottom-Left Corner The steps in this article were performed on a Windows 10 laptop. This guide assumes that your Start menu currently expands to take up the entire screen when you open it, and that you would like to restrict it to a smaller space....

Since many types of images will require text, you may have already found that Photoshop has a text tool that you can use to add text. But when you want to underline text in Photoshop, you might be struggling to find that option since it’s not in as obvious a location as you might expect. Formatting the text that you use in a Photoshop image allows you to make your text appear exactly how you would like it....

Much of this data usage is due to the various services that your iPhone is utilizing. Two of these services include the time and your location. Depending on the assorted settings that you have enabled, s well as the apps you have installed, the data usage by time and location services can be quite high. Our guide below will show you how to see the amount of data being used by these services on your iPhone....

There are two different options for receiving files for AirDrop. You can receive files from Everyone, or you can receive files only from people that you have already set up as a contact. If you are concerned about a random stranger sending you files via AirDrop, then the steps below will let you change your settings so that you only get files from people you know. How to Set AirDrop So That Only Contacts Can Send You Things The steps in this article were performed on an iPhone SE in iOS 10....

If you were to compare the firestick to another device, it would be comparable to something like an Apple TV or a Roku. This is a class of product called a set-top streaming device, and is specifically meant as something that can stream video from the Internet to your TV. You can also read our guide on 10 things to know about the Firestick, including answers to questions like how much data does Firestick use?...

But if you try to do this, you might find that the effect doesn’t seem to last, and you are only able to type one capital letter before the keyboard reverts to typing in lower case. Fortunately this is not an issue with your iPhone, but rather a setting that you need to enable by following our guide below. How to Enable Caps Lock in iOS 9 Device used: iPhone 6 Plus Software version: iOS 9....

Our guide below will show you how to add a background picture to your document via the custom watermark tool. We will also show you a couple of different formatting options that you can use which will help you to achieve the desired effect from your background image. How to Set a Picture in the Background of a Word 2013 Document This article is going to show you how to take a picture that you have on your computer and insert it into the background of your document in Word 2013....

While you may be able to figure out the current time in your head, there may be situations where you don’t remember if that city is a two or three hour time difference. This can be even more confusing if a city doesn’t observe daylight savings time, and is sometimes more or fewer hours difference from your location. Our tutorial below will show you how to add a city to the iPhone’s Clock app so that you have a quick reference to let you know the current time in a particular city....

Fortunately you can cancel a Tidal subscription directly from your iPhone, which makes the process much simpler than some other subscriptions that you may need to cancel. Our guide below will show you where to find the Tidal subscription on your device so that you can disable the auto-renewal and stop getting charged. How to Cancel Tidal in iOS 10 The steps in this guide were performed on an iPhone 7 Plus, in iOS 10....

Our guide below will show you how to modify a worksheet tab in Google Sheets by applying a color to it. This color appears as a horizontal bar at the bottom of the tab. You can select from a large number of colors, so you can really do a lot with this to customize the appearance of the file. How to Add Color to a Worksheet Tab in Google Sheets Our article continues below with additional information on changing a sheet tab color in Google Sheets, including pictures of these steps....

If you would prefer to simply revert to the default formatting for those cells so that you can start fresh, then there is a way to do so. Our guide below will show you how to select a group of cells in the spreadsheet and remove the formatting from them. How to Remove Formatting from Cells in Excel 2013 The steps in this article were performed in Excel 2013, but will also work in Excel 2010 and Excel 2016....

There are two different ways that you can delete an app in iOS 9, although one of the methods is much quicker than the other. Our guide below will show you both of the ways that an app can be deleted from your iPhone. Deleting an App on an iPhone 6 Device used: iPhone 6 Plus Software version: iOS 9.0.2 The steps performed in the article below will work for any iPhone model that is running iOS 7 or higher....

But while that firewall is good at keeping out malicious connections, it also does a good job at keeping out connections that actually aren’t harmful, but may appear to be unusual or atypical. If you find yourself in a situation where you have a program or hardware that can’t communicate with your MacBook because of the firewall, then continue below to find out how to disable the firewall on a Mac....

Microsoft Outlook signatures are a simple way to ensure that the contact information that you wish to share is included in every email that you send. But that contact information can change periodically, or you may discover that a previously-unseen typo exists in that signature. Fortunately signatures can be edited in Outlook 2013, and the method for doing so is similar to what you first did to create the signature....

Unfortunately, this attention to security can make it difficult for you to run macros in the workbooks where you actually need them, so you might be wondering if there is a way to just enable macros all the time in Excel 2013 so that you can work more efficiently. This is something that’s possible, although turning on all macros all the time can be a pretty significant security risk. Our tutorial below will show you how to add the Developer tab in Excel 2013 so that you can see the option for macros in your ribbon....

But you might find that you don’t need that information, and that its presence is either cluttering your folder display, or it’s adding some unnecessary confusion. Luckily this is a setting in Windows Explorer, and you can disable it if you would prefer to simply view the file name without its file type extension. Our tutorial below will show you where to find this setting so that you can hide the file type at the end of a file name in Windows 7....