Tip: You can perform common mathematical functions in Excel. Find out how to subtract in Excel with a formula. How to Stop Printing Color in Excel 2013 Note that following the steps below is only going to change the setting for the spreadsheet in which you are currently working. If you create a new file or open a different one, you will need to change the settings to print in black and white for that spreadsheet as well....
But a printed spreadsheet can be very different than one that you view on your computer screen, and your audience may have difficulty keeping data straight on anything printed after page 1. A helpful way to resolve this problem is to print the header column at the left side of every page. This can help to reduce confusion, and ensure that the intended information is being conveyed to your audience....
One situation that you might encounter is an image that seems to blend into the background of the slide, or is otherwise difficult to identify as a separate entity. In this case it can be helpful to add a border to that picture. Our guide below will show you how to use the picture formatting tools in Powerpoint 2013 to add an image to your slideshow. Do you also edit slideshows in Google Slides?...
There are a handful of different ways that you can open a program in Windows 10, but many people like to have their most-used programs on the desktop. Since there are a variety of ways to set an application as a default in Microsoft Windows versions, you may have already used some tech tutorials in the past that offered you a way to accomplish this. One of the simplest ways to set a default program, such as making Chrome the default Windows 10 browser, is to find the browser icon in the Start menu and drag it to the desktop....
How to Delete a Comment in Google Sheets Our guide continues below with more information on how to remove comments from Google Sheets, including pictures of these steps. Comments are really useful when you are collaborating on a spreadsheet with a team of people. Changes to a spreadsheet can often be difficult to communicate effectively in an email or a secondary document, so the ability to indicate the cell in question and attach your comment directly to the location is very valuable....
Fortunately your Netgear N600 router has a feature that lets you reserve an IP address for a device so that the DHCP feature on the router will assign that same IP address to the device. The device is identified via its MAC address, but you will be able to select it from a list of devices attached to your network, which will also list the device by its device name....
How to Restrict Stories in the Today Section of the iPhone News App Our guide continues below with additional information on how to restrict stories in the iPhone News app, including pictures of these steps. The iPhone News app provides a convenient location for you to curate a list of news that you would like to see from your favorite online content producers. Simply set up the app and choose the channels whose content you want to read, then open the app and see the current stories....
So if you open a Microsoft Word document and the page is either much smaller or larger, or you don’t see the page breaks that you are accustomed to, then you might find it a little offputting. Fortunately, you can get your Word document back to normal view by changing a setting on the View tab. How Do I Get My Word Document Back to Normal View? Our guide continues below with additional information to answer the question of how do I get my Word document back to normal view, including pictures of these steps....
But Microsoft Excel can be difficult to turn into something that is easily printable, and you might be struggling if you need to know how to save Excel as PDF on one page. Luckily you can take advantage of a couple of different settings in Excel that will let you create the type of file that you are looking for. How to Save Excel as PDF on One Page Our guide continues below with additional information on how to save Excel as a PDF on one page, including pictures of these steps....
Sure, you can copy and paste between certain apps, but that isn’t always a very easy task, particularly if you want to copy and paste a lot of text. Fortunately the Notes app integrates well with the Messages app, and you can send the text contained within a note as a text message. Forward a Note as a Text Message on the iPhone 5 I like this feature because I can type out a long message or idea in the Notes app without needing to worry about accidentally sending it part way through....
Luckily this is a setting that you can turn on off on the iPhone so that those other devices are not able to use the iPhone’s cellular connection to make and receive calls. Our guide below will show you where to find this setting so that you can disable it. If you are attempting to make a call to another country but your iPhone keeps adding numbers, then you might be wondering why does my phone say dial assist?...
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....
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 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....
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...
