Posts

If you have a project that you need to submit and you want to show the formula rather than the result, then there is a way that you can elect to display the formula rather than the result, then print that displayed formula. How to Show and Print Formulas in an Excel Spreadsheet The steps in this article were performed in Microsoft Excel 2013. This guide assumes that you have a spreadsheet that contains at least one formula, and that you want to print that spreadsheet with the formula displayed, rather than the result of that formula....

Using the strikethrough effect in documents is helpful for letting a reader know that the text has been removed, while still leaving it there as a reference in case it is needed later. This formatting option is available in Microsoft Excel and is used occasionally for a number of reasons. If you are editing a document in Excel 2013 and encounter cells that contain text with the strikethrough effect, then you might be trying to figure out how to get rid of it....

Our guide below will show you where to find this setting so that you can specify your work schedule and make using your calendar a little easier. This is especially helpful if you have a schedule that varies a lot, or if you rely heavily on your calendar to schedule events for your job. How to Specify Which Hours are Work Hours in Microsoft Outlook 2013 The steps in this article were performed in the 2013 version of the Microsoft Outlook program....

But some Word 2013 users need to see those formatting marks all the time, so they may be looking for a way to show them by default. Our guide below will direct you to the menu where the default formatting display options are located. Always Show Formatting Marks in Word 2013 The steps below will configure your Microsoft Word 2013 installation to always show all formatting marks in your documents....

You will still be able to access the Internet if you are connected to a Wi-Fi network, but you will not be able to do anything that requires Internet access when connected to a cellular network. This includes downloading email, browsing Facebook, visiting websites in Safari, or streaming video and music. Disable Cellular Data Usage in iOS 9 Device used: iPhone 6 Plus Software version: iOS 9.0.2 The steps in this guide will result in an iPhone that cannot use any data when you are connected to a cellular data network....

This often involves downloading data from the Internet, so there’s a setting on the watch that can update your apps in the background so that they are always showing you current data. If you are concerned about this wasting battery life, our tutorial below will show you how to shut off the Background App Refresh setting on your Apple Watch. How to Stop the Apple Watch from Updating Apps in the Background Our guide continues below with additional information on how to turn off Background App Refresh on an Apple Watch, including pictures of these steps....

When you switch between different menus and screens in the Spotify app on your iPhone, you often see pop-up notifications in the app. These notifications can let you know about new content in Spotify, new songs or albums from your favorite artists, as well as Spotify news. But if you have all of these in-app notifications enabled in Spotify, then they can feel a little excessive. Luckily it’s possible to turn off the Spotify in-app notifications on your iPhone so that you can use the app without needing to constantly close out of the notifications that appear....

Quicktype can be removed from the iPhone keyboard by changing a setting on the Keyboard menu. Our guide below will show you where to find this setting so that you can disable it. We will also show you two other ways that you can manage the gray word suggestion bar directly from the keyboard, in case you decide that the Quicktype bar’s presence is something that might fluctuate based on your needs or preferences....

While some people prefer to have their emails sorted like this, your preference might be to list all of the emails individually. Fortunately this is something that you can accomplish by turning off the “group by conversation” option in Outlook.com. How to Stop Grouping by Conversation in Outlook.com 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 Edge....

If you find that your iPhone isn’t vibrating when it’s on silent, then this can make that problem even worse. Fortunately this behavior can be fixed by adjusting a setting on your iPhone that will cause it to vibrate when you get a call. Would you like to set up your iPhone alarm so that it only vibrates? Find out how to turn off the sound for an iPhone alarm and make that happen....

Unfortunately deleting an app will also delete the data associated with it, which can be unfortunate if that data included something important and you may decide to reinstall the app in the future. One way that you can manage this situation, however, is by choosing to offload the app instead. This is an option on the iPhone where you delete the app, but keep its documents and data. This won’t save you as much space on your iPhone, but it will let you keep information that you might want later while deleting the app itself, which can usually be installed again in the future....

Apple has developed the amazing Find My app that allows you to easily locate your missing Apple devices like iPhone, iPad, iPod touch, and even Mac computers. Plus, you can protect your personal information and remotely erase the content from your phone, tablet, or computer in case you fail to retrieve your lost devices. So, let’s find out how to add a device to Find My iPhone so that you can retrieve your precious device and keep yourself always connected to your friends and family....

One Apple Watch item that you will likely change is the watch face that you see when the device is turned on. This can be switched between several faces that are active by default, but there are actually many more faces that you can add to the device. Our tutorial below will show you how to add a new face from the options available in the Watch app on your iPhone....

But if you like to manually sort and organize your download files, either by saving them to different locations or giving them different names, then you might prefer to set that information whenever you download a file. Our tutorial below will show you a setting in Chrome that you can change so that the browser always prompts you to choose a location for the file, while also giving the opportunity to change the file name....

Fortunately you are able to rename a spreadsheet in Microsoft Excel Online to make it simpler to find what you are looking for. Our tutorial below will show you where you can make this file name change and improve your Excel Online productivity by saving your files with more descriptive names. How to Rename an Excel Online Document The steps in this article were performed in the desktop version of Google Chrome, but also work in other desktop Web browsers like Microsoft Edge and Firefox....

You will be able to save the converted file to one of several different locations on your iPhone.The converted file will first be saved to your Google Drive before you can download it.If you don’t wish to save a copy of the file to Google Drive you can choose the “Share & export” option, then the “Send a copy” option instead. The iPhone app versions of Google Docs, Google Sheets, and Google Slides offer a lot of the functionality that is found in the desktop version of the apps....

But scrolling through the faces on your watch to find the one that you want can be annoying if you have a lot of different watch faces, especially if some of them are ones that you know you will never use. Fortunately you are able to delete watch faces from the device so that you are left with only the ones that you want to use. How to Delete a Watch Face Through the Watch App on an iPhone The steps in this article were performed in the Watch app on an iPhone 7 Plus in iOS 10....

Fortunately this isn’t something that you need to do manually. Word 2013 lets you delete all of the information from your document header in one swift act. Our tutorial below will show you how to complete this process and restore the header to its default, empty state. How to Delete a Header in Word 2013 The steps in this article assume that your document currently has information in its header, and that you want to delete all of that information....

There are a number of different Google services where you might see a profile picture that you had set in the past. Depending on what you chose for that picture, there may come a time that you want to switch to a different picture, or even remove the picture completely. Luckily it’s possible to delete your Google Profile picture and stop it from appearing in locations where others can see it....

Numerical Battery Percentage on the iPad 2 This is really a case of personal preference, but I always prefer to have the most precise estimate of my remaining battery. The battery icon can be helpful if you just need a vague idea as to the amount of use that you have before you need to connect to a power source, but sometimes you need to know more precisely how much charge remains....