Posts

Microsoft Excel contains a vast amount of features and settings, and the number of formulas that you can use to compare data can be somewhat overwhelming. Our article below discusses the autocomplete setting for formulas and how you can turn it on or off as needed. How to Toggle Excel’s Formula AutoComplete Setting On or Off You can continue reading below for additional information on how to enable formula autocomplete in Excel, including pictures of these steps....

Spotify has implemented this feature as a microphone icon that appears as an overlay in the app, and you can tap the icon to perform a voice search. However, Spotify will need access to your iPhone’s microphone for this to work, which means you need to grant that permission. If you have already given permission but want to revoke it, or if you would like to enable the permission to use voice search in Spotify, then our guide below will direct you to the menu where you can grant that permission....

Unfortunately your iPhone needs to be turned on for this to work as intended, which can be an issue if your iPhone happens to run out of battery life while it is missing. One way to improve this situation is to enable a setting that will send your iPhone’s location to Apple when the battery reaches a critical level. Our guide below will show you how to find and enable that setting....

How to Make a Cell Bigger in Microsoft Excel Our guide continues below with additional information on how to enlarge cells in Excel, including a variety of other ways to accomplish this. While learning how to autofit all columns in Excel is a nice and simple method for resizing cells according to your data, it may not always be the solution. Making cells bigger in Excel 2010 is something that can be done using a couple of different methods....

But if you can’t find the extension or you’re having trouble installing it, you can check out our tutorial below for some additional information. How to Enable the Google PageSpeed Extension Our guide continues below with more information on using Chrome PageSpeed including pictures of these steps. An important aspect of how Google rates your website is the speed at which it loads. If your site loads faster, then Google will determine that it provides a better user experience and the page will be given a higher ranking in Google’s search engine result pages (SERPs)....

Our guide below will show you two different ways to locate your Watch’s serial number. The first method is done through the Watch app on an iPhone, and the second method is done directly on the watch, without using the iPhone. Where is My Apple Watch Serial Number? The steps in the first section below are going to show you how to find the serial number for your Apple Watch through the Watch app on your iPhone....

The default setting in Excel 2013 is for your computer to use it’s graphics hardware to accelerate the program, but this can result in choppy cursor movement on your screen. If this is a problem that you are having with Excel 2013, then follow the steps in our guide below to disable the option and improve performance in the program. Why is My Mouse Moving Slow in Excel 2013? The steps in this article are going to turn off the animation features in Excel 2013 by disabling a feature called Hardware graphics acceleration....

I know that I am constantly receiving emails where I need to do something, but don’t have the time to do it right away. Outlook has a useful feature where you can flag emails for follow up at a later time when you may be able to manage it. Our tutorial below will show you how to flag Outlook emails for follow up. How to Mark an Email for Follow-Up in Microsoft Outlook Our guide continues below with additional information on flagging emails in Outlook, including pictures of these steps....

Are you looking for a way to close an app that is still running in the background? Read our article on closing open apps to learn how. Force an iPhone 5 App to Close One may wonder why the method described below is something that is not immediately obvious, and the answer lies in the fact that it is simply not something that you should have to do on a regular basis....

If you have connected your flash drive to one of these devices and discovered that it cannot be read, then you will need to format the flash drive to the correct format. The tutorial in this article will show you how to format a flash drive so that it is in the FAT32 format. Formatting a USB Flash Drive to FAT32 Note that formatting a flash drive is going to delete all of the data from the flash drive....

How to Make Your Alarm a Song on an iPhone The steps in this article will show you how to edit an alarm so that it uses a song as the alarm sound. This assumes that you have already set up an alarm. If you have not yet set up an alarm, you can read this article to learn how. Note that the song that you use as your alarm sound will need to be one that is currently available in the Music app on your iPhone....

You can perform a similar action in the Windows version of Excel. This Excel repeat rows at top tutorial will show you how. How to Repeat the Top Row on Every Page in Excel 2011 This tutorial is going to focus on repeating the top row on every page, but you can also use these steps to repeat any row that you want. Step 1: Open the spreadsheet in Excel 2011 on which you want to have the top row printed on every page....

Adding borders to your cells gives you more control over the appearance of your cell boundaries. You can apply borders on any of your cell sides, and you can choose the color for the borders. But you might have a series of cells with borders where you would like the bottom border to be thicker than the rest of them. Fortunately you can make a thicker bottom border in Excel by using the steps outlined below....

Our tutorial below will show you how to take a picture that isn’t transparent, such as one in the .jpg file format, then edit that picture to make it transparent. You will have the ability to either make the entire image somewhat transparent, or you can delete part of the image so that the background only shows through at that spot on the image. You can check out our guide on how to make a transparent background in Photoshop for additional information on this topic....

Fortunately, you can convert an existing Word document to the PDF file type using just a few simple steps. How to Convert to PDF from Word 2010 Our how to make PDF in Word 2010 guide continues below with additional information, including pictures of these steps. That PDF that you create can then be uploaded to Google Drive. You can even use our convert PDF to Google Doc guide if you want to make edits to it....

But if you find that the icons in that taskbar are too large, then you might want to learn how to make the taskbar smaller in Windows 10. How to Show Smaller Taskbar Buttons in Windows 10 Our guide continues below with additional information on how to make the taskbar smaller in Windows 10, including pictures of these steps. The taskbar at the bottom of your screen in Windows 10 is a good place to put shortcuts to your most commonly-used programs....

Microsoft Word is an impressively versatile program, and one of the more common ways that I find myself using it is to print address labels. While the labels that I am printing in Word may not always necessarily be address labels, the method for creating them is identical. Return address labels can be a lifesaver when you need to do a mass mailing. However, if you have never done it before, or if it has been a long time, then setting them up correctly might be a bit of a challenge....

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

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