Posts

But you may notice that the cells in your Excel worksheet are displaying the formulas themselves instead of the results, which can be much less useful if you are more interested in the results of the formula calculation. Fortunately this is only occurring because a certain setting is enabled for that worksheet, and you can follow our guide below to turn it off. Change Cell Display from Formulas to Answers in Excel 2013 The steps in this guide will change the settings for a single worksheet that you are viewing in Microsoft Excel 2013 so that you see the result of a formula instead of the formula itself....

Fortunately it is possible to hide the toolbar on the Mac. There are a couple of ways to do it. One involves a keyboard shortcut that can be used to hide or display the toolbar, while the other will change a setting in the System Preferences menu that controls whether or not the dock is visible. How to Hide the Dock on a Mac The steps in this article were performed on a MacBook Air running the macOS High Sierra operating system....

But you have probably developed a number of contacts that are now stored in your Hotmail account, and the prospect of having to manually enter those contacts when you switch over to the email address that you have loaded into Outlook 2010 might seem like something you do not want to do. Fortunately Hotmail features a utility that allows you to export the Hotmail contacts into a format that is compatible with Microsoft Outlook 2010....

What is an ESN? An ESN is a serial number attached to every phone on a CDMA network like Sprint or Verizon. Instead of using a SIM card like GSM networks do (At&t or T-Mobile,) a CDMA ESN is a unique identifier that allows the phone to be validated and connect to the cell tower. (To thwart confusion: if you have a SIM card, then you probably don’t have an ESN attached to your phone....

Unfortunately, some of Excel’s default settings can have text aligned on corresponding sides of cells (for example, a left cell that is right-justified and a right cell that is left-justified). You can justify text in Excel by selecting the cells to justify, clicking the Home tab, then clicking the appropriate horizontal or vertical justification button. It can become difficult to discern where information from one cell ends and information from another cell begins, so you will need to justify your data within its cell....

Applying the Bounce Animation in Powerpoint 2010 Powerpoint 2010 has a surprising number of ways that you can change your image. You can actually perform some edits to your image from directly within Powerpoint by using the Picture Tools – Format menu but, if you do not want to actually change the appearance of the image, then using a bounce animation is a good way to make an image stand out....

With different styles and customization options, you can create a useful pie chart in Excel and an attractive one simultaneously. How to Create a Pie Chart in Excel While some of the features for customizing a pie chart differ slightly, the process for creating one is the same in Excel on Windows, Mac, and the web. You’ll see that pie chart pop right into your spreadsheet, ready for you to customize!...

It’s always frustrating when you’re typing a large passage in a document without looking at the screen, only to finally look up and see that you accidentally had the Caps Lock key pressed down. This typically leads you to retype the passage in the correct case, then delete the original. This process is tedious and frustrating, and it’s probably something that you wish you could avoid. But it’s equally frustrating to need the text in uppercase and type it in lowercase....

Microsoft Excel has a variety of proper functions that not only let you perform mathematical operations, but also change formatting. in the case of text, you are able to have text converted to upper case letters or lower case letters with the assistance of a formula. Our tutorial below will show you how to make all letters capital in Excel with the help of a formula that takes the text case from the original column data and then will change case for the data in a new column....

The playlist feature on your iPhone allows you to group songs into a list that you curate, then you can choose to play that playlist. Your iPhone will then play those songs in order, or shuffle through them, based on your current settings. Our tutorial below will show you how to create a playlist on your iPhone 7. Creating a New Playlist on an iPhone 7 The steps in this article were performed on an iPhone 7 Plus, in iOS 10....

Since so much of our communication and information exists on our phones these days, that can be a problem. Luckily you can make the items on your Homer screen bigger so that they are easier to view. How to Make Your App Icons Bigger on an iPhone 7 Our article continues below with additional information on making app icons bigger on an iPhone 7, including pictures of these steps. While iPhone screens have been getting larger and clearer, as well as more responsive, you may find that the default settings are uncomfortable to look at, or that it’s difficult to touch the right thing on the screen....

While you may have discovered that you can sort playlists alphabetically, you may be looking for a way to put your playlists in a custom order. Our tutorial below will show you how to manually resort your playlist order using the desktop Spotify app for Windows. How to Put Spotify Playlists in a Custom Order with the Desktop App The steps in this article were performed in Windows 10, using the desktop version of the Spotify app....

You could spend money on a commercial app like Mirroring360 from Splashtop or Reflector from the developers of AirParrot to do the job. Or, if you don’t find yourself in this scenario often, it can be done with the free and straightforward LonelyScreen utility. We already showed you how to mirror your Android device to Windows 10 using the Connect app. However, the Connect app in Windows 10 doesn’t support iOS, so you will have to look at another option....

This can happen if you use a different Web browser, such as Google Chrome. Our tutorial below will show you how to find Chrome’s download location and change its setting so that you can find these files a bit more easily in the future. How to Switch the Google Chrome Download Folder Location Our guide continues below with additional information about the Chrome Downloads folder, including pictures of these steps....

Pause Windows 11 Updates To begin, click the Start button and then click Settings from the menu. Alternately, you can use the keyboard shortcut Windows key + I to open Settings directly. When the Settings app opens, click on Windows Update at the bottom of the list on the left. On the following “Windows Update” page, click the “Pause” dropdown and there you can choose to pause updates for up to five weeks....

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

Our guide below will show you how to take a screenshot on a MacBook Air that will then be saved as a .png image file on your desktop. You can then share, edit, or otherwise handle that print screen image in the same way that you would any other picture file on your computer. Running out of space? Find out how to delete junk files from your Mac and free up some of your storage....

Everyone has different printing needs, and those needs are amplified when you are working with a program as flexible as Microsoft Word 2010. You can print on a variety of different types of paper, you can format your documents to an impressive degree, and you can even do some light picture editing. Fortunately, you have a lot of control over how your documents print as well, and you can even customize the number of pages of your document that print on a single sheet of paper....

But there are some other tasks that are made simple with the help of the watch, such as snoozing or dismissing alarms and timers. Since you are only pressing a button to mange this interaction, it’s something that the watch can easily handle. Fortunately there is a setting in the Watch app on your iPhone that you can enable which will let you perform this task directly on the watch....

Fortunately you can add a border to a text selection with just a few short clicks, so check out our guide below to learn how. Add a Border to a Selection in Word 2013 The tutorial below will assume that you already have a document with text, and that you simply want to add the border to existing text. Additionally, we will be putting a border around a paragraph, but you can select any amount of text to which you want to add a border....