I use the freeze top row option a lot myself, especially when I’m working with a lot of data. While freezing the first row is useful when you have a header row that you want to keep visible, you might want to have more than one locked row at the top of your spreadsheet. Our tutorial below will show you how to lock a row in Excel, or how to lock multiple rows to make a large worksheet easier to manage....
However, you might find that clicking one of those links will cause it to open in Safari instead of Google Maps, thereby making it very difficult to get the driving directions that you might be looking for. Fortunately it is possible to re-establish the previous integration that caused those links to open in Google Maps instead of your browser. Open Links from Discord in Google Maps Instead of Safari The steps in this article were performed on an iPhone 7 Plus, in iOS 10....
Fortunately this is a setting that you can change on an individual worksheet basis, so it is possible to hide the page breaks if you no longer wish to display them. Stop Showing Page Breaks in Excel 2010 The steps in this article will show you how to hide page breaks that are showing in the Normal view in Excel 2010. Page breaks are typically shown in this view after you switch to either the Page Layout or Page Break view, then return to the Normal view....
Hiding Excel 2010 Row and Column Headings While Excel 2010 is typically used as a means or organizing and sorting large amounts of data, you can also use it for other tasks, such as creating forms or creating documents. For tasks like this, the organizational structure of Excel 2010 is not as helpful as it is when you are working with data, so you might wonder how to hide the row and column headings in Excel 2010....
Learning how to set a print area in Excel 2010 provides you with the option of choosing a group of cells in your spreadsheet that you want to print. Many spreadsheets, especially larger ones, often include data that is less important than other data. For example, you might have a report that lists every sale that your company has made in a month, but the name of the customer, or their shipping address, might not be important if you are looking at sales amounts....
But rather than manually re-entering all of those events, you might be looking for a better solution. Our tutorial below will show you how ot accomplish this by exporting your Google Calendar and then adding that file to your Outlook account. How to Use a Google Calendar File in Outlook Our guide continues below with additional information on how ot import a google calendar to Microsoft Outlook, including pictures of these steps....
You will find these by selecting the numbers buttons at the bottom left of the keyboard, then choosing the #+= button. While this will help you to add symbols like question marks or exclamation points, you probably noticed that there isn’t a degree symbol. Luckily there is a degree symbol that you can use, although it’s going to require one additional step. Our tutorial below will show you how to insert a degree symbol on an iPhone....
Configure the Windows 7 Desktop Background Slideshow The desktop background is edited through the Personalization menu in Windows 7. This is also the location in Windows 7 where you will go to set your screen saver and your windows colors, as well as a few of the other options that can really help you to make your Windows 7 installation your own. Begin by right-clicking the taskbar, then clicking the Show the Desktop option to display your desktop....
How to Block Location Requests from Websites in Firefox You can continue below for expanded steps on how to make Firefox always block location, including pictures of these steps. Many of the websites and services that you use on the Internet will rely on your location in some way. Whether it’s providing you with information about nearby stores or restaurants, or providing search results catered to where you are located, there is a lot of value in this type of personalized information....
Fortunately Twitter’s “Mute” feature is perfect for situations like this. You can use it to simply remove tweets from that account from your timeline for a brief period of time, then return later and unmute them. Our guide below will show you how to go about muting someone in the Twitter app on your iPhone. Muting an Account in Twitter on an iPhone The steps in this article were performed on an iPhone 6 Plus, in iOS 8....
This is something that you can do in Windows 7, and the methods that we will describe below can be used to change the default programs for a number of different file types on your computer. Set Photoshop as the Default for JPG Files in Windows 7 The steps below are going to change the settings on your Windows 7 computer so that anytime you double-click a file with the ....
We have written about ways to adjust the print settings in Excel 2010 so that all of your columns will print on one sheet, which can be the best solution if your spreadsheet is just barely too large to fit on a sheet of letter-sized paper. But if you have a lot of columns or a lot of data, then this can result in small text that is difficult to read....
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....
But if you have a flash drive and don’t know how to put your files on it, then using one might be a problem. Fortunately you can read our short guide below to learn how to copy your files to a flash drive. How to Copy Files to a Flash Drive This article is written on a Windows 7 computer, and is going to copy and paste the files from your computer onto the flash drive....
Recording An Audio Message on the iPhone 5 Fortunately the voice memo that you record is saved once you create it, so you do not need to worry about sharing it immediately after it has been created. For example, you could record something while you are walking down the street or exercising, then follow the steps needed to email the audio file once you get the chance. By default, the Voice Memos app on the iPhone 5 is stored in the Utilities folder, so the tutorial below will proceed with the assumption that it is still located there, as well as assume that you have set up an email account on your phone....
I spend a good amount of time working with UPC numbers in Microsoft Excel spreadsheets. One common situation that I encounter is when I have a complete UPC number but need to remove the last digit of the number. This is typically referred to as a check digit and is automatically generated based upon the rest of the numbers in the UPC. While this is a simple task with one or two UPC numbers, it is very tedious when dealing with hundreds or thousands of them....
An important distinction when you are creating and editing images in Adobe Photoshop CS5 is the distinction between layers and images. Many of the tools and utilities in Photoshop, especially those that change the size or orientation of your selection, will affect the entire image. We have written about flipping layers in Photoshop CS5 and rotating Photoshop CS5 layers, but both of those options will leave your layer the same size as it started....
Your Word document can contain a lot of different types of objects aside from plain text. This can include items such as pictures, videos, clip art and more. However, a document can also contain objects which present your text in a different way. One such object is the text box, which you can use to place document text that you wish to include outside of your main document. Text boxes include their own formatting options, and one of the options available to Word 2010 documents is a rotation element....
This can be frustrating if you are in a hurry, and it can happen with pages that have a lot of data on them. Luckily there is an option in the Safari browser on your iPhone that lets you scan a page for a word or phrase that you are looking for. Our tutorial below will show you how to search a Web page in Safari on your iPhone without leaving the browser....
This provides a more extensive text messaging feature that you can utilize when texting with other people on Apple devices. But you might be wondering how to send green texts on iPhone if you would prefer to utilize regular messaging instead of the iMessaging feature. How to Turn Off iMessage and Only Send Text Messages on an iPhone Our article continues below with additional information on turning off iMessage on your iPhone, including pictures of these steps....
