Keep Column Headings Visible While You Scroll The reason for specifically freezing the top row in Excel is because most spreadsheets will use that row to label the type of information that is in that column. You can freeze other sets of data in Excel 2011 if you so desire, but this article is going to focus on just freezing the top row. Step 1: Open your spreadsheet in Excel 2011....

For some Excel users, this change is less than ideal. The ribbon takes up a lot of space at the top of the window, and it can be difficult to find various menu options if you are accustomed to navigating in Excel 2003. But while there isn’t much that you can do about this switch, you can elect to minimize this ribbon so that it only displays when you click on one of the tabs at the top of the window....

But Excel can be a little difficult to work with when you need to print out your spreadsheets, and it can be even more difficult to remember what a specific spreadsheet is for when you have a lot of them. That’s why it is important to include a header at the top of your spreadsheets to make them easier to identify. How to Add a Header in Excel 2011 This tutorial is specifically for the 2011 version of Excel for the Mac....

A Microsoft Excel file is called a workbook, and a single workbook can contain multiple worksheets. This is helpful when you have a lot of data for a single purpose, but which may not necessarily belong on a spreadsheet together. Excel workbooks will typically include three worksheets by default, but that number can be modified based on your current needs. Our guide below will show you how to create a new worksheet in an Excel 2013 workbook so that you can add information to your file without editing an existing worksheet....

Our guide below will walk you through the steps of adding an Excel worksheet to a slide as an object so that the data is displayed directly as part of the slideshow. Add an Excel Spreadsheet to a Powerpoint 2013 Slide The steps in this article will show you how to add an existing Excel worksheet to a blank slide in your Powerpoint 2013 presentation. If you simply want to create a blank worksheet on a Powerpoint slide, then you can do so by clicking the Insert tab, then the Table button, then clicking the Insert Excel Spreadsheet option....

Adding Slides from Another Slideshow in Powerpoint 2010 This tool is extremely helpful when you have an important informational slide that is valuable in more than one presentation. Once the slide is correct in one presentation, you can continuously add it to new slideshows without worrying about spelling mistakes or incorrect information. Additionally, if creating that slide required a lot of legwork that would be difficult to duplicate, you can take advantage of your initial hard work while simultaneously improving your new presentation....

The process for lending a Kindle book is only a few steps, but it can be difficult to find where you need to go in order to accomplish it. Our guide below will point you in the right direction so that you can begin sharing your favorite Kindle books with other people that you think might enjoy them. Lending a Book from Your Kindle Library Note that not every book that you have purchased for your Kindle can be lent to someone else....

Manually restarting a presentation repeatedly can be inconvenient and a waste of time, so an automated method is preferable in many situations. Our tutorial below will show you how to loop a Powerpoint slideshow by changing a setting for the presentation and defining the amount of time for which you want each slide to display. So if you are going to a trade show or showing a presentation on an unattended monitor, this will let you keep that presentation playing until you choose to stop it....

But if you spend most of your time browsing with Chrome, then you might like to use that browser instead. Our tutorial below will show you how to make the Chrome browser the default on an iPhone. How to Make Google Chrome the Default iPhone Web Browser Our guide continues below with additional information on how to make Chrome the default iPhone browser, including pictures of these steps. Related Topic: There is also a Google app that you can use to search....

While you may have discovered that you can sort playlists alphabetically, you may be looking for a way to put your playlists in a custom order. Our tutorial below will show you how to manually resort your playlist order using the desktop Spotify app for Windows. How to Put Spotify Playlists in a Custom Order with the Desktop App The steps in this article were performed in Windows 10, using the desktop version of the Spotify app....

Fortunately you can open recently closed tabs in the mobile version of Safari, although it is a bit of a hidden feature. Our tutorial below will walk you through the steps to follow so that you can start taking advantage of this option. Opening Recently Closed Web Pages in the Safari iPhone Browser The steps in this article were performed on an iPhone 6 Plus, in iOS 9. This method will work for other iPhone models that are also running iOS 9, as well as iPhone devices running the iOS 8 operating system....

How to Fit All Columns on One Page in Excel 2010 Our guide continues below with additional information on how to print all columns in Excel on a single printed page, including pictures of these steps. The Microsoft Excel Print Preview window is a useful tool when you are trying to make sure that your completed spreadsheet looks good before you print it. One area where you can have trouble with printed pages in your spreadsheet is simply getting your Excel spreadsheet to fit on one page....

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

Programs You Need When Learning How to Protect Your Computer This section is just going to provide a point of reference for the products that will be covered in this article. If you already know what each program does and simply want a repository of links for downloading these programs, then look no further. CrashPlan – passive backup program MalwareBytes – active scanner for malware. Requires you to initiate the scan Microsoft Security Essentials – my choice for a free anti-virus program, though Avast and AVG are also very good choices....

Step 1: Navigate to the Slickdeals website at www.slickdeals.net, then click the “Register” link at the top of the window. Step 2: Type your email address into the email field, create a username, create a password, then click “Register New Account”. Step 3: Click “My Account” at the right side of the window, then click “Deal Alerts”. Step 4: Click “Add a Deal Alert” at the right side of the window....

However, if you haven’t used an iPhone to record videos before, then you might be looking for an app or tool that is specific to that function. Our tutorial below will show you where to find the video recording option on your iPhone from the default Camera app. How to Use the Camera App to Record an iPhone Video Our guide continues below with additional information on how to use the video camera on an iPhone, including pictures of these steps....

Occasionally you may find that a workbook you are working on in Excel Online contains worksheet tabs that you don’t need. Our tutorial below will show you how to remove a worksheet tab in Excel Online so that you can simplify the navigation in your file. You can also read our guide on how to delete a sheet in Excel and learn how to do this in the desktop version of Excel as well....

Fortunately you can independently choose to remove gridlines from the printed page, and from the screen. Our guide below will direct you to the location in Excel 2013 where you can change these settings. Stop Gridlines from Printing or Appearing on Screen in Excel 2013 The steps below will show you how to adjust both of the gridline settings for a worksheet in Excel 2013. If you have multiple worksheets in a workbook, then you will need to make this change to each worksheet for which you do not wish to print or see the gridlines....

But occasionally you will encounter some network-related problems that you can’t seem to fix. Luckily there is an iPhone 6 reset network settings method that you can try which can resolve many of these problems. Our tutorial below will show you where to find this option. There are a lot of different ways to change the settings on your iPhone, so many troubleshooting guides will walk you through adjusting some settings, or locating information like your iP address, when you are trying to fix a problem....

Fortunately there is an option in Excel 2013 that allows you to quickly select all of the worksheets within your workbook, then apply a change to all of those worksheets simultaneously. So if you are in a situation where you need all of your worksheets in the same view, and you don’t want to go through every worksheet and adjust that setting manually, then our steps below will show you how to return all of your worksheets back to the Normal view....