Creating a Custom Header in Microsoft Excel 2010 When you are printing the same spreadsheet periodically that is updated with current information, each version of the file will look very similar. In these cases it is important to incorporate a good header labeling system to keep your information organized. Using a custom header allows you to accomplish this by giving you a lot of freedom in the information that you include in the header....
But audience members can have questions, things can go wrong, and you might even discover that you need to clarify something that you hadn’t considered before. Due to these potential disruptions it’s helpful to know how to pause a slideshow in Powerpoint. There are a couple of different ways that you can pause a Powerpoint presentation, and the method that you use will be determined by the way that your slides are currently set up to progress....
These are the types of situations where you might only need to print a single column of your Excel spreadsheet. Fortunately this is something that you can accomplish in Excel 2013 with relative ease, so follow our guide below to learn how. Print Just One Column in Excel The steps below will show you how to print only one column of your Excel spreadsheet, which you will select. You will not be changing any settings for your spreadsheet, but rather you will be using a special function on the Excel print menu....
Formulas are a very important part of the Excel 2010 user experience because they allow you to automate calculations that need to be performed upon values in Excel. And while the result of those formulas’ calculations is typically the most important part of the equation, you may find yourself in a situation where you need to know how to print formulas in Excel 2010. The method for doing so is not very obvious, but it does exist....
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....
Your iPhone uses a technology called AirPrint that allows it to print to any compatible printer. The Officejet 4620 is compatible with AirPrint, which means that you can print from your iPhone to the Officejet 4620. Using AirPrint on an Officejet 4620 with an iPhone The AirPrint technology requires your Officejet 4620 to be connected to a wireless network. You can learn how to connect the Officejet 4620 to a wireless network here....
You have access to your purchased content through the iTunes Store, and you can download movies from that location directly to your iPad. This will allow you to watch purchased iTunes movies on the device, even when you do not have Internet access. Downloading Purchased Movies on an iPad in iOS 9 The steps in this article were performed on an iPad 2, in iOS 9. These same steps will also work for other iPad models running iOS 9....
Deleting Programs from the Dock on a Mac Your personal preferences will dictate the number of programs that you want in your dock, and there really is no right or wrong number to have. But it is very easy to have programs in your dock that you do not use very often, and those are the best programs to remove from the dock. Follow the steps outlined below to learn how to delete an item from your Mac dock....
It is the horizontal bar at the bottom of your screen that shows your Start button, shortcut icons, open windows and system tray. In fact, we tend to reference the taskbar a lot on this site when we are giving tutorials that require you to open Windows Explorer. For example, this article about showing hidden files and folders in Windows 7 requires you to open any folder on your computer, which we recommend doing from the folder icon in the taskbar....
One such file type is the portable document format, or PDF. You might have considered using an online file converter if you needed one of your iPhone pictures in the PDF file format, but there’s actually a way to do this directly on your iPhone, which we will discuss in our tutorial below. How to Make a PDF Copy of an iPhone Picture Our guide continues below with additional information on how to save an iPhone picture as a PDF, including pictures of these steps....
This interaction will prevent you from needing to copy and paste links, plus the title of the Web page will be included with the link, allowing it to be searchable from Spotlight Search. So continue below to find out how you can start saving to the Notes app from the Safari browser. Saving a Web Page to the Notes App on an iPhone The steps in this article were performed on an iPhone 6 Plus, in iOS 9....
How to Turn Off Zoom on the iPhone 6 You may then need to double tap on the screen with three fingers to return it to the default 100% view. Our guide continues below with additional information on how to shut off iPhone 6 zoom, including pictures of these steps. The text and content that you view on your iPhone can be difficult to view or read, due largely to the fact that you are viewing it on such a small device....
Have Word 2013 Open to a Document Instead of the Menu Note that you will still be given the option to choose from the available document types if you create a new document while Word is already open. So if you actually do need to create a flyer or an invitation, then you can still create that type of document. Step 1: Launch Word 2013, then select a document type....
But you may find that Firefox is automatically switching to the new tab when you do this, when you would actually prefer to stay on the current page. Our guide below will show you how to change this setting so that Firefox stop automatically going to a link that you have opened in a new tab. How to Stop Firefox From Automatically Switching to Newly-Opened Tabs The steps in this article were performed in the desktop version of the Firefox browser....
Turn Off iMessage on the iPad This is particularly important if you have an iPad, but it is being used by a child, or someone that you don’t want to see your text messages. However, it is also a setting that can easily be turned back on if someone knows where to look. If you are concerned about this, then the best solution is to use a different email address to create a new Apple ID, then set up the iPad with that instead....
But if you are uncomfortable with this and would prefer to keep your Apple Pay status a secret, then you can choose to block the check that these sites perform. Our guide below will show you where to find and disable that setting. How to Block the Apple Pay Check on an iPhone 7 The steps in this article were performed on an iPhone 7 Plus in iOS 10.3.3. Completing these steps will turn off the setting in the Safari browser that allows websites to check if you have Apple Pay enabled on your device....
But your iPhone has a handful of filters you can use to modify pictures, including a black-and-white one. We will show you how to use these in the tutorial below. How to Take an iPhone Picture That’s Black and White Our guide continues below with additional information on using iPhone Camera filters to change the appearance of your pictures, including images of these steps. If you play Pokemon Go and are having trouble with the game’s camera, then you can check out this tutorial and change a setting to help resolve it....
But you might eventually decide that you no longer wish to use the vibration feature to inform you of new notifications, and seek to turn it off completely. You can accomplish this in iOS 9 by disabling the Vibration setting that is found on the Accessibility menu. This will allow you to turn off vibration completely on your iPhone, instead of configuring the vibration setting individually for all of your notifications....
Disabling Photo Stream in iOS 7 Note that Photo Stream does not count against your iCloud storage space. It is a separate service that is handled differently than the rest of the data that is backed up to your iCloud account. You can find out more about Photo Stream and how it works on Apple’s site here. Additionally, when you turn off the Photo Stream, all of the Photo Stream images will be deleted from your phone....
Having to constantly press the Shift key before you type a letter can make it a surprisingly difficult thing to do. Luckily there is a simpler way to type in all caps on your iPad, which we will discuss in our tutorial below. How to Use Caps Lock on an iPad Our guide continues below with additional information on how to type with caps lock on an iPad, including pictures of these steps....
