One way to resolve this issue is by freezing a row or two at the top of the sheet. This lets you scroll down while still keeping important data, such as your row headings, visible. But if you’re working on a sheet that was created by someone else and it has these frozen rows, then you may be looking for a way to unfreeze them. Our guide below will show you how....

Many other electronic devices include the ability to take screenshots, such as your computer. But your Apple Watch can also take screenshots if a particular setting is activated in the Watch app on your iPhone. But if you find that you are taking screenshots often when you don’t want to , then it might be time to disable that setting. Our tutorial below will show you where to find and change the screenshot setting for an Apple Watch....

You might already know how to format a single cell in Excel, but the same method that you used for that one cell can also be applied to multiple cells at once. This means that it’s a quick process to format a large quantity of cells, such as an entire row or column. Our guide below will show you how to switch the format for a whole column in Excel so that anything in that cell, or anything that you enter into it, will be in the chosen format....

As you become more comfortable working with tabbed browsing, you will find that you often open links on one page in a new tab. By default Internet Explorer will remain on the currently-active tab, but you can adjust this behavior so that it switches to the new tab instead. Our tutorial below will show you where to find and change this setting if you would prefer to always switch to new tabs when they are created....

Your Windows 10 computer can show you a lot of notifications. Whether it’s emails, program updates, information about Windows 10, or something else, those notification boxes at the bottom-right of the screen can be quite frequent. Unfortunately they can be pretty distracting at times, so you may be looking for a way to turn them off. But if you don’t want to turn them off permanently, but rather for a period of time while you are trying to finish a project, then you should check out the Focus Assist feature in Windows 10....

You can also use this same procedure to disable the keyboard sound on your iPad. If you don’t have an iPad, or are considering upgrading to a newer model, you should check here to look for the best current price. Disable Keyboard Sound When Typing on the iPhone 5 One of the most convenient elements of the iPhone 5 is how simple it is to configure your experience with the device....

But if you prefer to work with attachments in their native programs, where you have access to all of the features of the program, then this Preview mode can be more of a nuisance than a help. Fortunately it is a feature that you can turn off in Outlook 2013 by following the steps in our guide below. Stop Outlook 2013 from Previewing Attachment Files from Word, Excel, Powerpoint and More The steps below are specifically written for Microsoft Outlook 2013, but these steps are very similar for Microsoft Outlook 2010....

Whether those notifications involve sound or vibration, noticing them is a significant factor in their effectiveness. If you had previously turned on the notification option that caused your camera flash to light up, then you may have discovered that it wasn’t as helpful as you had hoped, or that it was distracting others. Our tutorial below will show you how to turn off flash notification on iPhone if you no longer wish to use this type of alert....

But regardless of your snooze preferences, you might find that you sometimes hit the snooze button when you meant to turn off the alarm, and the snoozed alarm going off again in a few minutes can be surprising. if you would prefer not to have the option to snooze your iPhone alarm, then you can elect to disable the snooze option for it. Our guide below will show you how....

But you may still wish to be notified about messages that come from specific people, which makes the VIP list helpful. It allows you to specify certain contacts for whom you would still like to receive Mail notifications. But if the lock screen notifications from even this small subset of contacts are too overwhelming, then the steps in our guide below will show you how to disable them. There are a lot of other notifications on your iPhone, even some concerning attached devices....

Turn Off Wi-Fi on the iPhone 5 in iOS 7 Note that after turning off Wi-Fi, any data you use will be on your cellular network. This will count against the monthly data allotment offered by your cellular plan, and could go quickly if you are doing something data-intensive, such as streaming a video from Netflix. Once you are aware of this fact, you can follow the steps below to learn how to disable Wi-Fi in iOS 7....

When I first got an Android phone, I thought the only safe way to remove the SD card was by first turning off the device. But that isn’t the case, as you can usually unplug it without problems. But, to be on the safe side, it’s a best practice to unmount an SD card before you remove it safely. This safe unmounting will not only prevent you from losing data but also lets you disconnect the SD card without physically removing it should you ever need that....

Friends One component of the Find My app for iPhone and iPad is the ability to track the location of others. Here’s how to add new friends, keep track of them, and more. Adding Friends You are now sharing your location with the contact, and they can offer to do the same on their end. Finding Friends You can find different information about your friend through the Find My app. On the friend’s card, you can find their current location (plus directions) and contact information....

Google Sheets has a number formatting option that lets you tell the spreadsheet that values in certain cells are currency. Those values will then be preceded by a dollar sign, and will all have a uniform number of decimal places, thereby making it much easier to read the data. Our guide below will show you how to select cells and apply currency formatting to those cells. See also How to merge cells in Google SheetsHow to wrap text in Google SheetsHow to alphabetize in Google SheetsHow to subtract in Google SheetsHow to change row height in Google Sheets...

Editor’s note: In October 2016, Windows announced the Windows 10 Creators Update slated for public released in March/April 2017. We’ve been testing out the new features that are now available for Windows Insiders. Be sure to subscribe to our newsletter so you can get a sneak preview of all the upcoming features in the Creators Update. How to Make a Wired Network a Metered Connection As we’ve covered earlier, there are ways to tame Windows 10’s heavy data usage....

Create Google Docs the Easy Way Instead of going into Google Drive and clicking through the process to create a new document, just type: doc.new into the browser’s address bar and hit Enter. You will be taken directly into Google Drive and be staring at a fresh new document. If you’re not logged into your account, you will be prompted to log in first. However, once you are logged in, you can simply type in the ....

What is Hide My Email? When you use your email online to make purchases, it’s possible that your email address is being sold to marketers, who then sell it to other marketers, and so forth. To combat these folks and scammers alike, “Hide My Email” lets you use temporary Apple email addresses. Messages sent to these addresses are automatically sent to your primary email address. There are two ways to use “Hide My Email....

There’s a faster way to search the contents of files on your hard drive using the command line. The find command searches for text strings in files and returns the lines of text from the files in which the text string was found. NOTE: The find command is not suitable for large files or large numbers of files. Today we’ll cover how to use the find command and we’ll provide some examples....

Microsoft Word has a little-known feature called the Spike, but instead of storing pieces of paper, you can store blocks of text. Unlike the Windows clipboard, these blocks of text stay on the Spike until you want to paste them to another location in the current document or into another new or existing Word document. The Windows clipboard only stores one copied item at a time unless you use a third-party tool to expand the clipboard’s capabilities....

What Do You Need? To use a supported trackpad or mouse, you must own an iPad Pro (all models), iPad Air 2 or later, iPad (5th generation) or later, or iPad mini 4 (or later). You must also have iPadOS 13.4 or later installed on your machine. The trackpad support works with the Apple Magic Mouse 2, Magic Trackpad, and many third-party mice that connect through Bluetooth. In May, Apple’s releasing a new Magic Keyboard for iPad Pro, which includes both a keyboard and a built-in trackpad....